June 18, 2019 at 9:34 pm
Hello All,
I have one table that is giving me problems. Access is the FE, SQL Server 2016 is where the BE is.
I am currently using DAO to access the BE tables. I have one table that gives me an error stating the I cannot make changes because another user is already making changes. I've checked the FKs and constraints, closed and re-opened Access...
I can make changes via SQL query in the SSMS.
I've relinked the table...not sure what to check next.
Thanks in advance.
June 18, 2019 at 9:37 pm
Can other people make changes to it?
Trying to establish whether the problem is with the table itself, or with your Access instance.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 19, 2019 at 10:57 pm
I discovered that the mistake was all mine. A number did not match up with the FK table. However, I did learn more about DAO Errors collection!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply