Access 2000 4.0 Provider line fails?
Thanks, that was indeed the problem. Someone should tell MS developers don't
like meaningless (from a program logic view) spaces!
Actually solving that probelm then caused a different error, which was
solved by running the workgroup administrator in MSOffice. (There was a
third error, which was solved by re-opening the database as shared; even
though the default was shared, this somehow opened in exclusive mode,
perhaps because I had created it from scratch and JET set it to the setting
it used when creating the db, i.e. exclusive.)
I still don't have ADO help though, but that's on another thread.
Quote:
> You should have a space between Data and Source.
> However that may not be the problem. Are you sure you have the 4.0 drivers
> installed?
> Later...
> Niels
> > Using Access 2000, this basic code fails on the second line with this
> > message: "Could not find installable ISAM,"
> > with error number -2147467259 (80004005). I'm using Windows 2000 beta 3
> > (2031). What's wrong?
> > Dim cn As New ADODB.Connection
> > cn.Open
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\User\prices.mdb;"
