Importing from Paradox

  • Thread starter Thread starter Rosemary
  • Start date Start date
R

Rosemary

I'm helping a co-worker who got a new computer. She had
all her databases in Paradox. We have tried importing
from, and we have tried opening the databases in, Access.
We cannot add information to the table. Help. Thank you.
 
I ran into a similar problem after recreating the relationships. I'm rather new so this might not be your nor the easiest solution. When Access imports from Paradox, all of the Autonumber fields are imported as Number fields instead. If you copy the table's structure, you can then add an Autonumber field to the table. Run an append query from the old table to the new one and then recreate the relationships that the old table had to the new table. When the next table is created, be sure that you include the new primary key field in the next table's design so that you will have a "translation" from the old number system to the new Autonumber system.
 
Back
Top