Can set a ref to 1 open db but not another open db - error 3045
That was it exactly. Even though the db was always in "shared" mode, I
rebooted and the problem was solved.
Thanks for nabbing it.
Tim
Quote:
> Hi,
> some database are opened in an exclusive mode... (only one user can open
> them). That's not your case if you can open a second Access session with
the
> same database, but that's maybe a point to check.
> Hoping it may help,
> Vanderghast, Access MVP.
> > Oops..first posted in .ado ng
> > Why is it when I set a reference to an already open database, there is
no
> > problem....
> > Dim db As DAO.database
> > Set db = OpenDatabase(\\path\database.mdb)
> > But...
> > if I try it with another database:
> > Set db = OpenDatabase(\\path\database2.mdb)
> > I get the error:
> > Run time error 3045
> > Couldn't use '\\path\database2.mdb';
> > file already in use
> > Both databases are open when I run both scripts. What is wrong?
> > Thanks
> > Tim
