By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Multiple users on access 03

P: 56
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
Share this Question
Share on Google+
11 Replies


RuralGuy
Expert 100+
P: 375
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

P: 56
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
Expert 100+
P: 375
You are welcome and have fun.
Feb 25 '09 #4

NeoPa
Expert Mod 15k+
P: 31,411
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
Expert 100+
P: 375
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
Expert Mod 15k+
P: 31,411
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
Expert 100+
P: 375
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
Expert Mod 15k+
P: 31,411
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
Expert 100+
P: 375
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
Expert Mod 15k+
P: 31,411
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
Expert Mod 15k+
P: 31,411
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.