Search results

  1. M

    Access append to SQL Server - slow

    Hello, I've read several previous posts in the forum, but still don't have a solution for my problem. I have a weekly excel sheet to upload to a SQL server table.Each week the table is cleared of all data and the new data uploaded. If I use MSSMS it takes about 6 mins (33,000 rows with SQL in...
  2. M

    Solved Access front end -to- SQL back end

    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...
  3. M

    Access linked table to remote SQL

    Hello....looking for some help with how to do this. I have a local Access database and want to take one of my tables and put it on a SQL server in AWS and then link to it from my Access database. IT has setup an instance for me to use, but as of now I only have the user/pass. Can someone...
Top Bottom