Reply
Old August 8th, 2007 Top | #1

OSNN Folding Team  
Mainframeguy's Avatar
Debiant by way of Ubuntu
Joined: August 2002
Location: London, UK
Posts: 3,763
Blog Entries: 5
Reputation: 1390
Power: 169

Question Access 2000 mdb to Access 2003/7

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]
Mainframeguy is offline   Reply With Quote
Old August 12th, 2007 Top | #2
 
LordOfLA's Avatar
Godlike!
Joined: February 2004
Location: Salisbury, Wiltshire, UK
Posts: 7,031
Blog Entries: 5
Reputation: 4137
Power: 213

Default Re: Access 2000 mdb to Access 2003/7

Can you not just tell 2003 to open it as a 2000 format file or import it?



If HK-47 and GLaDOS had a child, the character they create would cause the video game world to overdose on awesome. -sheridanmovieguy: Dragon age forum user.
LordOfLA is offline   Reply With Quote
Old August 14th, 2007 Top | #3

OSNN Folding Team  
Mainframeguy's Avatar
Debiant by way of Ubuntu
Joined: August 2002
Location: London, UK
Posts: 3,763
Blog Entries: 5
Reputation: 1390
Power: 169

Default Re: Access 2000 mdb to Access 2003/7

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
Mainframeguy is offline   Reply With Quote

Reply

Bookmarks

Thread Tools

Posting Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 legacy app Mainframeguy Windows Desktop Systems 2 September 7th, 2007 9:07am
Access 2003, technical issues. GEN3RIC Web Design & Coding 1 March 28th, 2006 11:33pm
Access 2003 in urgent need of help with project. VenomXt Web Design & Coding 0 December 3rd, 2005 12:13pm
Restricting Logon Access to an 2000/XP network Steely Windows Desktop Systems 1 March 6th, 2002 4:00pm
Access Rights - XP on 2000 SRV Net INETGuy Windows Desktop Systems 1 January 30th, 2002 1:07pm