query failure indexes

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

Guest

i have a query based on two tables that relate to each other through a field
(one-to-one relationship).

my aim is to create a form for both tables and i want to do that through a
query.

note: the first table already has the data (primary key field) and i want to
use the form to fill in the remaining missing fields.
the second table has no data yet.

problem: the query does not allow me to insert data and an error
message referring to indexes appears.

how could i solve this problem?
 
Either you are violating a primary key or unique query constraint or your
database is corrupt. I'm betting that you are violating a constraint but just
incase, here's some resourses on corruption. Again without seeing the actual
error message, I'm betting that it is NOT corruption.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 
Back
Top