Run-Time Error '2950':

[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?

 

[MeSteve]

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.

 

[Robert Morley]

Are you using Access 2007, by any chance? It's a guess, but it sounds like
maybe you're being hit by this, or some non-macro variation of it:

http://support.microsoft.com/kb/931407


Rob

 

[MeSteve]

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?