Access 2000 mdb to Access 2003/7

Mainframeguy

Debiant by way of Ubuntu
Joined
29 Aug 2002
Messages
3,763
I have a feeling this is something of a long shot, but here goes....

A recent charity assignment sent me to maintaining some Access 2000 reports (I did not write the database application)... Well I spent a morning and realised I need to tinker extensively.

So it seems to make sense to me that I just copy the .mdb files, one for the data and one for the table structure and macros etc that make the database app.

But then I get home and try it out and it asks for the database filepath (understandably) and when I point it to the .mdb files it says not a valid file and although I can get to see the data I cannot get the application with the reports and input buttons etc.

I do not have access (sic) to ACCESS 2000 at home, I have an XP box with ACCESS 2003 and a Vista one with ACCESS 20007.

Does anyone know of anything I can do to get this to work? Or am I doomed to have to return on site and do the job there?

[EDIT] or is there a format or method of saving I can ask them to employ and resend me the information so that it will successfully be useable in 2003/7? [/EDIT]
 
Last edited:
Can you not just tell 2003 to open it as a 2000 format file or import it?
 
no there does not seem to be an option to do that - but I have since found my oldest rig is running Access 2000 - so I am attempting to go from there as of today
 

Members online

No members online now.

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.

Forum statistics

Threads
62,015
Messages
673,498
Members
5,626
Latest member
FayWilley
Back