A database has been running quite happily with Access 2002 and Office 2000.
It is now being run on Office 2002 and Access 2002. The references have been
adjusted.
The line
Set Sn = CurrentDb.OpenRecordset(sqlText, dbOpenSnaphot)
comes up with the error "You do not have the necessary permissions to open
the db.mdb object. Now db.mdb is the database containing the code and the
user is the Owner of the database with full access rights.
If you open the immediate pane and enter ?CurrentDb.Name you get the same
error.
The problem goes further. If you stop the code and just continue running the
database the problem goes away - the next call to this line works. If you
close the database (but not Access) the problem does not re-appear when you
re-open the database. However, if you close Access and the re-start the
database the problem re-appears.
Any ideas?
Terry
|
Similar Threads
