Access error - You don't have permission (3033)

[DannyLondon]

Hi Folks

I am really, really perplexed here.

I have an Access database with is secured by an mdw file. I use a shortcut to open the file, and automatically execute code within it. The shortcut contains the user, password and command line argument, eg:

/user UserID /pwd Password /cmd Auto

This has been working fine for the last couple of weeks.

This week, however, things are not happy.

The shortcut opens the file and starts execution of the code. At the first call to the current database, however, the 3033 error is raised (You do not have the necessary permissions to use the xxxxx.mdb object. Have your system administrator establish the appropriate permissions for you).

This database call is:

Set rs = CurrentDb.OpenRecordset("MyQuery", dbOpenSnapshot)

What perplexes me is:
- I have already connected to the database, and am working within it. I don't understand how the security loses track of this and generates the error.
- Why this would suddenly change from working to not working. I don't think anything has changed over the weekend within the environment, and the mdw file has not changed.

Coincidentally (perhaps), I had to re-establish all of the linked tables within the databases this week, as the encrypted passwords had disappeared and I was being prompted for them each time I tried to connect.

Any help that people could offer would be greatly appreciated.

Thanks

Danny

 

[lameid]

Perhaps the system running it is no longer joined to the workgroup or you were not when you recreated the links...

You can use the "/wrkgrp" to specify the workgroup file in addition to the switches you are using.