I have developed an application program in VB 6.0 using which the program creates a database (in MS Access format) using the data structure provided by the user at run time. By default the database is created in MS Access 97 version (using CreateDatabase() function). While there is no problem in opening the databases created in MS Access97 format, there is a run time error (unknown data format) in opening a database created or edited using MS Access 2000.
Please provide me a solution (a brief program code in VB 6.0) on the following aspects -
1. To open a database created or edited in any version of MS Access (97 or 2000 or later)
2. To create a database in any version of MS Access (assuming a user intervention for creating the database in a required version)