MDB's and SQL

[Bill T]

To all,
I am relatively new to SQL Server (2k). I have an MDB
that I am adapting to a SQL backend. Creating as ADP is
not an option.

Question - What is the best way to connect an MDB to a
SQL backend for data-entry/ data-maintenance screens?

Thanks,

Bill T

 

[Lyle Fairfield]

To all,
I am relatively new to SQL Server (2k). I have an MDB
that I am adapting to a SQL backend. Creating as ADP is
not an option.

Question - What is the best way to connect an MDB to a
SQL backend for data-entry/ data-maintenance screens?

8 light bulbs with an off-on switch for each.

 

[BJ Freeman]

The key phrase is "Best way"
if you access the tables, thru linked tables,to created your SQL, you have
the problem of possible corrupting the SQL server.
If you use stored procedures already on the SQL server, then you have a lot
of recoding to do on the forms.