linked table/adding a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My MS Access application is the front end to a SQL database.
I add a field to the SQL table (1 bit).
Then, in MS Access, I refresh the links through table manager.
Sounds correct, but non of the previous data can be changed!!!
If I open a form and change any field, I get an error saying the data has
changed and asks me if I want to save it to a clipboard??

Help
 
Did you provide a default value for the bit field in the SQL Server? Is the
field updated? I rarely if ever use a bit field. I prefer tinyint since it
gives me more freedom.
 
Yes the default is (0)
Yes I updated the table which has the field in it and it does show up on the
Access table.
I'm using a bit field because this field in Access is a Yes/No field.

So, any idea why it locks all the fields in that table????
 
Why would you say "this field in Access is a Yes/No field" when the field is
in SQL Server? You can use a tinyint field in SQL Server and display a check
box on a form or report. Does your linked table have a primary key that
Access understands?
 
Back
Top