Re: Allowing new records to be added into a query

If something went wrong with the data, Access may have deleted an index
during the compact/repair. If a relation depended on that index, the
relationship would also get deleted. This is not common, but if it does
happen, Access should have created a new table with details of the compact
error.

I mention this because the loss of a P.K. in a table could make a query
read-only, even if nothing else about the query changed.

For a list of other possibilities, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ary" <Ary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4914EA51-3BCC-411B-8F4B-9997381E5422@xxxxxxxxxxxxxxxx
I'm at an intermediate level with access.

I have a pretty large database, with queries containing two tables. But
when
I look at the query, the navigation bar does not allow me to create a new
record.

This had been working perfectly fine until earlier this week. A seperate
error caused me to compact and repair my database, and now the queries
will
not allow me to add any new records.

(I know that there is a problem adding records to queries that draw from
multiple tables, but why did it work previously and not now?)

Any suggestions would be extremely helpful, thanks.
--
-Ary


.

Relevant Pages

  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)
  • Re: Query In BE database
    ... that would give the users "live" access to the underlying queries. ... When selected from the drop-down list box, I what the the query that is ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
    (microsoft.public.access.queries)
  • Re: Access Crashes When Rt Click Build in Query Design View
    ... Since you disabled Name AutoCorrect and decompiled and compact/repaired and fixed references and now have fully compiled code and then recreated the query, I'm not sure what alternatives might help. ... And it will happen on more than one query in the database. ... Compact the database to get rid of this junk: ...
    (comp.databases.ms-access)
  • Re: merge multiple databases
    ... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
    (microsoft.public.vb.database.dao)