[RESOLVED] Access Startup Problem

[Mark Gambo]

I created an Access DB using Office2K Professional and I am using the Startup option to load a form when the program opens up. The database was working fine. Recently at work I got a new computer which had Office 2003 Professional installed on it. I need to make a few changes in the Access DB using Office 2003. I made the changes and saved. Now when other users who have Office 2K on the computer can't run the program. I checked under Tools --> Options --> Advanced Tab --> Default File Format = Access 2000. The file work fine with Access 2003. Any ideas?

[Mark Gambo]

Now I think I am on the right track. I was able to get the main form to load but it seems that my VBA code doesn't want to run. Hmmm, any ideas?

[salvelinus]

My guess is that something in the code changes is exclusive to Access 2003, either actual methods, etc, or references.

[DKenny]

Have you checked the macro security level on the machine in question? It may be set to high.

[Mark Gambo]

Have you checked the macro security level on the machine in question? It may be set to high.


Hmmmm, never thought about that, but thinking about it now I am not getting that Macro warning on my Win2K3 Machine anymore either. How would I go about resetting the Macro Security levels

[RobDog888]

Tools > Macros > Security.

[Mark Gambo]

Rob,

Thanks for the post. I just finished do that and my VBA isn't working on the 2K machines. Any other ideas?

[DKenny]

What level did you set to security to? It needs to be medium or low.

[Mark Gambo]

It was set to Medium but I changed it to Low Security

[RobDog888]

Low is not very good as you have no protection at all. Medium is fine as they can choose to run macros or not.

[Mark Gambo]

Low is not very good as you have no protection at all. Medium is fine as they can choose to run macros or not.


When it was set to Medium I wasn't getting the warning form.

[RobDog888]

Is your VBA digitally signed with a trusted certificate?

[Mark Gambo]

Is your VBA digitally signed with a trusted certificate?


I don't think so, how can I tell if it is?

[RobDog888]

In the VBA IDE you click on "Tools > Digital Signature..."

[Mark Gambo]

In the VBA IDE you click on "Tools > Digital Signature..."


No certificate, but I just found a machine with Office 2K and the db works so it obviously has to be something with the office packages on those two machines. Thanks for you help everyone :thumb:

[Mark Gambo]

One other thing regarding the two machines. The Machine with Office 2K that can run the MDB also has VB6 installed where as the other two machines don't. Hmmmm, I will investigate and if I figure it out I will report back.

[RobDog888]

Could it be an MDAC version issue? You can download the Component Checker utility from MS to see what version is installed on a system.

[Mark Gambo]

Could it be an MDAC version issue? You can download the Component Checker utility from MS to see what version is installed on a system.


It is possible I will check it out.

[RobDog888]

Download page from here:
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

Hot to diagnose issues from here:
http://support.microsoft.com/kb/q307255/

[Mark Gambo]

Download page from here:
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

Hot to diagnose issues from here:
http://support.microsoft.com/kb/q307255/


Thanks for the links but I went to our MIS Department and got a new computer that had Office 2K3 installed, and the problem was solved. I let the MIS guys figure it out but they will wipe the drive and start fresh.

[RobDog888]

Cool! A least your MIS department works well with you.

Hey, can I get a new system too? Preferrably a P4 3.8 Ghz Dual Core. ;)

[Mark Gambo]

Cool! A least your MIS department works well with you. . .



Well when your department reports to the Big Boss Direct you usually get whatever you need pretty fast and even sometimes price is no object. :bigyello: :D