I have an Access database on a remote web server. Currently I am using VBScript to create .asp forms to communicate with it via the Internet. Instead, can I create a local Access database on my desktop and link it to the tables on the remote database over the Internet so that I can use local forms, queries, and reports as front-end for the remote database?
It that isn't possible then can I migrate the remote Access database to SQL Server and achieve the same objective?
It that isn't possible then can I migrate the remote Access database to SQL Server and achieve the same objective?