I want 2 convert a sql server database to ms access data base completely,
with all relations and foreign keys. Are there any tools for this conversion?

Perhaps this will help:
http://www.sqljunkies.com/Article/BD909D1E-3EA1-4323-889E-5E3A5415B977.scuk

Show quoteHide quote

Sorry, I read your original post before I was fully awake.

http://www.sqljunkies.com/Article/BD909D1E-3EA1-4323-889E-5E3A5415B977.scuk
Show quoteHide quote

Unfortunately, no. Most people go the other way, converting an
Access/Jet application to use a SQL Server back-end. One technique
that might speed things up is to create a new Access mdb and link to
the SQL Server tables you wish to import. You can then create a series
of MakeTable queries in Access to create the tables and load the data.
However, you will need to recreate all keys, indexes, validation
rules, etc., manually.

--Mary

On Wed, 16 Feb 2005 05:01:08 -0800, "shekarchian"
<shekarch***@discussions.microsoft.com> wrote:

Show quoteHide quote

How get column headers in QA CSV export
if elseif .. in Store procedure:
DTS Programming Question -- how to remove custom transformations
SQL Mail and Replication Alerts
Errors in the trace from Enterprise manager
windows 2003 and Sqlserver2000
Sp and Jobs
Backup job Fails every time:
Database Backup & Restore
Replication initializing