How to create a database in Microsoft access that can be use in visual basic?

Question

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!

Answer 1

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.

Answer 2

Any database created using MS Access can be used by Visual Basic. You have to create the proper ODBC and thats all.

Answer 3

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

Answer 4

using VBA Application using Google Search "VBA Access"