Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)Flag for United States of America asked on

Access Linked Table unable to update or delete existing records in SQL Server Table

SQL Server 2005, Access 2003. Linked tables in Access. I can add new records but cannot update or delete them once added.

Kevin
Dialog1.bmp
Dialog2.bmp
Microsoft AccessMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
zorvek (Kevin Jones)

8/22/2022 - Mon
Kelvin Sparks

This usiually appears when you have a form bound to the data, and you then have some SQL that is updating the data other than through the form interface, and then you try to do just that.

Is usually solved by requerying the form after each VBA data change to commit the record & reload.
ASKER
zorvek (Kevin Jones)

No forms. Just a linked table.

Kevin
Kelvin Sparks

How are you connecting. Is this a mdb via ODBC or adp?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
zorvek (Kevin Jones)

ODBC. I'm currently thinking it has something to do with a Bit datatype I defined in SQL Server.

Per chance, do you know how to define a boolean in SQL Server that shows up as a True/False value in Access?

Kevin
ASKER CERTIFIED SOLUTION
Kelvin Sparks

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
zorvek (Kevin Jones)

That solved the problem. I also found some notes on using timestamp - it is a bigint which Access can't handle either. The solution was to use datetime and set the default value to getdate().

Thanks!

Kevin