Can set a ref to 1 open db but not another open db - error 3045 
Author Message
 Can set a ref to 1 open db but not another open db - error 3045

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



Sun, 02 Feb 2003 03:00:00 GMT  
 Can set a ref to 1 open db but not another open db - error 3045
Solved!

Both databases were "Shared" on Default Open Mode in Tools => Options =>
Advanced.

For some reason re-booting solved the problem.


Quote:
> 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



Sun, 02 Feb 2003 03:00:00 GMT  
 Can set a ref to 1 open db but not another open db - error 3045

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.


Quote:
> 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



Mon, 03 Feb 2003 03:00:00 GMT  
 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



Mon, 03 Feb 2003 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Error 3045 on Set db = CurrentDb

2. opening a access db while in anouther db

3. Opening a DB from within a DB

4. Mail merge from Access try to open an already open DB

5. DB opened, do I need to open again?

6. Connection not Open + Server has not yet been opened error messages

7. Db open or not?

8. DB-Library error 10040: DB-Library network communication layer not loaded

9. Open DB Error

10. VB tries to Open MS Access DB [ERROR]

11. Error Tarpping on db.Open

12. Jet error trying to open a db on another machine in a W98 network

 

 
Powered by phpBB® Forum Software