How to continue using MS Access but link to MS SQL or MySQL?
Monday, 1st February 2010
by teabag99
I have a client who uses an access mdb database for admin purposes. The clients web application connects to this database to dynamically display information online. I am aware that Ms access is a desktop database application not designed with the web in mind - If more than six users are connected to the database, through the site, concurrency issues may arise.
What I want to know is -
Is there a way for my client to continue administration using ms access, and have access link to a database sql server more suited to the web, such as mssql or mysql?
Thanks in advance.
|