Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Converting Access 97 database to Access 2007 database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
galit - 31 Dec 2007 18:41 GMT
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/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.