VBA Project

[TashaSpicer]

I am completely clueless about VBA so I am really stuck.

My database was created in Access 2007, but has been saved down to allow use by 2002 - 2003 Access, and has been split to allow for multiple users.

When I try to go in now at the entry file, I get the following error message:

The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delte the VBA project.

When I select OK, it closes the file. I have a backup created, but when I try to open the file again I get the following error messages repeatedly:

'ParentIdName' is nt an index in this table
'IdName' is not an index in this table

This just cycles several times when I hit OK and then it kicks it out to create a new database, and will never open my original file.

When I try to open the back up file I get the following error message:

The Microsoft Office Access database stopped the process because you and another user are attempting to change the same data at the same time.

I have removed the files from the shared drive and pulled them to my desktop so I could work exclusively so there can't be anyone else using the file at the same time.

I had contemplated just recreating the database and importing the existing information, but I can't get to the information to import it.

I am so lost and cannot figure out what to do. Can anyone offer any assistance?

Thanks!

Tasha

 

[Galaxiom]

The VBA is corrupted. You need to restore your database from a backup. You can copy the VBA from the backup into your latest version but you will need to remember what you have changed between the two versions.