Search results
-
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... -
M
Solved Access front end -to- SQL back end
Nulls for that field are allowed in the SQL table. -
M
Solved Access front end -to- SQL back end
What has happened is that I am not a developer, or that great with Access, however, the process works well locally. That being said, the one query that is problematic is due to inefficiency. When it ran locally it wasn't an issue. Every week I import new data, and Step 1 is to set a field to... -
M
Access linked table to remote SQL
Cheer, got that sorted, now to work on the efficiency.- mahjohn
- Post #3
- Forum: SQL Server
-
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... -
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...- mahjohn
- Thread
- Replies: 2
- Forum: SQL Server