quick access question

[wengang]

I'm thinking the answer is no to this, but can an Access database be put on my web server and then accessed by an app that I write running on the computer?

I know SQL Server can, but this is a small project for sb else and I don't want to put them on my db.


Oh, if the answer is yes, what does the conn string look like?

For possible workaround, I'm thinking of using an invisible webbrowser control, maybe put some of the code in ASP and run it server side, just use the software like a wrapper.

The idea is an app that only three or four computers will ever use, but they need the same data (doesn't have to be live synced or anything, but at least regularly synced)

Anybody?


Thanks.

[jmcilhinney]

SQL Server can because SQL Server is a proper server and that server supports HTTP. Access is just a file. You would generally write a web service to sit between your app and your database. The web service then connects to the database a s local data file and the app makes calls to the web service.

[Ecniv]

Yeah through ado and asp. Put your db into a secure area, and using ado connect to it. ASP coding can talk to mdb.

But as mdb is not the most secure in the world, uh, ever depends what you are thinking of holding on it.

Change to MySql database instead?

Edit:
My thinking is that your ASP part can take a processing (CGI?) type post as though from a form on a html page. Then return a html file. Your program can read that file and grab the bits it needs... Just one option tho.

Extra Edit:
Think there was something in ADO about connecting to shared mdb on online server ... never used so not sure, perhaps a search of google?