increasing of performance in split access database

0
votes

I have a split database in access 2003 with back-end and front-end. BE contains my tables and FE contains forms ,macros and etc.My database is very slow.Have you any idea to make my DB performance better ?

1
ms-access
Is the BE stored on a network or on the local machine? Also ensure that you have your table indexes set correctly, especially on Primary and Foreign keys. - Matt Donnan
BE stored on network and tables are indexed. - Baper
Have you see these? granite.ab.ca/access/performancefaq.htm AND office.microsoft.com/en-us/access-help/… - Fionnuala

1 Answers

0
votes

about the above issues I don't have any idea but the second one you can put the back-end on network and the front-end on your machine, then if you any user enter a record it automatically add in to the back-end.

yeah, it is ok to put it indexed.

By network, it means local one not internet.