Jump to content

Moving data from the Standard to the Enterprise Version


Recommended Posts

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:


ID >> AssetId

Size >> ItemSize


ID >> DepID


ID >> MethodID


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.

Link to comment
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...