Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics 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 August 11th, 2004, 01:46 PM
Registered User
Join Date: Jun 2004
Location: wilmington, de, .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Select the correct version of Access 97/2000

below is a small part of my code which opens a specific database 2000 but for some reason access 97 object opens causing my code to bug. Is there a way to specify which version of access you need to have open using vb?

Dim app As Access.Application
   Set app = CreateObject("access.application")
      app.Visible = True
       app.OpenCurrentDatabase ("C:Pending_Clear_ADS.mdb")

  #2 (permalink)  
Old August 11th, 2004, 05:22 PM
Friend of Wrox
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post

had a similar issue when I was trying to automate XL from Access, I needed to change the REFERENCES used by the code for each release of Office so that it would work, I am sure that there should be a way to programatically do it, though I ended up with an Office 97 and an Office XP release.
  #3 (permalink)  
Old August 16th, 2004, 03:54 AM
Authorized User
Join Date: Aug 2004
Location: , , .
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts

I usually use Excel - when it is generally preferable to set up using the oldest version likely to be in use. MS Office is usually backward-compatible.

Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Select correct child node richieWolf XSLT 4 September 24th, 2008 08:53 AM
Convert 97 to 2000 jonyBravo Access 1 May 25th, 2006 07:33 AM
Coverting from Access 2000 to 97 timmaher Access 1 August 18th, 2004 08:47 AM
Access 2000 to Access 97 happygv Access 5 April 23rd, 2004 10:06 AM
Migrating from access 97 to access 2000 Khalifeh Access 12 October 2nd, 2003 02:54 PM

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