Linked Table To MS Access error

• mjdemaris

  SSC-Addicted

  Points: 499

  More actions

  June 18, 2019 at 9:34 pm

  #3654977

  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.

• Phil Parkin

  SSC Guru

  Points: 247125

  More actions

  June 18, 2019 at 9:37 pm

  #3654978

  Can other people make changes to it?

  Trying to establish whether the problem is with the table itself, or with your Access instance.

  ---

• mjdemaris

  SSC-Addicted

  Points: 499

  More actions

  June 19, 2019 at 10:57 pm

  #3655529

  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!