Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old November 21st, 2003, 09:52 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
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
  #2 (permalink)  
Old November 21st, 2003, 10:29 AM
Authorized User
 
Join Date: Jun 2003
Location: , Quebec, Canada.
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
  #3 (permalink)  
Old November 21st, 2003, 11:29 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
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
  #4 (permalink)  
Old November 21st, 2003, 12:18 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
  #5 (permalink)  
Old November 21st, 2003, 03:10 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
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.