EMS SQL Products

Jan 24, 2006 1 Replies

I purchase both Data Import and Export and have been able to retrieve my data files. I want to Import a blank Item Database so that I can start over. What happened is that my database double with blank entries.



Have can I import a blank item database?


Bill,

Backup first. SO Admin | File | Connect | Database | Backup.

One of 2 ways. Either SO Admin | File | Connect | Query | New | type "Delete Item" and press F5 | this will delete all of the items in the items file. If you have setup and alias or supplier part numbers, this is probably _not_ the way to go. Otherwise you will have to delete the alias and supplier's re-order numbers too.

Otherwise create a new blank database for _everything_, as above except instead of Query, do a Database | Create | Next | give it a name | Next | Next | click on the magnifying glass | double click on DBFiles folder | Double on rmsdb.bck | Next | Finish. The File | Connect | type in the new database name | OK |File | Configuration | type the new database name again and test it. This will delete _everything_.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required