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
thanks and regards