# signs

[nashat21]

hello..

of late, my db's back end has been "blowing up" - i.e. "Unrecognized db format". although the back end repairs fine, i have noticed that several relationships are being deleted and the primary key in one or more tables is also being deleted. for example, last night, following the repair, my main client table which usually has clientno as the primary key, didnt have it and when i tried to reestablish the pk, it said pk cannot contain a null value. on sorting i saw that one record was full of #signs (which was a legit record that got corrupted). i deleted it and had to reestablish the pk, import that corrupted record and reestablish relationships with the other tables.

it has been happening at least once every day. any ideas on what is causing this? (my supervisor believes it may be a network error thats causing this.

thanks,

nashat

 

[79ssecca]

? How often are you running the repair routine?

ssecca

 

[nashat21]

at least once a day when the db goes into an unrecognized state.. sometimes more than once a day.. i do backup every half hour and plenty of times, we've had to bring in individual records from the backups when the #signs overwrote the record.

nashat

 

[79ssecca]

As you probablly know running repair on a database is a once to never choice. The "repair" process itself can cause major problems. I would take a serious look at the code. Make sure you have no what I call "memory leaks". Things like recrodset that are not closed properly by code an such.

Taking a break I'll be back with more.
Sometimes they make me work for my money, can you beleive.

ssecca

 

[79ssecca]

Also could you tell me if your forms are bound or unbound. How many users are hitting against the application at any one time. Is the back end seperated from the front end GUI and if so is it an Access back end or something else.

79ssecca

 

[nashat21]

umm, i believe all the forms are unbound, and there are on average about 10 ppl hitting the db at any given time. the db is separated into a front- and back-end and these are both access dbs..

to the first of your two posts, i never wrote anything in code for this access db - i created it all using access commands and menus (i can barely debug in vb) so i have no idea if there are any memory leaks in the code.

thanks,

nashat

 

[79ssecca]

From what you have told me I actually suspect you are using bound forms. An unbound form requires a lot of programming. An easy way to tell is normally an unbound form has no recordsource and or its controls have no control source in their respective properties. But I digress, As to your issue, make sure everone is trained as to how to exit out of the program. Make sure everyone everytime exits properly. If you know how add a timestamp and capture the user name on each entry it will help you trouble shoot the issue. If you suspect coruption copt all the objects one at a time to a new database and recompile that database rename it back to the original name.

Also, their are plenty of great books out there, spend some time learning VBA you will be extremly happy the power to do almost anything quickly and efficently lies in Access's VBA modules.

Good Luck
79ssecca