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.
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.
You will need to have Access 2016 installed on your computer in order to open the example.
Watch the video below to learn more about working with forms in Access.
Juan Soto is a Senior Access Developer at IT Impact Inc. He specializes in Access with SQL Server databases.
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.
They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables.
We recommend using Active Directory and trusted links as your best scenario.
While you can always enter data directly into database tables, you might find it easier to use forms.
Forms ensure you're entering the right data in the right location and format.
For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables.
For example, in the Orders Table below the Customer ID field is linked to the Customers table.