Refresh Next Set db = Nothing Refresh Linked Tables = True Exit Function End Function Thanks @Gord Thompson. I'm not 100% and I'd like to remove it if I can. We want users to authenticate via Windows Authentication (again, legacy app that'll hopefully get moved to the web or a 3rd-party solution one-day), and we know it works this way. Connect, 1, 5) = "ODBC;") Then 'We only need to refresh a single table. I can insert records using query design in MSAccess But I cannot update nor Delete when run delete query below, the error is: could not delete from specified table I have full access to the sql database and I can run the query OK using sql management studio.Is it impossible to delete and update using query design inside MSaccess?? unless there is another way to configure the link table to allow update and delete without it right click on the linked table and select "Linked Table Manager", select the table you want to re-link, and hit OK. I would have chased my tail on this one for quite a while.Open notepad and get ready to copy the DESCRIPTION of the linked table’s construction.In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access.Although the user may have been granted db_owner role rights in the underlying SQL Server database, that user is unable to make data definition changes (DDL changes) to the table.I'm working with a legacy Microsoft Access database that we've recently updated to use linked tables/SQL Server backend.
I suppose I could delete the linked table, but I'd much rather get the programmatic refresh working like the standard one does. After altering the SQL Server tables to use datetime instead of datetime2, the below code worked just fine: Option Compare Database Option Explicit Function Refresh Linked Tables() As Boolean Dim db As DAO. The weird thing is I can insert new records using query design inside MSaccess thank you Open the table through your Access database, create a new test entry with bogus data, and then close the table. In the case that you can't manipulated the table on Sql Server, you can get around the problem by telling Access which/s column/s are meant to be the primary key.Re-open the table, select the test record and hit the DELETE button on your keyboard. This is done on the last step of creating a Linked table, the window title is "Select Unique Record Identifier".Let's take a look at both of those situations one step at a time.Let's start with modifying a Linked SQL Server table's structure.