Previous in Forum: Memory Stick   Next in Forum: Mathcad Trial Version
Close
Close
Close
3 comments
Rate Comments: Nested
Anonymous Poster

Connect to Access 2007

11/19/2007 12:17 PM

I need to develop a program to connect to access 2000 database. The drivers in VB6 is connecting to only Access 97. Kindly help me connecting to Access 200. Thanks in advance

Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Power-User

Join Date: Aug 2007
Location: Bridgeport, New Jersey, USA
Posts: 109
Good Answers: 6
#1

Re: Connect to Access 2007

11/19/2007 3:25 PM

Well, you're not really connnecting to an A2K database, you're connecting to a JET 4.0 database, if I remember my Access-to-Jet pairings. I am not familiar anymore with VB/6 but it should have a driver to Jet 4.0 databases... ??

A few more details might also be helpful.

__________________
"For a successful technology, reality must take precedence over public relations, for Nature can not be fooled." - Richard Feynman
Reply
Anonymous Poster
#2

Re: Connect to Access 2007

11/20/2007 9:02 AM

You will need to setup the ODBC connection for Access2007 to connect.

Reply
Anonymous Poster
#3

Re: Connect to Access 2007

11/20/2007 2:57 PM

Look up ADO and DAO in MS knowledge base. Forgotten which one is newer. You'll need to download the latest MDAC from MS.


Pineapple

Reply
Reply to Forum Thread 3 comments

Previous in Forum: Memory Stick   Next in Forum: Mathcad Trial Version

Advertisement