Posted by Anns via SQLMonster.com on 06/20/06 21:13

I have about 20 Ms Access Databases to need to be upload onto a SQL Server
2005.

Currently the are on a network/server residing on a specific drive. The goal
is to keep the user face the same (ms access) and put all of the tables onto
a SQL Server 2005 BE, and yet make those databases accessible to open/view
through Ms Sharepoint.

What is the simple (properties) way to grab all of those db's = 20 and upload
to server?
With out having to write code.
Pull all db's over to SQL then store the Ms Access databases on Sharepoint
where the user face remains the same and the tables are on the server and the
db's are accessible now through the company Intranet.

--
Message posted via http://www.sqlmonster.com

• Next in forum: Re: One Database vs. Multiple Databases
• Prev in forum: Re: One Database vs. Multiple Databases
• Thread view: Ms Access upload to SQL Server 2005 BE & Sharepoint FE

[Reply to this message]