|
-
Jan 30th, 2008, 10:50 PM
#1
Thread Starter
New Member
 [RESOLVED] Connecting VB5 to MDB's later than 1997
Setting References to "Microsoft DAO Object Library" and similar allow me to connect to Access Databases from 1997 Office very well.
However, they do not seem to connect to latter versions of Access.
Is there another reference or work around to this problem?
I am old programer, and have VB5 under my belt. Some of the latter versions of VB leave me wondering what it is all about.
-
Jan 31st, 2008, 02:36 AM
#2
Re: Connecting VB5 to MDB's later than 1997
you can use ADO (microsoft activex data objects), add a reference to the whatever version you have installed, or download the latest version (2.8 i think), search under MDAC, you can find tutorial for connection in database forum
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed 
pete
-
Jan 31st, 2008, 07:33 AM
#3
Re: Connecting VB5 to MDB's later than 1997
Welcome to the forums. 
What, specific, versions of Access are you interested in connecting to?
-
Jan 31st, 2008, 04:18 PM
#4
Thread Starter
New Member
Re: Connecting VB5 to MDB's later than 1997
 Originally Posted by Hack
Welcome to the forums.
What, specific, versions of Access are you interested in connecting to?
The latter version of Access that I have provides tools to conver to 2000 and 2002 versions in addition to my 1997 version. I would like to be able to connect up up to either of these latter versions.
-
Jan 31st, 2008, 05:35 PM
#5
Thread Starter
New Member
Re: Connecting VB5 to MDB's later than 1997
Originally Posted by westconn1
you can use ADO (microsoft activex data objects), add a reference to the whatever version you have installed, or download the latest version (2.8 i think), search under MDAC, you can find tutorial for connection in database forum
Thank you for your prompt response.
Being new to this sort of thing, could you direct me to the web site where i might download 2.8 and the location of the forum where i might find the tutorial?
Sorry to be such a dummy!
-
Feb 1st, 2008, 12:48 AM
#6
Re: Connecting VB5 to MDB's later than 1997
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Feb 1st, 2008, 10:42 PM
#7
Thread Starter
New Member
Re: Connecting VB5 to MDB's later than 1997
Originally Posted by westconn1
GOT IT !!!!!
Thanks very much
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
