Access2 Forms and SQL7 Tables

[smithph]

Hi, All,
This is a very basic question but I would welcome some definitive information, please.

If I move the tables of an application written in Access2 over to SQL7 or SQL2000, can the original Access2 forms be used to add data, read data, alter/delete data?

Thanks in advance,
Phil Smith

 

[Cagliostro]

No. John Fill
ivfmd@mail.md

 

[ScottAW]

If by Access2 you are referring to any edition of Microsoft Access, then for the most part, the answer is yes. Once you create/move the tables in SQL7/2000 you will need to go into your Access app, delete the tables, and then link to the SQL tables using ODBC. When you link the tables, they will have a slightly different name. For example, if the Access table name was "Address", the link from SQL will be called "dbo_Address". Simply rename the table/link name to "Address" and your forms/queries/reports should all function the same.