How to edit MS Access tables via web

[russb]

Hi

I have an MS Access 2007 desktop database that has been in use for many years. Of the numerous tables, I have three tables that now require users to update some fields via the web. I do not want to move to SQLServer Express, SQLite, MySQL, PostgreSQL... as they are not my skill set.
My question is what is the best architecture to achieve this end so I can automate the presentation data from my desktop to the web pages and have any updates appear back on the desktop?



Cheers, Russ

[rpeare]

well there are options in access2010 that allow you to make a web database, but the functionality of those is limited to macros, in other words you can't use vb script in your database. If you can automate all the functions you want through queries and macros then I suppose it's possible to build a web database with the same structure as your current db and import your data. I am lean on building web databases myself though so if you go that way I don't know how much help I'd be