Ways to access SQL Server data

[debbieaaa]

I currently have an Access database front-end that is used to view/modify data stored on SQL Server. There are currently 85 users. The front-end has to be deployed to the users desktop so that the Access front-end won't corrupt. In testing the encrypted front-end with Windows XP, we have found that it will no longer work.

I am looking for suggestions on how to utilize the data without using Access not only because of the XP issue, but we have also had issues sharing between Windows 2000 and NT.

Any suggestions...

 

[harebrain]

Could be a good candidate for a Web app.

 

[Databaseguy]

Is the Acess front end using linked tables, or is it an ADP ?

If the tabels are linked, make sure all the machine you put in on have a System or User DSN for ODBC.

Tyrone Lumley
augerinn@gte.net