Run-Time Error '2950':

  • Thread starter Thread starter MeSteve
  • Start date Start date
M

MeSteve

I am getting the error above when I am trying to run code to access an Access
DB. The code is only ther eif the database is closed, I open the
database,BAM my code works. I think I understand the cause of the error, but
how do I work around it?

I am using:

Set db = OpenDatabase("<UNC PATH>")
Set rs = db.OpenRecordset("tbl_Projects")

How do I reference a database that is not currently open? Or do I need to
train people to have the database open before running the code?
 
The plot thickens!

It will not work if I open an .mde file but will work if I open up a .mdb
file. I am not willing to let people have the .mdb frontend.
 
Good theory, but the database IS trusted and in a trusted location AND the
code is actually being called form a powerpoint. Now any ideas?
 
Back
Top