Post reply

Linked Table To MS Access error

  • 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.

  • 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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply