Access 2003 for multiple users on a network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built several databases for staff and every once in a while all the
code is wiped out from every form. The data, queries , macros and tables
remain intact. It is just the code that is gone! Does anyone have any
suggestions?
 
Hum, this is certainly not normal. I can't imagine why code would go
missing. Perhaps users are messing around?

I would consider building mde, and distribute that to each machine. Then
see if users or anyone can mess it up!
(they will not be able to!!).

So, for a reliable multi-user setup, and one where the code can't go
missing....try splitting your database, and distribute a mde to each
machine...

I explain how to setup this here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

pay close attention to the mde part in the above.....
 
Thanks for your response.
It is highly unlikely that someone is playing with the code. We do have a
tape back up of our shared drived performed daily. I was wondering if somehow
the proble was linked to that??
 
Phil B. said:
Thanks for your response.
It is highly unlikely that someone is playing with the code. We do have a
tape back up of our shared drived performed daily. I was wondering if
somehow
the proble was linked to that??
Click to expand...

Highly unlikely, we operate a similar system and I have not, in 15 years,
had and code loss. It only takes one person with malicious intent to cause
this problem. Have you considered applying user-level security?

Regards,
Keith.
www.keithwilby.com
 
hi Phil,
I have built several databases for staff and every once in a while all the
code is wiped out from every form. The data, queries , macros and tables
remain intact. It is just the code that is gone! Does anyone have any
suggestions?
Click to expand...
Do all users have Access 2003? Imho it is possible to lose code, if they
are using differnt Access versions at a time.

btw, have they installed the latest servie packs?


mfG
--> stefan <--
 
Back
Top