Sql - mdb

[12345678]

Hi,

Just want to know how I can get my ItemDB from sql into ItemMDB.

Using MDB Viewer Plus that comes with the 2.6 files.

Any help apreciated, thanks.

 

[ρяєα¢нєя]

Quick step by step guide i knocked up:

1. Make a backup copy of your Access database (Copy and Paste it somwhere)
2. Open 2.6 Access database and delete TBL_STDITEMS
3. Open up SQL Server Enterprise.
4. Find TBL_STDITEMS.
5. RightClick->All Tasks->Export Data...
6. Select the corect database to export from (Should already be selected) and press "Next"
7. Select "Microsoft Access" from the Destination drop menu.
8. In "File Name" locate your 2.6 Access database and press "Next"
9. "Copy tables and views from source data" and press "Next"
10. Select the tables you want to copy over and press "Next" twice and then "Finish"

Hope that helps.

p

 

[12345678]

Thanks worked, but It didnt go In order Is there any way to make It go In order ?

 

[ρяєα¢нєя]

Not sure how to re-order it permanently but if you want to order so you can see what index number you're on, you can use:

SELECT * FROM TBL_STDITEMS ORDER BY FLD_ID

p

 

[12345678]

Ok thanks alot m8, will try this now.