Connecting to Database

[anastasia]

Hi,

I am trying to connect to a database from VB 6. I am using the Data Control and I can connect trhpough this to the database (the path is entered), but when I atttempt to select the RecordSource property of the data control I get the error Unrecognized database format followed by the path name to my database.

The Database was created in Access 2000. I was wondering if I will have to use Access 97 or something, someone please reply to confirm that this is the problem?.

Thanks

 

[JAG14]

You do not have to use Access 97,

You must download VB6 Service Pack 5 from Microsoft, which contains the Jet 4.0 Engine for Access 2000 databases. you will be able to download it from

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/default.aspx

This should work fine, hope it helps.

[tt]"Very funny, Scotty... Now Beam down my clothes."[/tt]

 

[anastasia]

Hi JAG14,

Thanks for your reply I have downloaded the service pack you mentioned above, do you know where I now extract the files to, which folder?.

 

[neoice]

Hello,

Just create a folder called vb5SP and extract to there. Then click on the setup icon to install.

To solve your issue immediately just convert your database to access97.

neil