I'm unable to create a database application using visual basic 6 enterprise EDITION. When I put the address in the "DatabaseName" property of "Data" control and then want to select the table using "RecordSource" property, it says: Unrecognized Databse FORMAT. I'm using a .mdb Microsoft Access databse. I'd like to know why it is not working.
Thanks.What control are you using to link to the table?

You need to be using the ADO Data Control. The properties and methods are similar to the old DataControl.

Good luck. I used the MS ActiveX Data Object Control but it does not have "DatabaseName" property so where to ENTER the .mdb database name ? It just have recordsource Assuming you're up to date with VB and MDAC service, you need to make a reference to the Microsoft ActiveX Data Objects 2.8 Library.

Both the RecordSource and the Databasename are properties. The Databasename field allows the user to visually find the database on the system. The RecordSource field will bring up a list of the tables and allow you to choose one.

You can also do this by CREATING a ADODB.Connection and a ADODB.Recordset from within the code. I usually do this as it allows more flexibility.

Another thing you might try is to create a DSN through the ODBC Data Source applet in the control panel.

Good luck.