Front End Advice linking to Sql

[Utracman]

Ok... we build a sql2000 db to replace the many Access 97 dbs. In the past I used a frontend/backend set up simply linking the client to the master db. I rewote the client (Access97) to work with the new Sql db and linked the tables using an ODBC with a File data source of a dsn in a shared folder. Well it works for me but not any other users. Just in the testing phase so I wish to explore the options.

What is the best way to connect to sql from Access 97 in a shared enviroment?

Are there any benifits to switch to another version of Access for the client?

Any other "watch outs"?

Thanks

Dave

To learn fron those who have mastered the art..... Saves many headaches!

 

[Norris68]

I personally would prefer to switch to Access 2000 (or above) and create an Access Data Project (adp). This links to the SQL database using ADO (DBlib). If you use Access 97 or a mdb with linked tables you will have to go via ODBC. The ADO route is quicker and avoids some of the limitations of ODBC. It has the added benefit that the connection information is stored within the project meaning you don't have to distribute dsn files to your users. It will also allow you to use SQL integrated NT security for all your users if you wish.