Need advice

[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!

 

[NoCoolHandle]

I tend to be a real pain on this subject.. but.

1. Get rid of linked tables.. They will cause all sorts of dataaccess issues as well as terrible use of SQL server resources. (1 connection per linked table per access front end - just as an example)

2. re Write your app to use ADO(taking advantage of stored procs and insert/update/delete statements) - Maybe conside using a pure VB app, or upgrade to .NEt (you will want to at some point)

3. If you are not prepared to do 1 and 2, expect to see a slower response time in many of your apps.