Transfering an old Access database

esm · 01-06-2008, 01:01 PM

A friend of mine has an old Access database on an equally old PC and he has asked me to transfer the entire kit and kaboodle to his new PC. I know I can export/import the database file but what about the customization stuff? Can that be transfered too or do I have to customize from scratch?

Thanks a bunch.

**Glaswegian** · 01-06-2008, 02:55 PM

I'm not really sure on this. I know that if you try to open an older db Access will ask if you want to upgrade it to the more modern version. As to what customisation etc may be lost, I guess that will depend on the different versions on each machine.

**sobeit** · 01-06-2008, 02:59 PM

what version is the old and what version is the new? Depending upon the features of the database, its difficult to know if the whole thing will transfer or part of it. If its a simple database, the there should be no problems, if theres a lot of fancy formulas and macros, then there may be some problems.

esm · 01-16-2008, 12:52 PM

I just found out that the old version is Access 2000, the new version is Access 2003.

**Glaswegian** · 01-16-2008, 01:37 PM

I would copy the whole file to the new machine and double click to open. You should bet a message about converting to a newer version - see what happens and what, if anything, is lost. Worth a try, as you'll still have the original file.

01-06-2008, 01:01 PM	#1 (permalink)
esm Registered User Join Date: Nov 2003 Location: austin, tx Posts: 71 OS: Win XP Pro	Transfering an old Access database A friend of mine has an old Access database on an equally old PC and he has asked me to transfer the entire kit and kaboodle to his new PC. I know I can export/import the database file but what about the customization stuff? Can that be transfered too or do I have to customize from scratch? Thanks a bunch.

01-06-2008, 02:55 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,537 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Transfering an old Access database I'm not really sure on this. I know that if you try to open an older db Access will ask if you want to upgrade it to the more modern version. As to what customisation etc may be lost, I guess that will depend on the different versions on each machine. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-06-2008, 02:59 PM	#3 (permalink)
sobeit TSF Enthusiast Join Date: Nov 2007 Location: NEAR Posts: 7,433 OS: windows/linux	Re: Transfering an old Access database what version is the old and what version is the new? Depending upon the features of the database, its difficult to know if the whole thing will transfer or part of it. If its a simple database, the there should be no problems, if theres a lot of fancy formulas and macros, then there may be some problems. __________________ there's been global warming since the ice age

01-16-2008, 12:52 PM	#4 (permalink)
esm Registered User Join Date: Nov 2003 Location: austin, tx Posts: 71 OS: Win XP Pro	Re: Transfering an old Access database I just found out that the old version is Access 2000, the new version is Access 2003.

01-16-2008, 01:37 PM	#5 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,537 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Transfering an old Access database I would copy the whole file to the new machine and double click to open. You should bet a message about converting to a newer version - see what happens and what, if anything, is lost. Worth a try, as you'll still have the original file. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner