Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 21st, 2003, 09:52 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default Convert to earlier version?

Is there any way to 'downversion' an Access database?

I have a database which is in Access 2000 format, and I need to transfer it to a system which has only Access 97 installed. It is not possible to upgrade the target system (due to an intransigent IT department :().

The database contains a few tables, forms, reports, and queries, so it will be annoying to export these one at a time. Is there any other way to do it?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
__________________
-- Jeff
 
Old November 21st, 2003, 10:29 AM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can do it in Access 2000. Open the database you want to convert. Chose the option "To Prior Access Database Version" In the menu Tools\Database Utilities\Convert Database. I should to the trick.

Stéphane Lajoie
 
Old November 21st, 2003, 11:29 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

That was exactly what I was looking for. Thank you!

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
 
Old November 21st, 2003, 12:18 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The only problem will be if there is any code at all in the forms, reports, etc. Also if the tables have cascade updates and cascade deletes, 97 does not support them.

If anything was created with ADO in 2000 will have to be referenced in 97. Make sure to test all objects to make sure they work after the downgrade. Do a decompile of the code to make sure that there is nothing outthere that could come back and get you.

Actually, do a compile in 2000 and make sure it compiles, then after downgrading it, compile the 97 version. it should show any code that could cause any problems.



Sal
 
Old November 21st, 2003, 03:10 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Yeah, I had considered that.

Actually, it turns out that the database was originally written for Access97. It was converted without incident to Access2000 a while ago. We just recently uncovered a need to convert it back for somebody's laptop. Fortunately, the code is straightforward and compiled in both versions just fine.

Thanks for the heads up, though.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Oh! Another Version mike_remember ASP.NET 3.5 Basics 3 September 18th, 2007 09:51 AM
Passwords from version 1 to version 2 Maxxim BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 February 6th, 2007 06:49 PM
Which version UNCLEBENZ Visual C++ 1 November 2nd, 2005 05:39 PM
Upgrading project from earlier version of Spring? djmnyc BOOK: Expert One-on-One J2EE Design and Development 1 November 7th, 2003 12:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.