Recordset not Updateable

[Guest]

I have inherited a database that has a form that is linked to a table that is imported from a SQL database. When the user uses the form to change infomation in the form it gives the message: "Recordset is not Updateable". I checked and the table has a primary key. I relinked the table to make sure that wasn't a problem. Any other ideas of what I can do to make this error go away. It had been working properly for a few months and started getting this message about 2 weeks ago.

Any help would be greatly appreciated.

 

[Sean]

Firstly, can you update the table directly?

if so, then its not a SQL connection problem.

else, can you update the the data if you run the recordsource SQL for the
form???

if so, start looking at the form properties a bit closer, especially the
Data properties.

I have inherited a database that has a form that is linked to a table that

is imported from a SQL database. When the user uses the form to change
infomation in the form it gives the message: "Recordset is not Updateable".
I checked and the table has a primary key. I relinked the table to make sure
that wasn't a problem. Any other ideas of what I can do to make this error
go away. It had been working properly for a few months and started getting
this message about 2 weeks ago.

 

[Guest]

Thanks for answering back

Yes, I can update the table directly.
I'm not really sure how I run the recordsource SQL for the form.
Thanks for the hint about looking at the data properties. Anything in particular I should be looking for

Thank you again for the help

----- Sean wrote: ----

Firstly, can you update the table directly

if so, then its not a SQL connection problem

else, can you update the the data if you run the recordsource SQL for th
form??

if so, start looking at the form properties a bit closer, especially th
Data properties

I have inherited a database that has a form that is linked to a table tha

is imported from a SQL database. When the user uses the form to chang
infomation in the form it gives the message: "Recordset is not Updateable"
I checked and the table has a primary key. I relinked the table to make sur
that wasn't a problem. Any other ideas of what I can do to make this erro
go away. It had been working properly for a few months and started gettin
this message about 2 weeks ago

 

[ScooterGuy]

I have had this problem in the past with my database to
resolve the problem I had to open the table in design
mode then change the primary key field Field Properties
under the General Tab Indexed to Yes (No Duplicates)

-----Original Message-----
Thanks for answering back.

Yes, I can update the table directly.
I'm not really sure how I run the recordsource SQL for the form.
Thanks for the hint about looking at the data

properties. Anything in particular I should be looking
for?

Thank you again for the help.

----- Sean wrote: -----

Firstly, can you update the table directly?

if so, then its not a SQL connection problem.

else, can you update the the data if you run the recordsource SQL for the
form???

if so, start looking at the form properties a bit closer, especially the
Data properties.


is linked to a table that
is imported from a SQL database. When the user uses the form to change
infomation in the form it gives the

message: "Recordset is not Updateable".

I checked and the table has a primary key. I

relinked the table to make sure