Problem with server

Hi, I developed an aplication in vb6 which connects to a database in access. In my computer there was no problem accessing to the database saved in a remote server. I did get an error message when I installed the aplication in another computer which didn´t have Access installed. I tried changing the database file location, so I saved it in another server and I didn´t get the error anymore.

At my workplace, none of the servers have any Office components installed by law. I asked the difference between both servers, it is the Operative System. The one with the problem has Windows 2000 Server installed, and the other one (which worked fine) has Windows 2003 Server.

My question is if anyone knows what component can be installed in the server with Windows 2000 Server that doesn´t present any complications? (The server has installed all the updates and service packs and it´s the one I must use for this purpose). By law we can´t install Access in the servers, nor in the clients.

I hope I made myself clear, thanks!

If your code tries to create an Access object you must have Access installed on the computer that's running your code.

Otherwise you can use an access file as datastorage using ADO from your application, but you can't use any features that require Access itself, like reports, macros, forms etc.

I understand, thanks Doug!