469,159 Members | 1,382 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Multiple users on access 03

Hi all,
for access 03, do we need special code to allow multiple users to add, delete, edit records at the same time? or access 03 already has this function built in?

thanks!
bluemoon
Feb 25 '09 #1
11 1314
RuralGuy
375 Expert 256MB
The function is already there but you need to split the db and give everyone their own copy of the FrontEnd.
Feb 25 '09 #2
thank you. I already did split the db into backend and frontend and only distribute to the users the frontend.

thanks!

bluemoon
Feb 25 '09 #3
RuralGuy
375 Expert 256MB
You are welcome and have fun.
Feb 25 '09 #4
NeoPa
32,167 Expert Mod 16PB
It's also possible of course (without FE/BE split), if you ensure all clients are configured to work in a compatible way from Tools / Options / Advanced.
Feb 26 '09 #5
RuralGuy
375 Expert 256MB
NeoPa: It is my understanding that not splitting a db in a MultiUser situation is a formula for corruption. Is this *not* the case?
Feb 26 '09 #6
NeoPa
32,167 Expert Mod 16PB
I'm no expert as my experience is only with a quite low level of multiple usage for any of my databases.

It wouldn't surprise me to hear that corruptions abound, but I'm not sure if the Advanced tab settings in such cases were ever set up correctly.

I certainly haven't experienced a problem (certainly not that I was aware was caused by this issue). I'm pretty sure all the corruptions I've experienced were related to updating the design (code etc), when I would necessarily have had the database opened exclusively anyway.

Please understand, I'm not saying my experience proves this is NOT the case, simply that it hasn't been for me (and I'm certainly not suggesting the OP re-merge his databases in this case).
Feb 26 '09 #7
RuralGuy
375 Expert 256MB
The Microsoft Team thinks it is a good idea:
http://office.microsoft.com/en-us/ac...400961033.aspx
...as does MVP Tony Toews:
http://www.granite.ab.ca/access/splitapp/why.htm
I believe most of the MVPs recommend this for MultiUser situations.
Feb 26 '09 #8
NeoPa
32,167 Expert Mod 16PB
Not really an easy discussion to have in a thread. There's relevant, and irrelevant in those links. If there's one relevant point in there that would tend to sway me, it's the implication that corruptions are more likely in an environment where a single database is used. I split my databases, but I don't have multiple copies of the FE. I haven't found it to be necessary (in the ten or so years I've been working with them), although my direct experience is hardly a survey.

Having said that, it was never my position that multiple FEs is a bad idea, or that anyone already with that setup should consider changing their approach.
Feb 26 '09 #9
RuralGuy
375 Expert 256MB
I understood that NeoPa. It is just that corruption can be so destructive that I feel all precautions should be taken where possible.
Feb 26 '09 #10
NeoPa
32,167 Expert Mod 16PB
Probably wise words when all is said and done. I think I'm on the brink of switching to recommending that solution only in future. Particularly when the questioner is not known to be pretty experienced in their own right.
Feb 26 '09 #11
NeoPa
32,167 Expert Mod 16PB
For anyone interested, a Hijack post has been split across to Multi-User Lockout.
Aug 18 '10 #12

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by Berj | last post: by
9 posts views Thread by Graham | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.