Access 2.0

[PC3]

My database corrupts at least twice a week. Is the file size too large (23,072 bytes). Or could it be something else. Is this even possible? I have about 5 or more users sharing at one time.

 

[boblarson]

A couple potential causes:

1. If the users don't close the program properly
2. If the network connection is lost between one or more users while they are connected, even if only briefly.
3. Orphan code that exists but doesn't have objects that they existed in (for example: a form that you deleted and the form's form module is still there - it should have automatically been deleted but didn't)

 

[PC3]

Thanks Pat.
Thanks BL, but how can I identify this orphan code if in fact it does exist?

 

[boblarson]

1. go down your list of forms and look at the form modules to see if there are any named something that you don't have a form name for.

2. the controls are a bit harder. I manually scan through my code, because I usually know what controls are on a form and what their name is and if I recognize something that goes with a control I know I had deleted, then I can axe that code.

 

[rpadams]

Re-compile

Try hitting Alt-F11 to open Debug and under Tools recompile the database. If it stops, you can sometimes get an idea what's wrong. I use this to find objects (eg command buttons etc.) on a form, but have forgotten to delete the On-Click code behind them.

 

[PC3]

Thanks!

Thanks guys. I've tried every one of your suggestions and I found some flaws in the DB. I will try to make sure that everyone closes down properly which is probably also the reason. An end-user will usually treat a computer however they want and then blame the computer for malfunctioning. I just started here and there will be alot of changes taking place. Mainly I will be converting from Access 2.0 to XP. Let's see how that goes. At least this way I can start out fresh. Thanks again.