Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I am new to Access. I have a doubt. 1
- Thread starter kalpsv
- Start date
-
1
- #2
>I am new to Access. I have a doubt.
Welcome to Access ... have no fear, tek-tips is here!
>Can there be multiusers to the same database?
Yes - most definitely, but If you would like some user restritctions, I recommend reading up on workgroups.
>Can there be multiaccess by multiusers to the same
table?
Yes, but this can be tricky. As long as they don't simultaneously update the exact same record (this should be an extremeley rare occurance - i design DB's all the time and this has happend to me only once) you should be ok. If 2 users are in the same table ,they will only effect the records they are working on. You sohuld have no problem
>I intend having the db in a single PC and have network
connection.
Good. If the database is going to be a large one, consider reading some of the posts in that link that's in my signature (down below where my email is). It suggests splitting your database - having a front end DB on each user's machine and having the back end with all the data on a server.
>Can simultanoues updates be allowed?
Yes, as long as they aren't updating the records at the same time you should be ok. If you want to restrict users from updating certain records, read up on workgroups.
>thanks in advance
Your welcome. Get used to posting here. Lucky for all of us, this is a great place.
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
Welcome to Access ... have no fear, tek-tips is here!
>Can there be multiusers to the same database?
Yes - most definitely, but If you would like some user restritctions, I recommend reading up on workgroups.
>Can there be multiaccess by multiusers to the same
table?
Yes, but this can be tricky. As long as they don't simultaneously update the exact same record (this should be an extremeley rare occurance - i design DB's all the time and this has happend to me only once) you should be ok. If 2 users are in the same table ,they will only effect the records they are working on. You sohuld have no problem
>I intend having the db in a single PC and have network
connection.
Good. If the database is going to be a large one, consider reading some of the posts in that link that's in my signature (down below where my email is). It suggests splitting your database - having a front end DB on each user's machine and having the back end with all the data on a server.
>Can simultanoues updates be allowed?
Yes, as long as they aren't updating the records at the same time you should be ok. If you want to restrict users from updating certain records, read up on workgroups.
>thanks in advance
Your welcome. Get used to posting here. Lucky for all of us, this is a great place.
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
kalpsp,
I will elaborate on one issue...the mulit users per table issue...It can be frustrating to know that you can be locked out of a record that no one else is in, due to Access' Page Locking scheme. This means that if several database records are existing in the same 'page', (pages are the units--2k blocks of disk space--that Access allocates to the table) then the entire page is locked along with all records on that page. This means that in a table with small records--say 100 bytes per record--you could have 20 records locked while only one is actually being updated.
This isn't the case if you use the msde with Access 200x.
All in all, you've come to the right place for help!
--Jim
I will elaborate on one issue...the mulit users per table issue...It can be frustrating to know that you can be locked out of a record that no one else is in, due to Access' Page Locking scheme. This means that if several database records are existing in the same 'page', (pages are the units--2k blocks of disk space--that Access allocates to the table) then the entire page is locked along with all records on that page. This means that in a table with small records--say 100 bytes per record--you could have 20 records locked while only one is actually being updated.
This isn't the case if you use the msde with Access 200x.
All in all, you've come to the right place for help!
--Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question
