We develop an asset tracking software program called AssetManage.? We have a version that uses a Microsoft Access 2000 data file and another version that uses ODBC to connect to the back-end database.? The database table formats for both products are very similar but not identical.
A customer needs to have an MDB file with their data converted to SQL Server 2000 MDF format, this requires converting the MDB to an MDF and making a few fieldname changes so that it works with our ODBC version.
You will need SQL Server 2000 running to be able to setup the database using the MDF file you converted, then setup an ODBC connection to it using the Windows ODBC Administrator.
To test, simply download the AssetManage Enterprise program from:
[login to view URL]
Then attach your converted MDF file to an SQL Server 2000 database, run the program and select an ODBC data source.? If the program runs, you can add, edit records, then the file has been converted properly.?
The Schema for the Enterprise version can be found at:
<[login to view URL]>
We will have similar projects like this come up every few weeks and if this works out, will be glad to post them again on RentACoder with you as the preferred coder.
## Deliverables
The MDB file to be converted is in the Attached Zip file.
To see all the changes that need to be made you must compare the MDB file with the schema for the MDF file.? Please note that when you install the AssetManage Enterprise demo, you will find an empty MDF file with the proper database strucutre that may be useful, it is in the [\\Program][1] Files\AssetManage Enterprise\UPSIZE folder.
Here are some of the changes that will need to be made:
1/ Convert the 'LSS~OurHouse' tablename to 'Assets'
2/ In the Assets folder, change the following fieldnames:
ID >> AssetId
Size >> ItemSize
?
[DepreciationInfo]
?
ID >> DepID
?
[DepreciationMethods]
?
ID >> MethodID
?
[FieldNames]
?
ID >> FieldID