Error 2950 in Access 2007

[marcodl]

I am in the process of deploying my applications under Access 2007. They work fine on my computers. However, some of my clients cannot start the application but only the ribbon is shown and a '2950 error' for starting the AutoExec macro is shown. This - I thought - has to do with Security Centre Settings.

I have found a Microsoft' answer for that error:

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

I have followed all their steps. I have added the path of the .mdb as Trusted in the 'Trust Center', I have kept the option of 'Display Info bar' ON. I have said 'Run all Macros irrespective of whether they are signed' (I
know this is not recommended). I have checked the 'Trust all network locations' box. I have also added a Form and added the AutoExecute macro which should show that Form if the ADP is not trusted. This form does not display.

BUT, I continue to get the same 2950 error when starting up.

I also read on other forums that Access needs to be run with Administrator rights but even that does not solve the issue ...

I have spent hours on this in the past few days searching the web for all possible solutions and read up everything possible but without any progress.

Any help is much appreciated.

Marco

 

[Remou]

Have you considered digital signing?

http://office.microsoft.com/en-us/access/HP010446121033.aspx

 

[slurpee55]

Check out this link:

http://www.pcreview.co.uk/forums/showthread.php?p=10529596#post10529596

at the bottom of the page.

 

[marcodl]

Thx for the suggestions.

Indeed one can change all its macro's to VBA. However, the problem I encounter is with the AutoExec. It contains only one command: run procedure called VbaAutoExec. But even then the error remains.

Signing the database: you propose to sign the database myself?

I understood that by trusting the database-map the signiture would not be necessary anymore. The trusting works fine at home but not on my clients computer who also has Vista and Office 2007.

Marco