Refeshing Nightmare

[mixodorian]

Hi everyone. I was wondering if anyone could help me. I am in the process of designing a database (Access 2002, office xp), but the problem I am having is that when I am pulling in an ID number, from one form into another form, the form I want this number to land in crashes, with the warning that more than one user is trying to access the form at the same time (they are not, just me).

After having to clear this error box (a few times, it keeps reapearing) errors then appear in each of the destination forms fields.

I think it is something to do with the way the database is setup in multiuser envirionments and retry intervals etc - and I have been playing about with the values, which seems to work once, but then it goes straight back to crashing.

If anybody give me some default values that might work or any other remedies for this problem, this help would be very much appreciated

Many Many thanks.

 

[viperstingray]

i get the same message sometimes too. the best way to get rid of it is to close down access and re-open the application. your changes will be saved (if you choose to do so).

 

[mixodorian]

Thanks for your reply.

I'm sorry, I should of mentioned that the problem occurs everytime I do a particular action within the in the system, and is not intermitant.

 

[mixodorian]

Thanks for that reply, I will recode as per your suggestions asap. I was convinced it was a refresh interval problem and got stuck there for weeks.

God this teaching yourself lark is infuriating.

Many thanks again.