Admins with no permission

T

Terry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Removing Admin Permissions from my database 1
Current user does not have permission to convert or enable databas 3
Logon Screen Password Affects Ribbon Capabilities 1
No Read Permission Error 4
Do not have necessary permissions to use object (Error 3033) 4

Top