I have a SQL Server database that is connected to a client server
program via ADO. I want this same program to be able to use JET as
the database back end (to provide a light alternative that doesn't
require a full install of MSDE or SQL Server.) I know that I can't
necessarily get a fully automated conversion, but I was wondering what
advice group members would have to make this conversion as painless as
possible (not to mention keeping the two in sync.) Perhaps there are
some tools out there that will break the back of the work? I haven't
used JET since 3.5, but I understand that 4.0 has support for stored
procedures. It is possible to convert SQL Server stored procedures to
JET stored procedures?
Thanks for your help.