Access 97 to Access 2000 question 1

[TomMoe]

I've moved my Database from Access 97 to 2000 and now my application cannot access it!
I suppose this would be a matter of the drivers, how can I solution this what do I need?
I have Service pack 2 and MSDAC 2.6 for VB, what else do I need? Will Service Pack 4 solution this?
Also if I move from Excel 97 to 2000 and if I use the excel object as an OLE on my form would I also need new drivers?

 

[WildWill]

Are you referencing Access through you VB app or are you connecting via ODBC?

If it is the former you would of included the Microsoft Access 9.0 Object Library in your VB Project. For Access 2000 you need to use the Microsoft Access 9.0 Object Library Billy H

bhogar@acxiom.co.uk

 

[TomMoe]

Sorry didn't explained well.
I'm connecting to Access from my VB app via ADO.

 

[WildWill]

When we down loaded ADO 2.6 the site indicated that there was sill issues relating to this product (threading etc) have a look at that, Try 2.5

Which provider are you using Jet 3.51 or Jet 4.0? Billy H

bhogar@acxiom.co.uk

 

[woyler]

WildWill is correct, You need a Jet4.0 reference.

 

[TomMoe]

hmmm I was using 3.51, so what do I need to use 4.0?
I have MSDAC 2.6 so does this include Jet 4.0?

 

[WildWill]

You will find the Microsoft Visual Basic version 4.0 : JET Update Kit @:

http://www.microsoft.com/downloads/release.asp?ReleaseID=30638

Billy H

bhogar@acxiom.co.uk

 

[TomMoe]

ok, I figured I do have Jet 4.0 installed, but on the connection string have only 3.51... I'll change that.
Anyway I installed service pack 4 now so I won't have this kind of trouble anymore...

And WildWill, where do you find Microsoft Access 9.0 Object Library ? Even with SP4 I can only find out the 8.0 version in the references?

 

[woyler]

Are you running Office2000?

 

[TomMoe]

no, I mean on the pc I'm developing the app I have office 97, but then I will install it on a machine with office 2000. The Access I have on my pc is 97, but this will then be installed on machines with office 2000 and the users will be able to edit the database so I really need to make it work with 2000 also.

I can't find Access 9.0 Object Library on the references, must I have Office 2000 installed for them to show up? It makes sense in deed.

 

[TheDrider]

You must have a reference to ADO, of course, but this will allow you to connect to the database. dbName in the example is the Path and Filename of your MDB.

    Dim conNFL As ADODB.Connection

    Set conNFL = New ADODB.Connection
    conNFL.Provider = "Microsoft.Jet.OLEDB.4.0"
    conNFL.ConnectionString = "Data Source=" & dbName
    conNFL.Open

 

[TomMoe]

thedrider: I know how to connect to the database via ADO that's not the problem. I just can't find Microsoft Access 9.0 Object Library under the references menu although I have SP4.
Anyone can help me out on this?

 

[WildWill]

Tommoe: It comes with office2000 Billy H

bhogar@acxiom.co.uk