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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"galit" <(E-Mail Removed)> wrote in message
news:07C5982E-8E89-4FB2-9582-(E-Mail Removed)...
> 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.

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

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "galit" <(E-Mail Removed)> wrote in message
> news:07C5982E-8E89-4FB2-9582-(E-Mail Removed)...
> > 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.
>
>
>

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" <(E-Mail Removed)> wrote in message
news:87113DF4-5C32-419B-B30E-(E-Mail Removed)...
> Problem with that is that I don't have Access 97. Any other suggestions?
>
> "Douglas J. Steele" wrote:
>
> > 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.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "galit" <(E-Mail Removed)> wrote in message
> > news:07C5982E-8E89-4FB2-9582-(E-Mail Removed)...
> > > 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.
> >
> >
> >

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!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

galit <(E-Mail Removed)> wrote:

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