Moving data from the Standard to the Enterprise Version

[admin]

To move the data in the Standard version ACCESS data file to the Enterprise.

1/ Edit the ASSETS.MDB file in your Standard version using Microsoft Access.

To open the location of the data file, run the Standard version select FILE > GOTO DATA FOLDER.. from the main menu. Then exit the program.

make the following changes in the following tables:

[Assets]

ID >> AssetId

Size >> ItemSize

[DepreciationInfo]

ID >> DepID

[DepreciationMethods]

ID >> MethodID

[FieldNames]

ID >> FieldID

2/ Use the SQL SERVER import feature to import the ASSETS.MDB file.

The Enterprise version honors any security settings set by the database admin. So if a user is set to be read only that user will only be able to view data within our program.

The program expects each record to have a unique asset number, it will not currently allow you to specify quantity 3 of an item and set a different asset number to each of the 3 items.