Link to home
Start Free TrialLog in
Avatar of titorober23
titorober23

asked on

connect to remote back end

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
Avatar of trbaze
trbaze

Are you talking about connecting access to sql or connecting to sql without access?
SOLUTION
Avatar of DcpKing
DcpKing
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Armen Stein - Microsoft Access MVP since 2006
Armen Stein - Microsoft Access MVP since 2006
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial