Slow Database

[IkyL234]

I'm using Access2000.
I have just designed a database which seems to be operating very slow on a
network. There are currently only a few records in it.
Should I be compacting it now before it gets busy with usage ?
The database has OLE bounded fields where pictures are linked to a network
folder where the pictures are kept. Will this linking of pictures to
respective records over time hinder the speed of the database ?

 

[Kevin3NF]

Have you split the database into front-end/back-end? Does each user have a
copy of the FE on their PC?

What does slow mean?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Wayne Morgan]

I would recommend the following links for information on maximizing
performance of the database across the network and image handling in the
database.

http://www.granite.ab.ca/access/splitapp/index.htm
http://www.granite.ab.ca/access/performancefaq.htm
http://www.granite.ab.ca/access/imagehandling.htm