Question Do Access databases have to be uploaded to we host

[goodfu]

If you want to have a website read and write data to an Access database is there any way to have that database on your own computer so that you can read and write to it yourself directly?

 

[boblarson]

Not unless you have IIS installed and have opened up your computer as a web host, which your ISP probably doesn't allow (if you are talking about on your home computer). If at work, no you probably can't because I doubt IT or your boss will like it to have your computer exposed directly to the Internet and therefore your network.

 

[Banana]

I'm also aware that some have succeeded in using Access database as a web host, but since your intention is to use it interactively, I think you'll find it a bad idea. Why not just use a free RDBMS (SQL Server Express? MySQL? PostgreSQL?) that you can place on your web host, base your websites on it, then link your Access database to the server's tables instead of using Access table. I think you'll find it much more seamless that way.

 

[goodfu]

Thanks for the info.