I have a web site on a remote, shared host with a bunch of individual
Access databases. I want to switch my databases from Access to MS SQL
and have some questions.
I update some of my Access databases through web-based content
management systems. Other databases I update locally (through a bunch
of Access forms) and FTP them periodically to my web site.
I want to be able to switch my databases over to SQL, store them on a
remote SQL server and continue to update them via a local interface
(forms in my Access front end.) (1) Could someone recommend a good
tutorial for this? I'm not sure where to begin.
For some of my databases, I also want to continue to allow people to
update the database via my web-based content management systems and at
the same time use an Access front end for my local users. (2) Are
there any problems with both interacting with the database via the
Access front end and my web-based content management system at the same
time?
(3) Since my web site (and SQL Server) is on a shared host, are there
problems I might encounter? I am able to connect to my host's SQL
server via the Enterprise Manager installed on my local MS Small
Business server. (4) Will my Access front end also have to reside on
my local Small Business server, or can it reside on my local client
computers?