Migrating an Access Database to MOSS / Sharepoint

By peter.stilgoe

You have an Access database which is currently being used within your company ie. Contacts, Sales Order Processing, Asset Logging etc etc…..And you now want to migrate it to Sharepoint/MOSS

You open your Access Database in Office 2007

You click the ‘External Data’ ribbon then select ‘Move to Sharepoint’

Now choose the Sharepoint site you wish to migrate the DB to & select the Document Library where you want to hold the access DB for linking back to Access forms & reports.

Click ‘Next’ then after a few minutes the migration completes with no errors…..good job!

That is until you goto access your views in Sharepoint & there is none there, then you realise your Access DB file hasnt actually uploaded.

Two reasons for this:

1) mdb files are restricted in Sharepoint by default so you need to remove mdb from the block list.

2) If your document library template has required columns set on it you will need to go into your document library settings & manage checked out files.

Note: If the ‘move to sharepoint’ feature is greyed out you need to convert your Access database to an Access 2007 database.