Access Front End broke. Due to concurrent users?

  • Thread starter Thread starter Mikal via AccessMonster.com
  • Start date Start date
M

Mikal via AccessMonster.com

I searched this forum but didn't find anything like this that looked like it
was particular to .ADP files. Maybe that's because it doesn't matter what
kind of file you're using. If so, I apologize for being bone-headed.

We (not me, I didn't do it) have a .ADP front end housed on a network drive.
It is the only copy of the front end in use for several concurrent users and
it broke--fortunately, there was a back-up copy available. The data on the
SQL Server seems fine. What appears to have happened is some of the controls
on the main form lost their connection to the fields in the underlying tables
and maybe some other stuff too. We just replaced the bad file with the good
copy when we realized we had one.

Questions:
1. Can having multiple users in a .ADP file do this?
2. Are we likely to corrupt the data this way? I'd bet on it in a .MDB file,
but I never used .ADP.
3. Would compiling to .ADE files be any stronger
4. Should we give each user his own copy of the front end and maybe password
protect the various front ends to enforce having the users open only their
own individual copies? (I think they're all going to have to reside on the
shared drive. When I moved a copy off of the shared drive onto another
network drive I got the message that the front end was disconnected).

Thanks Beaucoup!
Mike
 
In the same way that's much better to split a MDB database into a frontend
and a backend and give a personal copy of the frontend to everyone, each
user should have his or her own copy of the ADP file. If you want to
compile to ADE, the compilations should be done separately on each user's
machine to make sure that you don't any problem with any difference in
versions of Windows, Service Packs and support files and libraries.

For you deconnection problem about locating copies out of a shared drive, I
don't understand it; however, it should be easy to reconnect them from the
File -> Connection menu.
 
Thank you very much for your reply and for confirming my suspicions. Thank
you also for the re-connection information. I didn't know that.

Mike


Sylvain said:
In the same way that's much better to split a MDB database into a frontend
and a backend and give a personal copy of the frontend to everyone, each
user should have his or her own copy of the ADP file. If you want to
compile to ADE, the compilations should be done separately on each user's
machine to make sure that you don't any problem with any difference in
versions of Windows, Service Packs and support files and libraries.

For you deconnection problem about locating copies out of a shared drive, I
don't understand it; however, it should be easy to reconnect them from the
File -> Connection menu.
I searched this forum but didn't find anything like this that looked like
it
Click to expand...
[quoted text clipped - 30 lines]
Thanks Beaucoup!
Mike
Click to expand...
Click to expand...
 
Back
Top