Open data base

[stephaj]

I am a novice with Access, and what I want to do find something simular to "Northwind Trading" that is unlocked, or has not data in it yet. Northwind has all the things I need, I just can not find a way to replace the existing data, and enter mind. Any help.

[bigroo]

Stephaj,

The Northwind database is a very good example database to learn from.
There is no reason why you cannot use this database.

All you need to do is delete all the data from each of the tables, but you will need to do this in a particular order since some of the tables are dependent on each for information.

Once all tables are cleaned out, compact the database, this will reset all the autonumbers to zero.

I would then make a copy of the blank database to use for future, incase something does not go to plan.

Let us know how you make out!

[stephaj]

Stephaj,

The Northwind database is a very good example database to learn from.
There is no reason why you cannot use this database.

All you need to do is delete all the data from each of the tables, but you will need to do this in a particular order since some of the tables are dependent on each for information.

Once all tables are cleaned out, compact the database, this will reset all the autonumbers to zero.

I would then make a copy of the blank database to use for future, incase something does not go to plan.

Let us know how you make out!

That is the problem I am having Northwind will not let me delete the data. It says that "The field can be blank." and then something about being "Null".

[bigroo]

Hi Stephaj,

Which tables are you referreing too and I will take a look?

[bigroo]

Hi Stephaj,

Here is the cleaned out Northwind database, I had no problems flushing this out.

[stephaj]

Thank you Bigroo.

The problem was I could not clear the "ID" from the data because I was trying to use the wrong methiod to delete. Lost a lot of hair. LOL

Andy