468,315 Members | 1,418 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,315 developers. It's quick & easy.

Connecting Access Front End to Remote SQL Server

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?

Jul 23 '05 #1
0 1068

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Roy | last post: by
92 posts views Thread by Jeffrey P via AccessMonster.com | last post: by
6 posts views Thread by Todd Brewer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.