[RESOLVED] Access Startup Problem

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?

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?

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

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

Quote:

---

Originally Posted by DKenny

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

Tools > Macros > Security.

Rob,

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

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

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

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

Quote:

---

Originally Posted by 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.

---

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

Is your VBA digitally signed with a trusted certificate?

Quote:

---

Originally Posted by RobDog888

Is your VBA digitally signed with a trusted certificate?

---

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

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

Quote:

---

Originally Posted by RobDog888

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:

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.

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.

Quote:

---

Originally Posted by 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.

---

It is possible I will check it out.

Download page from here:
http://www.microsoft.com/downloads/d...displaylang=en

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

Quote:

---

Originally Posted by RobDog888

Download page from here:
http://www.microsoft.com/downloads/d...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.

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. ;)

Quote:

---

Originally Posted by RobDog888

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