Best way to Deploy DB

[mdg]

Any ideas? I created a fairly large DB and now want to deploy it to 20 other locations around the US. Is the best way to use SharePoint 2007 or is there a better way. I was going to install the DB at all the locations as a standalone but then thought there must be a better way such as SharePoint.
Thanks for any suggestions

 

[GinaWhipp]

I think you should start here...

http://databases.about.com/b/2007/11/06/using-sharepoint-with-microsoft-access.htm

...if you want to use Sharepoint as you may have to make some adjustments to your design AND find someone to host it.

However, if you want to just deploy it as a stand alone have a look at...

Access 2007 Runtime...
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
How to Deploy…
http://msdn.microsoft.com/office/bb229700.aspx

 

[mdg]

Thank you for your kind response. Would setting up linked tables from all the users I described to one main db work as well. In my scenerio, I wil have 18-19 users that will be using the same data base but with their own data - they will not need to see anyone elses data either. However, the main office needs to compile all the data on a regular basis and be able to print out reports reflecting this data. Would linked tables work? We are on a large intranet and each location will have a file server to host their database.
Thank you again

 

[GinaWhipp]

I see no reason why it wouldn't work and give the powers that be access to all the data the need. Maybe these links will help explain it clearer...

http://www.kallal.ca/Articles/split/index.htm
http://allenbrowne.com/ser-01.html

You may also want to take a look at MVP Tom Wickerath's article…
http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm

To handle the update of multiple front ends see…
http://www.autofeupdater.com/

If each user needs Access you can install the Runtime…
Access 2007
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
Access 2010
http://www.microsoft.com/downloads/...cd-5250-4df6-bfd1-6ced700a6715&displaylang=en