Splitting a table

  • Thread starter Thread starter Anne D.
  • Start date Start date
A

Anne D.

My main table was getting too large so I split it in 2 and linked them. Now I
am getting a ton of error messages, saying the records can't be found. The DB
is looking for all the fields. how do I fix this?
 
I would have the same primary key on both then use a form/subform to display
them. Link them in relationships as a one-to-one.
 
My main table was getting too large so I split it in 2 and linked them. Now I
am getting a ton of error messages, saying the records can't be found. The DB
is looking for all the fields. how do I fix this?
Click to expand...

How big is "too large"? Too many records? Access can handle 10,000,000 records
reasonably well, given proper design and proper indexing. Too many fields? If
so you're "committing spreadsheet", and need to normalize your tables.

How did you "split"? How did you link? What are some representative fieldnames
in each table? What (if anything) is the Primary Key of each table? What error
messages are you getting?

Be aware that nobody here can see your screen, and the ONLY thing we have to
go on is what you post. Reread the message above with your mind cleared of
knowledge of your database structure, and you'll see that it's not very
informative. Give us a hand here, and we'll try to give you a hand in return!
 
Back
Top