hello

[nwj]

hello
I am using access database as a db server over LAN in my program. I
tested
it on my lan(xp, 2000 with 'FAT32' file system), it is running ok and the
speed is fast. but I don't know why it becomes so slow while running it on
another two pcs, both with xp system and 'NTFS' file system.

The program accesss database frequently, and database connection is always
opened before accessing db and then closed after finished it. Whether is it
the main reason that slow down the program on NTFS system? and why?

Thanks in advance.

 

[Arvin Meyer [MVP]]

You may want to read some of the performance articles at:

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

Tony Toews has some excellent suggestions. Also, make sure that your
database is split into a front-end running on each workstation and a
back-end running on the server. Any attempt to share the front-end will slow
down the database as well as create an opportunity for corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access