SQL Server to Access 2002

[Paul]

Hi,

I am wondering if there is a way to convert an SQL Server database to an
Access 2002 database? I have inherited a web site that connects to an SQL
database. I only have experience with Access. Any suggestions? Thanks - Paul

 

[Kevin3NF]

If the web site gets any sort of real traffic, you will be doing yourself a
disservice by going backwards like that.

That said...you will have to export the tables to Access, and pretty much
re-write all of the stored procedures, triggers, etc. into action queries
and VBA code. I would spend the time to upgrade your skills to SQL
Server....

Hope that helps....

 

[Sirocco]

I wouldn't unhook the website from the SQL Server.

But you can link other things to it, like a regular mdb file, in which case
you can continue to use regular queries, forms, and reports with the SQL
tables. You can't edit the tables with this mdb file, but you can do that
either by creating an adp file "linked" to the SQL tables, through which you
can edit the SQL table structures, or edit the tables through a copy of
Enterprise Manager.