Open a recordset from a DB on a Web Site

[richardn]

Is this possible to open a recordset from a table ina database, where the mdb file is situated on the web.
I mean, if I know the exactly path to the database ( the URL ) what's the sintax to open a table , and can I open this recordset for multiple users ?
Regards,
Richard

[The_Doc_Man]

The problem has two parts.

Can multiple users use a remote DB at once? Depends on how it is defined. It is possible to be defined for shared opens. So I guess I would have to say yes.

How to open it remotely? Map a drive letter to that server, which will require a login account on the server. It will also require the server to be set up to share the drive to authorized users. You might also run into firewall-type security issues with the server's network manager.

Now if the server doesn't support really GOOD security (which already rules out most Windows versions in existence), you are doing just about the MOST dangerous operation you can envision. And in that case, when your network manager is done chewing on you, the security manager will probably want to add a few tooth marks.

Oh, by the way.... if you do go this way and your service provider provides your service based on traffic levels, you just bumped yourself up to a whole new level!

Remote file serving on an INTRAnet is already slower than garden slug races. Now do this over the INTERnet, with the possibility that someone might be using a {gasp} DIALUP line.... with file locking turned on .... Gives a whole new meaning to the term "latency."

Usually, the way to do remote DB access is: The DB is opened locally on the server with some sort of database-enabled web server package. It presents things to its web users through Active Server Pages (ASP), which can be created from Access 2K and above.

This approach DRASTICALLY reduces net traffic. Doesn't necessarily change security issues, though.