Co'z everytime I run the program it always says "invalid database format" . I really think that the problem is on the creation of database in microsoft access. Pls. help me! can you give me the step by step instruction in making a database on access. thanks!
2007-01-03 13:47:50 · 4 answers · asked by Rain 1 in Computers & Internet ➔ Programming & Design
Hi..Normally when the error invalid database format appears when the database and the connection string is not up to each other's standard. If you are using Ms Access 2000 or Ms Access 2003 make sure to use the latest MDAC. Also use the provider version 4.0. Normally creation of database in Ms Access is quite standard. So the problem is not on the creation of the database. But its the connection which is not proper. If u r using ODBC, check if your ODBC is correct for the current Ms Access version you are using. If you still face problem you can post me the connection part of the code and I can help verify.
2007-01-03 14:03:29 · answer #1 · answered by Vera 1 · 0⤊ 0⤋
Any database created using MS Access can be used by Visual Basic. You have to create the proper ODBC and thats all.
2007-01-03 13:51:25 · answer #2 · answered by zubair_1999 3 · 0⤊ 0⤋
search the Microsoft website for "Microsoft Data Access Components" and you will get a file you need to download and install to connect VB to Access
2007-01-03 13:55:53 · answer #3 · answered by Richard H 7 · 0⤊ 0⤋
using VBA Application using Google Search "VBA Access"
2016-05-23 01:12:27 · answer #4 · answered by Anonymous · 0⤊ 0⤋