Same queries, same database, same place, not in network.
His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server.
He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73.
The first one is NEVER use a combination of linked tables with local tables in your queries.
Instead download the server side tables as temp tables in your app or upsize your local tables to SQL Server and do the processing on the server in it’s entirety.
If you wish to have Juan speak at your next group meeting you can contact him here.
Hello, I’m having problems with some update queries in access 2013, I used those queries in access 2010 and they used to run very fast, but now they never finish.
Don’t do massive update queries using Access If you ever need to update a lot of records at once, say, increase pricing on all items by 10%, you’re much better off doing the update via a pass-thru query or on the server directly. Limiting data to just a fraction of records at any given time.
We recommend using Active Directory and trusted links as your best scenario.Juan Soto is a Senior Access Developer at IT Impact Inc. He specializes in Access with SQL Server databases.