How do you run query`s on a remote Access Database??

[JamesStenerson]

This question may sound dumb to most people, but I have to access a database on a network and run SQL statements against it. The databases sits on a Win95 box and they are Access databases (.mdb). The server (NT Server 4.0) does not have the IIS running. The only way I know how to connect to these databases would be through ODBC. However with no web server running, the request will not be processed.
Is there a way to run query`s on a remote database with no web server?

Please Help!!!

Thankyou

James Stenerson.

[Clunietp]

can you access the DB using a network share? If its over a LAN (not the internet), you'd be better off just creating a network share on one of your file servers

then you would connect to it as:
\\computername\sharename\dbname.mdb

instead of
c:\foldername\dbname.mdb

[jsayson]

Don't worry if you don't have a web server as long as you still have a file server. ODBC connections will of course still work and I think its still the easiest way to do it.

[JamesStenerson]

Thankyou very much, I will give it try. This is all kinda new to me so thankyou.

James Stenerson