CODEWITHSUNDEEP
vb.netms-access
Sameer
Sameer

Reputation: 33

Speed up application performance with Access database

I have written a VB.Net application which uses MS Access 2010 as the database. The database is kept in network drive on a server which is in the US. The application is being used by users in Germany, China, Italy, and India apart from the US users.

For a US user performance of the application is excellent, but for all other users from other regions, the performance is really not great. Every database action takes at least a minute to complete. Please help me to improve the situation.

Upvotes: 0

Views: 498

Answers (1)

Krish
Krish

Reputation: 5917

Expand from Access back-end to MS SQL/MySQL back-end. To do that, you need to either host MS SQL or MySQL on a dedicated ip/intranet address. MS Access has an inbuilt function to upgrade back-end tables to MS SQL server use that or recreate the back-end in MySQL.

Other than that, multiple users from multiple remote locations + shared network drive will drive everyone crazy

Upvotes: 1

Related Questions