Creating a New Database using Old Data to start then add new data

Question

I'm trying to create a new database rather than try to fix all of the bugs in the old one (too many cooks in the kitchen makes for a messy database). I would prefer to use the old id numbers for individuals (so I don't have to do extra work and relabel all of the individual folders) and then have access create new numbers for any new people i enter.

is this possible? what steps should i take?

THANKS!!!

Answer 1

It sounds like you created the table before importing.  If you start from scratch with nothing in the new database, then import the tables you want into the new database, the Autonumber will come across too.

I thought your tables were already split from the database with the forms, reports, etc.  If I was wrong, then you should definitely do as ScottGem said.  If you have the tables and relationships in their own database file, it's likely that your original question becomes moot.  The huge point here is that you really can only survive with one set of tables.  It's conceivable that your data can stay on life support for some time with two sets of tables, but it will be difficult and way over your head until you learn how to deal with all the complexities implied by your original question.

If your messy kitchen database is not split, I think your best approach would be to split that database before even thinking about other changes.  Once it is split then the old front end can stay in use while you create a new cleaner front end

Answer 2

again, I need to be able to continue to add new people to the database and make sure the new people are not duplicated in the old data (the people forgot they already signed up)

I'm VERY new at Access. I took the level 1 class at the local skills & tech school and they don't even have levels 2 or 3 for Access 2010 available yet! I'm hoping someone here can help until I can get more educated in this software.

Answer 3

how do I get it to auto number the new people I enter after I import the old data?

Importing works great, but I cannot switch to autonumber after data has been entered. that means ANY data. I can switch from auto number to number or text, but not back again.

....I am regretfully looking at all of the folders and papers I will most likely have to renumber...it's not looking pretty :(

Answer 4

Or, split the tables into a back end, then build a new front end from scratch linking to the tables.

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 5

Create a new blank database and Import whatever you need from the old database.