March 10, 2006 at 9:10 am
I have recently migrated from SQL2K to SQL2K5 and have a number of front ends in MSAccess Forms that worked fine with SQL2K but are not working with SQL2K5. I am able to connect and view the data in the SQL table using a file DSN but I am unable to update the records from the MSAccess form in SQL2K5. I have also attemted to update the table from the design grid in ACCESS and receive the message "operation must use an updatable query"
I have checked all of the permissions and have even given the Login dbo privs. I have also allowed remote access through the Surface Area Configuration Tool. What am I missing?
Thanks in advance for any assistance.
March 10, 2006 at 4:28 pm
Problem solved !
The problem was related to the Linked Table not having unique identifiers(key) for updating identified. MSACCESS normally prompts you for the key fields when the Linked Table is created but for some reason I either missed the prompt or it wasn't presented. In any case once I selected the field every thing worked fine from both the form and design grid.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply