Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 April 20th, 2005, 04:25 AM
Authorized User
 
Join Date: Jun 2003
Location: Swansea, , United Kingdom.
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default Possible to Create Acc 97 mdb from Acc 2000??

Hi,

I currently have a data warehouse set up in Access 2000. Is it possible, once the warehouse is updated, to run a subroutine to create a small access 97 database and export a few tables into this new 97 database?????

Thanks
Tim

Tim
__________________
Tim
 
Old April 20th, 2005, 02:03 PM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

I don’t think so. As you might know, when you open a 97 db in 2K, it will not allow modifying that db.

What you probably want to do is create intermediate files of the data that you want moved into 97, then use 97 to import those data. (Comma Separated Variable [.csv] files, fixed width text files, etc.)

You might be able to open a 97 db in VBA as a database object, to add, delete or read data. I'm pretty sure you will not be able to create a 97 .mdb, though.
 
Old April 21st, 2005, 04:05 AM
Authorized User
 
Join Date: Jun 2003
Location: Swansea, , United Kingdom.
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply. I didnt think about a "third party" option!! Sounds like the best way.

Many thanks

Tim

Tim




Similar Threads
Thread Thread Starter Forum Replies Last Post
reg hiding panel containing data acc to role veda Visual Studio 2005 1 July 8th, 2008 07:52 AM
copy table from one access database to another acc fabdulla SQL Language 5 November 21st, 2007 11:13 AM
How can add a scheduler in Plesk 7.5 which can acc mycwcgr ASP.NET 2.0 Basics 0 September 8th, 2007 08:01 AM
Error while creating User acc In AD spraveens Classic ASP Components 0 June 12th, 2004 08:17 AM
Underlining the entire line of a textbox in an acc Smokinn Access 1 February 3rd, 2004 07:04 PM





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