ODBC Connection to Access DB on Web Server?

[tyleri]

How do I set up an ODBC connection to an Access Database I have on a Web Server? I want to have a database on my local computer that links to tables on the server.

I am using Win2k.

 

[Falcon99]

Hmmm . . .
If no one responds, this question might be off-topic here. Try posing this to the Microsoft: Access Other Topics forum.

 

[dilettante]

You have to remember that Access isn't really a connectable database. The "ODBC driver" for Access is really just an API-layer over Jet. What this means is that your client machine has to be able to see and open the MDB file, which is what the Access ODBC interface does.

The only "standard" way I'm aware of to do what you suggest is to use Remote Data Service (RDS). In most cases today this is locked down at the server and unavailable due to security concerns.

RDS relies on code running under IIS that actually opens the database (the proxy ). Your client makes requests of this code via IIS, typically using the RDS DataControl. This is all very ADO-like however - there is no "ODBC" interface and I don't think Access can "link" to tables this way. I could be wrong though.

You can find some details at:

http://msdn.microsoft.com/library/d...mscoverviewofremotedataservice.asp?frame=true

The only other way might be a 3rd-party ODBC engine for Access. I've never seen one myself.

So I'd guess you are out of luck unless you can expose file-sharing on your web server to your client machine somehow. Access wasn't made for this sort of thing.