Database for standalone application

[Wowbagger_TIP]

I'm looking into the possibility of creating a standalone application that will be distributed to certain employees of the company I work for. I was considering using Access 2000 as the database backend for the VB frontend. The problem is that not all of the users have Access 2000 already, and some have Access 97 or a different service pack level than I do. Now I'm only going to need to have the database file accessible to this application, so I don't need the whole Access package. I just want to know if there is a way that I can reliably connect to and communicate with the database file without having to install Access on their computer. I am thinking that I can use ODBC for this, but was wondering if there are any issues that I should be aware of or if there is a better way. Can anyone help with this?

Thanks!

[hellomadhu]

You can goahead.

There will not be any problem and the user's system doesn't need to have access2000 installed.

All u should do is create a setup for ur application ans install it on the users machine. it will install the necessary files to connect to access2000.

Happy coding !

[Wowbagger_TIP]

lol... I asked this question elsewhere as well and got a different answer! Someone else told me that if I use DAO or ADO in my VB project to communicate with an Access db, it would install whatever version of the JET DLLs I have on the user's PC, possibly screwing up their installation of Access if it is a different version than mine. Can you confirm or deny this?