Microsoft Access 2000 .mdb files?

[jejacks0n]

I'm trying to create a simple database in Microsoft Access 2000..

Everything goes along fine, but I can't seem to open it correctly in visual basic.

It gives me an error message that says "Unrecognized database format."

Is there a way to create databases that can be used with Visual Basic 6 in MA 2000, or is there a way to read databases created with MA 2000 in VB6?

Either way is fine. =).

If not, I have a copy of Microsoft Access 2000 for sale at $90. Only used once. =).

[Edneeis]

What Data provider are you using? For MA 2000 you need to use Microsoft Jet 4.0 OLE DB Provider. That will solve your problem if not email me.

[gin]

If you're using DAO I think you have to use Microsoft DAO 3.6 (or higher, don't know if there is, not up to date) object library to be able to open the database

[maqmaq]

Read this Microsoft Article:
http://support.microsoft.com/support.../q238/4/01.asp

It may help...
Thanks

[AdrianH]

To manipulate Access 2000 like you would Access 97 with DAO then you need DA0 3.6. You also need to install Service Pack 4 so that the Data Control will recognise Access 2000.

If you wish to use Crystal Reports with Access 2000, you will need Ver 8.0 Developer edition.

Cheers
Adrian.

[jejacks0n]

To avoid the hassle for now (I can deal with learning these things a bit later), I'm wondering if anyone knows of a decent application that I can create a simple vb6 compatible .mdb database.

Any suggestions?

Thanks for the help guys. =).

[HunterMcCray]

Originally posted by jejacks0n
To avoid the hassle for now (I can deal with learning these things a bit later), I'm wondering if anyone knows of a decent application that I can create a simple vb6 compatible .mdb database.

Any suggestions?

Thanks for the help guys. =).

In your current project environment goto "PROJECT" on your task bar. Click on "REFERENCES". Un select the DAO reference that you are using (Probably DAO 3.51). Then Select DAO 3.6. Click "OK". Go Back to references and move DAO 3.6 Up the priority scale as far as it will go (I don't know hwy this makes any difference, but it does in some of my APPs). You should be able to access any Access 2000 .mdb file that was created using Access 2000 or updated by Access 2000. I have not used ADO yet, and have heard both good and bad about it. Mostly good from people who are looking for large scalable connections, mostly bad from people who are using small local Access Databases.

Hope this helps,

Hunter