[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

vb6 accessing data from MS Access over the network becomes prohibitively slow

I have a VB-MS Access application. If I split the Access DB and run VB application from a remote machine to access data from master access db over wireless network it becomes damn slow. I am using jet connection and running queries from inside vb. recordsets are ADO. any suggestion to improve performance ??
0
Piyu75
Asked:
Piyu75
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
how big is your database?
0
 
Bob LambersonSoftware EngineerCommented:
I understand that wireless is very slow because of design, if you have much traffic. Have you tried the same setup wired for a compairison?

Bob
0
 
mmusanteCommented:
Have you tried Compacting and Repairing your database?
I worked woth access on an old 10Mb/s network (BNC) and I had to do this operation periodically to mantain a minimum of performance
0
 
Piyu75Author Commented:
DB is 97MB. I did not try the same with wired set up. Wireless network has almost null traffic. Compacting the database periodically wont work out for my customer. I read on microsoft website that there is'nt a way to have good performance with access DB if you wanna run it in multi user environment. Thanks for you comment guys.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now