MS access 2007 -" this record is not updateable" in form view?

P

Paula

I am using MS-Access 2007 and I am unable to enter a new record in the form
view I get the message: "this record is not updateable"
Please Help!
 
P

PieterLinden via AccessMonster.com

Paula said:
I am using MS-Access 2007 and I am unable to enter a new record in the form
view I get the message: "this record is not updateable"
Please Help!
Click to expand...

Lemme guess... you based the form on a query, and the query is not updateable.
.. so open the form in design view, click on the Data tab, and copy and
paste the data source for the form. If it's a query name, post the SQL for
the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Split form 0
MS Exchange PTR 0
Copy previous record into form field 0
Viewing files content inside MS-Access form 1
Problem activating pre-installed MS Office home and Student 0
Word 2007: Was up-to-date, then a crash: I reinstalled from 2007 CD, but updates? 2

Top