Converting Access 97 database to Access 2007 database

[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.

 

[Douglas J. Steele]

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.

 

[galit]

Problem with that is that I don't have Access 97. Any other suggestions?

 

[Guest]

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)

 

[Linq Adams via AccessMonster.com]

Since you're on this project you might want to take a look at Allen Browne's
site

http://allenbrowne.com/tips.html

He has an entire section on Upgrading!

 

[Tony Toews [MVP]]

When i try to fix it the way they suggest, i
can't even get into the design stage of the files.

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/