connect to a database file

[jamesoc]

hi, when connecting to a database manually after i
1.make sure the database exists
2.draw the data control object on the form
3.open the properties window and select the database i want 4. double click on database name property
5.select the file i want
6.i then go to recordsettype select which ever type as it messes up with all of them
7.go to record source i get a error window with the statement unrecognised database format
any ideas on whats happening
the database is stored as Z:\MYDATABASE.25.02.05.mdb

 

[Homersim2600]

Perhaps you are not using the appropriate database driver to connect to the database. Just a thought...

"As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein

 

[bjd4jc]

You will want to install the latest service pack for you visual basic. Do a search in this forum for a link or go directly to the downloads section of microsofts website.