Can't enter data?

[Guest]

I'm having a bad day as you can see from the number of posts!!!!
I have a form that is based on a query. However I can't enter any data into
it in any of the controls. I ahve set the Dynaset to Inconsistent Updates and
the Data Entry to Yes but still can't enter any values in any of the
controls. I have built other forms based on queries and had no problems. What
could it be?
Thanks
Tony

 

[SusanV]

Can you edit the query when you open it standalone? Some queries are not
updateable.

 

[Guest]

Hi Susan No I can't there's no automatic new line to enter data. Why is this?
Tony

 

[SusanV]

As I said, some queries are not updatable. What the SQL behind the query?

 

[Douglas J. Steele]

Take a look at
http://msdn2.microsoft.com/en-us/library/aa198446(office.10).aspx. (Don't
worry if you're not using Access 2002: the article applies to all versions)

 

[SusanV]

THANK you Doug - I couldn't find this and thought I had it bookmarked!
;-D

 

[Tony Williams]

Thanks Doug and Susan for that info.
Tony

 

[Ken Snell \(MVP\)]

And some more articles that may be helpful:

See these articles for information about what can make a query nonupdatable
(watch for line-wrapping):

When can I update data from a query?
http://msdn.microsoft.com/library/d...l/acconDeterminingWhenCanUpdateDataQueryS.asp

Harnessing the Power of Updatable Queries
http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_harness.asp

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc

 

[Guest]

more technically; Access MDB queries randomly crap out.. because MDB is too
flakey for real world usage

 

[Guest]

if you want a reliable database that doesn't randomly crap out-- then you
should move to SQL Server and Access Data Projects

 

[Guest]

more importantly

DO NOT USE A DATABASE THAT RANDOMLY CRAPS OUT

move to SQL Server