Converting Access 97 database to Access 2007 database

  • Thread starter Thread starter galit
  • Start date Start date
G

galit

Hi -

I am working on a coupld of databases (not sure if they are linked together
or not) in Access 97 for a client. The client will like to upgrade their
appilcations at the office to Office 2007. I need to convert the database to
Access 2007. When I opened it in 07, i received a few notifications - main
one being that the "...project contains a missing or broken reference to the
file 'dao2535.tbl' version 3.5" When i try to fix it the way they suggest, i
can't even get into the design stage of the files. On another one i was able
to get to the design and removed the missing files from the tools->reference.

Any suggestions what to do with the first database?

Thanks and happy new year.
 
Try removing the reference from the Access 97 database before you convert
it.

Open any code module (or simply open the Debug window using Ctrl-G), select
Tools | References from the menu and uncheck it.
 
Use the /decompile option.

Make a backup copy of your database.
Create a shortcut to MSACCESS.EXE

Modify the shortcut by adding the path to your database.

Modify the shortcut by adding /Decompile.

"c:\ whatever \msaccess.exe" c:\mydb.mdb" /decompile

Use this shortcut to open the database. Open
the VBA project and remove the broken reference.

I haven't tried this with 2007.

(david)
 
galit said:
When i try to fix it the way they suggest, i
can't even get into the design stage of the files.
Click to expand...

That sounds like that MDB wasn't converted to A2007 but left in A97
format but opened in A2007.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top