Hey,

I have a client who is running an access application on about 50 computers. The backend file is located on a workstation and all the other computers have an .mde file with table links. Recently, they have been complaining about the performance of teh application, mainly that it is slow, go figure he he.
I want to upsize the datafile to a SQL Server. This is what I want to do:

Convert the data file to SQL Server.
Have a MDB file with links to teh SQL SErver tables.
Each workstation will still have the .mde files linking to teh mdb file which in turn links to SQL Server.

The reason that I want to do this is that there is a lot of SQL code in the application file and I don't want to redo all of that to directly link to SQL Server.
Would they see a performance boost with that setup?

Also, would the data corruptions be eliminated? I mean, the data is handled by SQL Server, right?

Thanks,