MS Access Multiuser - Split DB With Bound Form

Author

Split DB With Bound Form

MDW

2005-04-15, 11:25 am

Hey all.

I'm going to work on a multi (less than 10) user database and I intend to
split it into f/e and b/e. I want to make sure that I am arcitecting the
thing properly. I want to use a bound form because the users will not be
ENTERING new records, they will instead be EDITING existing records. The
users will enter some info into blank fields and then click on a button to go
to the next record.

What I want to make sure that I don't have two users trying to edit the same
record at the same time. If two people are working simultaneously, and one
person has a record open, no one else can get to that record when they click
on the "Next Record" button. What do I need to do to check/prevent this from
happening?

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

Alex Dybenko

2005-04-16, 3:24 am

you can try to lock record during editing, using form's Record Locks
property. See online help for more info

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

"MDW" <MDW@discussions.microsoft.com> wrote in message
news:A748EA88-2D25-480D-837A- AAC642150F05@microso
ft.com...
> Hey all.
>
> I'm going to work on a multi (less than 10) user database and I intend to
> split it into f/e and b/e. I want to make sure that I am arcitecting the
> thing properly. I want to use a bound form because the users will not be
> ENTERING new records, they will instead be EDITING existing records. The
> users will enter some info into blank fields and then click on a button to
> go
> to the next record.
>
> What I want to make sure that I don't have two users trying to edit the
> same
> record at the same time. If two people are working simultaneously, and one
> person has a record open, no one else can get to that record when they
> click
> on the "Next Record" button. What do I need to do to check/prevent this
> from
> happening?
>
> Thanks.
> --
> Hmm...they have the Internet on COMPUTERS now!

Tony Toews

2005-04-19, 11:24 am

MDW <MDW@discussions.microsoft.com> wrote:

>I'm going to work on a multi (less than 10) user database and I intend to
>split it into f/e and b/e. I want to make sure that I am arcitecting the
>thing properly. I want to use a bound form because the users will not be
>ENTERING new records, they will instead be EDITING existing records. The
>users will enter some info into blank fields and then click on a button to go
>to the next record.

Bound forms work quite well with multiple users. I have many apps
out there some with 25 users in all day.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Sponsored Links