All vb code lost

[davea300]

Hello

I have a database designed in Access 2003. I have tried to open it using Access 2010 on Windows 7 but when I do so none of the buttons work. Looking at the design view does shows the [Event Procedure] next to the On Click action but when I go to view the code nothing is there.

When I now open it using Access 2003 I get the same, all the code is missing for every button.

I thought it might jusy be missing references but the database still seems to work on Windows XP machines that just have access 2003 installed.

Have I confused matters by installing 2 versions on the same machine?

Any suggestions for a fix?

 

[pr2-eugin]

Your VBA is gone forever I guess ! I only hope that you have a backup somewhere lying around.

 

[davea300]

It's not as I have front end client installs on various machines and it's working on them ok so I can get the working file back at any time. Just seems to be on certain PC's that, when opened, the code disappears. I was guessing that it's beacuse a newer version of access has been installed.

 

[JHB]

Only a thought, look at the security settings - running macros!

 

[davea300]

Just double checked Macros are sitting at 'low - not recommended'

 

[JHB]

Okay and you checked on the computer which has the problem!
But as pr2-eugin writes, your code in that particular database is gone forever, so you need a new copy each time you made any change, for checking.

 

[davea300]

Yes I checked on the PC that has the problem. I have a copy of the front end file on my local network. It works fine when copied to all of the client machines. It's just the windows 7 machine with access 2003 and 2010 installed that I have this problem.