Hello All,
I have one table that is giving me problems. Access is the FE, SQL Server 2014 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...:banghead:
I can make changes via SQL query in the SSMS.
I've relinked the table...not sure what to check next.
Thanks in advance.
Mike
I have one table that is giving me problems. Access is the FE, SQL Server 2014 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...:banghead:
I can make changes via SQL query in the SSMS.
I've relinked the table...not sure what to check next.
Thanks in advance.
Mike