2003 database opens fine in XP, problems with Vista

[BrittaF02]

Hi,
I have an Access 2003 database stored on a Windows 2003 server that I can open just fine in XP or 2000, but it is not functioning properly in Vista. When I open up the database, it gives this error: "The form name 'Server_Form' is misspelled or refers to a form that does not exist" This obviously cannot be true since it works fine in XP and 2000.

I already tried:
Opening Access 2003 as admin
Opening Access 2003 in safe mode
Confirmed that I am running the most current version of the Genuine Advantage control on my laptop.
Have the latest version of Access 2003 (SP3)
Running the MGA Diagnostics tool: it found nothing wrong

I did not write the database and I know nothing about access aside from data entry and compacting the database. Please help!!

 

[Remou]

Have you checked the references to see if any are marked MISSING?

 

[BrittaF02]

I tried, but I am not sure that I understand how to do that.

I did the following:
1. Opened database.
2. Press ALT+F11 to switch to the VB Editor.
3. Tools, References.
4. Any check boxes that are marked as MISSING.

The top four boxes have checkmarks next to them. Nothing for those items says missing and then none of the unchecked boxes have the word missing in them either.

??

 

[Remou]

What happens when you chose to debug the code?

 

[BrittaF02]

How do I do that?

 

[Remou]

Chose debug in the code window. It is on the toolbar.

 

[BrittaF02]

It says "Compile Error: Ambiguous Name Detected: SaveButton_Click".

 

[Remou]

You need to clear that error. Search for SaveButton_Click, you can only have one for each form code page and you can only have one in general modules.

 

[BrittaF02]

I'm not really following you. Pardon my ignorance, but why would I have problems with a database only in Vista? It works fine in 2000 and XP.

I am not sure how to identify a form code page or general module when looking at the VB script. Thanks.

 

[Remou]

There may be more than one compile error, so it is important to clear each as it occurs, it is possible that one of the errors shows why it will not work at all in Vista. It is possible that the form with the above error has not yet been used in XP, so the error does not show up.

A form module will have the word Form. For example:

Form_Form1

It will also be under the heading Microsoft Access Class Objects in the Project Explorer. You can show the Project Explorer by pressing Ctrl+R.

An 'ordinary' module will be under the heading Modules in the project explorer.

It is worth simply searching for SaveButton_Click, there may be only two. To search, choose Edit->Find from the Menubar of the code window and make sure that you select Current Project. Once you have found the problem procedures, that is, the two or more copies of SaveButton_Click, you will have more problems in that the error must be corrected. You can do this by re-naming the extra versions, but this needs to be done with care or your code will no longer work. I would suggest that you use a copy of the database.

 

[BrittaF02]

I wanted to give my "resolution" for this issue for others to reference. I downgraded my Vista machine to Access 2000 and it works fine now with no errors. Thanks.