Performance Issue?

[eileen1309]

I have a secured databased and an unsecured database, if the user opens the secured database I see an drastic lag in opening existing records. If I use the unsecured version there is no lag.

Could there be a reference that should be loaded that isnt'? of is this a by-product of security.

Thanks
Eileen

 

[MajP]

Take a look at thread705-1127475, especially if you are running a split database.

 

[eileen1309]

Thanks for the pointer I did not realize the auto feature on tables was available in 2000 as I developed in 2003 and then downgraded.

The three suggestions seemed make a drastic improvement in the performance of the system.

Eileen

 

[MajP]

Eileen,
Take a look at the link that Roy had in that thread about the "168 tips to Speed up Your Applications". There is some good information in there as well. Those top three issues are serious bugs, and the MS site seems to brush them off as minor annoyances.