want to import hole object of MsSqlserver 2000 with all relationship and Defaults

[khurram alam]

hi All

I want to Import my Mssqlserver 2000 in MsAccess 2000 database with all
relation ship and all
default value and all data save in sqlserver Database (I want to import hole
data base object ) in MS Access database is it possible
if it is possible from MsAccess please tell me if it is possible from any
other third party tool then please tell me

thanks in advanced

from
khurram

 

[Joe Fallon]

It is not built in to Access.
A 3rd party tool would be much faster (if it exists.)
So you need to figure out how much your time is worth and then buy the tool
if it makes sense.

You can write VBA code to do this.
When you are done maybe you can sell your own 3rd party tool!

You can run Make Table queries to get the tables, field names and data to
Access.
But then you have to figure out how to build the relationships, set PKs,
etc. in code