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 - 31 Dec 2007 20:24 GMT
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.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Hi -
>
[quoted text clipped - 17 lines]
>
> Thanks and happy new year.
galit - 31 Dec 2007 20:41 GMT
Problem with that is that I don't have Access 97. Any other suggestions?
> Try removing the reference from the Access 97 database before you convert
> it.
[quoted text clipped - 23 lines]
> >
> > Thanks and happy new year.
david@epsomdotcomdotau - 31 Dec 2007 22:26 GMT
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)
> Problem with that is that I don't have Access 97. Any other suggestions?
>
[quoted text clipped - 25 lines]
> > >
> > > Thanks and happy new year.
Linq Adams - 01 Jan 2008 12:21 GMT
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!

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Tony Toews [MVP] - 01 Jan 2008 20:51 GMT
>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

Signature
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/