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

 

[Galaxiom]

The users can connect using Remote Desktop to run the front end on a local computer.

Professional versions of Windows operating systems support one RDP user. Otherwise you can set up a server to do it (after paying Microsoft a considreable sum).

 

[russb]

Hi Galaxiom, many thanks for your reply. The scenario is of winning captains entering the score of games on a results form. So I don't think using Remote Desktop to be option as the user can be anyone who can sign in. Please correct me if I am wrong, my knowledge of putting interactive forms on the web is zero. Users may enter via an iPhone or computer. With your experience in this area does my scenario change your solution? Cheers Russ.

 

[Galaxiom]

Access 2013 has web capabilities but I don't know anything about it.

Otherwise and more commonly a web site is written in PHP or ASP to produce dynamic html. Forms are html forms and the events run javascript. Basically it is a start again from scratch scenario though I have heard of applications that can convert from Access to ASP.

Although the backend can be Access it is more usually SQL Server or MySQL. This part is the least of your problems.

 

[russb]

Hi Galaxiom & AccessBlaster <P> I think the Access 2010 + SharePoint is the solution I am looking for. I will do more research in this area. Thank you both for providing guidnace. Russ

 

[Pat Hartman]

A simplistic, non-web solution is to have them email the results either in a spreadsheet or an outlook form. Outlook should be set up to shuffle these emails to a specific folder and your app can process them from that folder and then move them to a completed folder.

 

[russb]

Thanks Pat, I like your thinking. This is a solution that removes the learning curve required with developing the web approach. Thank you for your time and expertise. Russ.

 

[Pat Hartman]

I like the KISS method You should be able to find samples of how to read emails from Access. It will still be a challenge but less so than creating a web interface.