Allowing new records to be added into a query

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

Guest

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.
 
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
 
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.
Click to expand...

You may have some corruption not cured - or, just possibly *caused* -
by the compaction.

Try deleting the query; removing any relationship between the tables
in the query; compacting; recreating the relationships (to recreate
the indexes which control the join); and rebuilding the query.

John W. Vinson[MVP]
 
Thank you, yes, it did somehow delete the primary key of my main table, which
was causing the problem. Way easier to fix than rebuilding it!
 
Back
Top