Is it possible to upsize access data to msde?

[Paul Mak]

I have several access databases for different applications used in my office
here. The performance on all Access applications are slow. Some applications
are linked to more than one data sources. The Access data (data bases) is
installed on a computer which can be accessed by the LAN. I wonder if it
will boost up the performance by putting the databases into a single
database and upsize it to msde. Then on each of the workstation create an
odbe for each of the application. Thanks

 

[Paul Mak]

Will the front end Access application using DAO work with msde??

Thanks

 

[Bill Edwards]

Yes, you can use DAO in an Access app that links to msde/sql server data.

Without knowing the details of your Access application it is impossible to
say why they are performing poorly. However, simply moving your data to
msde/sql server will probably not do anything to improve performance.
Chances are in fact excellent that performance will decrease. Poorly
performing Jet databases tend to perform badly because they are poorly
designed.