hi,every one
im facing a problem in running access it's about
25 tables
80 forms
46 query (5 append query ,1 update query ,2 delete query )
60 reports
4 modules
after 7 months of perfect working in access 2003 around 8users working
in it .i was working with these users in my sharing folder which i know
that may corrupt the whole application but from one week i transfer it
to our company server i notify that it become much slower specially
when more than one user access it,according to that i return it back
but i also face the same problem i m waiting for 2 min to open the form
not all of them number of them they work but delay during running query
..according to my knowledge it must become faster .it become faster for
the search option but when running queries no. i tried to split the
database to BE\FE and also the same problem is accure. i dont face it
if one user is working . almost it stuck but still work as before
except the delay in time.i always compact the application and the
capacity change from 511 MB or more to 159MB or little bit more.
im going to check some issues i have found in the net which it was
arround the extension of FE should be mde that may help also the
setdatasheet for the tables from auto to none and in the general in
options in tools make the tracknameautocorrect off.
but im failing that im going to face the same problem and the delay
please help me since when im working in my own pc with a copy of the
application without any sharing it work perfect.
so please could you just help me and suggest things that may help ????
my supervisor suggest to take a look and make some changes he thinks
that the problem may occur from the relation but i dont think so since
it work perfect for a long period.