More than one user at a time?

[mstng07]

Okay, i need to know if there is a way so that more than one person can be in an access database at one time. Both need to be able to edit, add, delete, etc. within the database.

Is this possible?

 

[mstng07]

well is there a way to just change a setting or add some code somewhere to allow multiple users to do the above things?

 

[GaryPanic]

yes - easy

i presume its sat on a server ?

so you need FE/BE set up

Fronet end - Back end

your tables are on the back end (on a server)and your forms etc are on the front end (the local PC)

you then need to put a copy of the db on each PC




the wizard should help-but sometimes it throws a tantrum..

 

[neileg]

well is there a way to just change a setting or add some code somewhere to allow multiple users to do the above things?

Access allows sharing by default - you don't need to do anything. The problem is that you risk corruption if you don't use a FE/BE setup so this is preferred.

 

[Vududude]

How many simultaneous users are possible? I have about 24 people who need to access a database, probably not all at the same time...perhaps 10 at once?

 

[neileg]

A lot depends on the way the application is designed and on how much network bandwidth you have. The numbers you suggest sound reasonable, however.

 

[mstng07]

Okay, so how can I go about setting up FE / BE ?

I've tried looking up how to do it and haven't had much luck.

Thanks in advance.

 

[mstng07]

Okay so i think i've figured out how to do the fe/be. Is it just a split on the database?

If so, how "safe" is it?

 

[pbaldy]

More info than you'll ever need:

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

It should be safe, but always work on a copy.

 

[mstng07]

Thanks !! I'll check out that link.

Thanks so much

 

[mstng07]

Okay so just to clarify, when say two or three people are in the database at the same time with the fe/be set up, if they're in the same table and editing or adding information, the information won't be lost will it?

It is very imparitive that information from this database not to be lost.

Thanks!

 

[pbaldy]

Nothing should be lost. They can add/edit in the same table no problem. If 2 people try to edit the same record at the same time, the first person to save changes will be successful, the second will get an error. Poke around on record locking to learn more.

A consistently followed backup strategy is always a good idea.

 

[mstng07]

Thank you I greatly appreciate everyones help with this!!