access 97

  • Thread starter Thread starter doglover
  • Start date Start date
D

doglover

I have created a database using forms. The program
database is linked to the database that stores the data.
At what point does the database program become unstable.
The problem I am experiencing is that the database is
inserting data into a field that is a relationship with
another table (primary key) but the data is from the
primary key of the actual table my form is based on. IE,
the form is based on a work order table with a primary key
called wrkid. The wrkid number is generated from a
function when a new work order is created. The work order
table is related to a table called invoice. When an
invoice is created it places the invoice (primary key)
into the work order table (related key) but for some
reason it is placing the work order primary key into the
proper field but also into the invoice field (primary key
relationship from the invoice table). The placement is
not all the time and very irregular. It there a limit on
the number of records a table can safely hold? It
actually sounds like the program making this error but I
am concerned about the stability of the entire database?
Any help will be greatly appreciated. The program
database is 6.00 mb and the data is 10.8 mb. Thanks for
your help.
 
An Access 97 MDB can be as large as 1 GB, so you're nowhere near that. I've
had millions of rows in Access 97 databases without any real problems.
 
Any ideas why my database is inserting information into
the wrong field on it's own. Read message below. Thanks
 
Back
Top