Tips or Hints??

[bradwould]

I was just wondering if any one had any tips or insider secrets on how to lower the size of a database and/or get it to run faster and more smoothly. I know you can split it but is there any other way? I'm using alot of macros and going from screen to screen there is sometimes a lag. I dont know much in the way of code but im willing to learn. Any links or advice on code how too's would be appreciated aswell...thanks alot I'd also like to say these posts have helped me a great deal and i cant wait until I am confident enough with Access to help out some other people.

Thanks again

Brad

 

[MStef]

Try to COMPACT DATABASE.
Tools, Database Utilities, Compact Database.

 

[bradwould]

Is it best to wait until the database is completly finished before compacting? I guess it probably is. A better question is would it hurt if I didnt wait?

 

[macca the hacke]

You can compact as many times as you like. try to Repair at same time too. You cannot compact or repair when other users have the database open.

 

[bradwould]

Great! That sounds good Thanks

 

[bradwould]

Another thing I havent been able to find anything about is :
Can you make a database entirely fullscreen so no options are available to the user except what is on the forms that I have created? to get rid of the menu at the top (file,edit,etc.)?

 

[BadKitty]

on the tools menu, go to startup...there are alot of options to work with there.

 

[Len Boorman]

I would look carefully at index's. You no doubt have primary keys defined. However when extracting data based upon Primary, foreign and maybe other criteria an index can often speed up retrieval if you have lots of records.

You need to examine your data and think about the queries to identi=fy where the index/s would possible prove beneficial

L