Cannot read Access2000
Cannot read Access2000
(OP)
Hi, I have tried to read Access2000 from Visual Basic 6 and error occured " Invalid file format " If you don't mind please tell me what can I do ?.
Thanks
Thanks
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Cannot read Access2000
Were you using ADO to open a connection to the Jet Database?
What version of ADO? 1.5/2.0/2.1/2.5? ADO 2.1 is the best.
2.5 is for Windows 2000. Wouldn't use that in a production system just yet.
What version of the Jet driver? 3.x or 4? Use 4.
If this isn't close to a solution to your problem please reply with full description of your problem and the solutions you have tried to date.
Regards
RE: Cannot read Access2000
Aniway thankyou for your reply
Regard
HBL
RE: Cannot read Access2000
First create your DAO recordset and then assign it to the data control.
set db = opendatabase(access2000 mdb)
set rs = db.openrecordset("select * from table")
set data1.recordset = rs
now the Data control has the Access2000 recordset.
also see Microsoft's article on the subject
Q238401 - PRB: Getting Unrecognized Database Format Error Message When Upgrading to Access 2000
Hope this helps
Jon