convert SQL Server DB to Access DB

Hi,
IS it possible to take a SQLServer DB and convert it into an access
version? If so, can you easily convert stored procedures in access
queries? Or is all this not possible?Using SSIS in SQL Server 2005 and using DTS in SQL Server 2000, you can
easily export your SQL Server tables and views into a Microsoft Access
database.
To do this, go to your database in SQL Server and right click on it.
Tasks\Export Data. Choose your source from SQL Server and choose your target
as Microsoft Access from the list and go on...
--
Ekrem Önsoy
"bcap" <rayh@.patriots.com> wrote in message
news:1190648932.092871.210280@.19g2000hsx.googlegroups.com...
> Hi,
> IS it possible to take a SQLServer DB and convert it into an access
> version? If so, can you easily convert stored procedures in access
> queries? Or is all this not possible?
>|||Hi
This is not the way most people go! Is SQL Express not an option? AFAIK
there is not a way to convert a stored procedure to an Access query. Your
stored procedure may contain code and logic that is not possible to do in an
Access query, so unless they are very simple single statements being run in
the query you will need to write the logic into the client application. You
can import/export the tables and data into Access quite easily.
John
"bcap" wrote:
> Hi,
> IS it possible to take a SQLServer DB and convert it into an access
> version? If so, can you easily convert stored procedures in access
> queries? Or is all this not possible?
>