Hello,
Looking for some help in understanding what's going on and what my options are to resolve this.
I run a local access database, pretty simple tables and queries. The database needs to be migrated to a remote SQL server, accessible only via VPN. ODBC connection, uploaded, and linked some tables to Access as a front-end.
The problem I have is speed...it could take 45mins to run a simple delete or update query that would be completed almost instantly were it local. Can someone explain to me how Access works with linked tables, and why it would take this long?
Do I need to have Access running on a server on the same network as the SQL instance and connect via RDP, or possibly convert the qrys to Stored Procedures and execute via a command from Access (don't know how to do this)
Any ideas....thanks
Looking for some help in understanding what's going on and what my options are to resolve this.
I run a local access database, pretty simple tables and queries. The database needs to be migrated to a remote SQL server, accessible only via VPN. ODBC connection, uploaded, and linked some tables to Access as a front-end.
The problem I have is speed...it could take 45mins to run a simple delete or update query that would be completed almost instantly were it local. Can someone explain to me how Access works with linked tables, and why it would take this long?
Do I need to have Access running on a server on the same network as the SQL instance and connect via RDP, or possibly convert the qrys to Stored Procedures and execute via a command from Access (don't know how to do this)
Any ideas....thanks