High Volume Data ! Access 2000

[Nasir Mahmood]

Hi, All,

Recent Now, I am facing problem, I have ACCESS 2000 & VB6
Program.

If one user run program & take reports, normal 20-100 data
(packets) on network but if any other user try to use that
program simultaneously, first user gets 10,000 Data
packets network traffic & whole network goes slow.

I didnt found any Macro on Access, no virus.

Kindly Help.

(NASIR)

 

[Dirk Goldgar]

Hi, All,

Recent Now, I am facing problem, I have ACCESS 2000 & VB6
Program.

If one user run program & take reports, normal 20-100 data
(packets) on network but if any other user try to use that
program simultaneously, first user gets 10,000 Data
packets network traffic & whole network goes slow.

I didnt found any Macro on Access, no virus.

Kindly Help.

(NASIR)

I'm not sure if this is relevant or not, but look at Tony Toews' Access
Performance FAQ and see if this look like one of the issues mentioned
there:

http://www.granite.ab.ca/access/performancefaq.htm

I'm especially thinking of the "LDB Locking" topic, but you may find
something else there to help.