Error opening 2003 db in 2003 AFTER it was opened in 2007 1

[vpellerito]

There are people with different versions of Access in my office (2000 to 2007). I created a database in 2002-2003 that opens alright in 2007. However after it is opened in 2007, I can't open the database in 2003 (my version). The database closes due to the error giving my the option to create a back-up. I normaly have to create a new Access file (2003) and import objects from the corrupted file.

Has anyone experienced this problem and figured out why?

Thanks.
Vince

 

[Hap007]

Hi,

When you opened the db in Access 2007, did it convert to 2007 format?

Did you make any changes to forms/reports/code in 2007?

I suggest that you open back up in MS Access 2007 and see if you have an option to convert to an earlier version? If so, then convert back to MS Access 2003/2002 format and be very careful when using MS Access 2007 in the future.

I would also suggest that you makesure you have an Frontend (Forms/Reports/queries/code) and a Backend (Tables).
Then link the frontend to the backend.
Final Step, have a version of the frontend on each user's PC and this will not happen again. If you can not have a Frontend version on each user PC, then at minimum, have a Version for MS Access 2002/2003 users to use and a version for MS Access 2007 users.

Final thought, take your frontend and make it a compiled MS Access 'mde' file. Then, no conversion should occur.

Hope This Helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121