View Single Post
  #1 (permalink)  
Old August 11th, 2004, 01:46 PM
setyna setyna is offline
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")