Using a database with multiple users

[Tim L]

I done a quick search and found a few useful pointers but still have some questions:

1) If you use a FE/BE split give each user their own copy of the FE.
2) Make sure that users do not open the dB Exclusively.
3) Give records their unique id just before the record is saved (using the beforeUpdate event).
4) User access priviledges can cause problems.

Questions on the above:

2) How do you do this?
3) I presume that this could be achieved by having text boxes that correspond to field, then, on chaning to a new record or clicking on a save button, have a new record created (thus assigning an autonumber field) and apply the contents of the text boxes to their respective fields, however this seems a bit cludgy and I suspect that someone could suggest/provide a method with more finess
4) What needs to be set?

And some general questions:

a) Record Locks, I suspect that this should this be set to Edited Record, correct?

b) With an Access 2k compatible database, is there a limit on the number of users that can be accessing the BE at a time, if so, what is it?

c) If you've distributed the FE and have the BE located on a server somewhere, how does the FE locate the BE? Will a dialogue box be automatically generated by the FE or does this have to be programmed?

d) Are there any other considerations that need to be dealt with?

Tim

 

[Tim L]

Thanks for your considered reply Pat.

With regards to:

#2
Will creating a standard database password then splitting the datbase into FE/BE achieve this automatically or will additional programming be required?

3#
If users A and B start to create a record at about the same time, then A cancels (undoes) and C starts to create a record, will the autonumber be set correctly? I.e, is it possible that the records created by B and C will have the same number, or does Access take care of this in the background? (If it does, will there be any gaps between numbers in the autonumber field due to cancelled record generation?)

#4 - Ok. Thanks.

a)
How is optomistic locking achieved? (I can only find settings for No Locks, All Records and Edited Records.)

b-d) - Ok. Thanks again. (although I may be back... )

 

[jsjaedon]

Hi guys, i got a question on this as well.

when setting user permissions and access rights, whatnot, do i do that in the front end or backend?

thanks
jerry

 

[aaronmichael1]

Confused and Frustrated

I am trying to set up sharing and I am really frustrated.

I've set all the security settings I just don't know how to set how other users are logged on to the database. I only have admin and user and I want everyone else signed on as user. I am assuming I have to change something to each of their computers but I am not sure what. Any help would be greatly appreciated.

 

[The_Doc_Man]

If they are coming in without joining the workgroup, they come in by default as ADMIN and have Admins group's rights. This is, as we say, DNG.... definitely not good.

So what you do is create one more account for yourself. Make it a member of the Admins group. THEN make the Admin account (no "s" on the end) no longer a member of the Admins (note the "s") group. It can still be a member of the Users group.

To do this RIGHT, create another group for users. Define the rights you want your users to have for this group. Give your users individual accounts that are members of this new group. Or if they have individual accounts already, make them group members. Then whittle down the USERS group to the minimum rights possible. And if the Admin account is a member of this group, folks will slowly get the hint.

Then you don't care if they refuse to join the right workgroup first.

 

[pafcpilgrim]

Unique identifier

Pat something i have noticed on a program at my new job this week (not access but a VB application) linked to SQL server is the Purchase Orders system.
You open the form add the items you need then when you click save it then assigns a PO number but there have been times when it produces an error while trying to save the record and you have to keep trying before it will close the form and save it.

The thing i am interested in is how does it no what number to assign the next po created by someone else while mine is waiting to get through to the server this type of scenario happens quite a lot to a few of us at the same time and i'm just interested in how it deals with it if you can help.

rgds.