I have an Offsite Development Project that is working fine offsite
1. Can add records with queries.
2. Can Edit Data directly in form and in a linked table image in Access DB Front End
3. Can Delete record in Front End.
The Customer IT folks set up the Onsite Server. I do not have direct access to that. I use Remote Desktop to a PC that I have local admin rights.
The database they are using was copied directly to the Remote Desktop computers local C: drive. A beta test User onsite has a copy on his local drive.
We are both experiencing the same problem.
1. We can create a record.
2. We cannot edit or delete once the record is created. Either directly in the table link or in a Form.
When trying to edit the record we get an error that states:
This record is being modified by another user. Do we want to save changes, save to clip board or disregard.? The Save changes option is grayed out.
We do not have SMSS installed on either machine so cannot test using that method.
All machines are Using this driver: Microsoft ODBC Driver for SQL Server Version 17.03.0001
Any Ideas?
Thanks
1. Can add records with queries.
2. Can Edit Data directly in form and in a linked table image in Access DB Front End
3. Can Delete record in Front End.
The Customer IT folks set up the Onsite Server. I do not have direct access to that. I use Remote Desktop to a PC that I have local admin rights.
The database they are using was copied directly to the Remote Desktop computers local C: drive. A beta test User onsite has a copy on his local drive.
We are both experiencing the same problem.
1. We can create a record.
2. We cannot edit or delete once the record is created. Either directly in the table link or in a Form.
When trying to edit the record we get an error that states:
This record is being modified by another user. Do we want to save changes, save to clip board or disregard.? The Save changes option is grayed out.
We do not have SMSS installed on either machine so cannot test using that method.
All machines are Using this driver: Microsoft ODBC Driver for SQL Server Version 17.03.0001
Any Ideas?
Thanks
Last edited: