troubleshooting Question

connect to remote back end

Avatar of titorober23
titorober23 asked on
Microsoft AccessMicrosoft SQL ServerJoomla
4 Comments3 Solutions676 ViewsLast Modified:
Hi,

I have a database in ms access(front and back end) - we are planning to upsize it and move the back end to sql server.
I need to have remote access to the database, how can i accomplish this

i know you can remotely connect to a sql server, but how do i tell the system, look for the back end in the remote server.
internally i can do an odbc connection, but how will it work remotely

please help

thanks and regards
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros