If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
data entry in multiuser environment.
I have a database that is shared across a network drive. I need multiple
people to be able to open, and enter data in a form at the same time and save their work. Is it possible for concurrent saves in an access database? Does splitting the database into a back end and front end allow multiple users to save in a form at the same time? |
#2
|
|||
|
|||
data entry in multiuser environment.
Yes, the database should be split. The frontend should be set so that EACH
user has a copy on their machine. See here for more about splitting: http://www.members.shaw.ca/AlbertKallal/Articles/split/ And if you use my Frontend Auto Update Enabling tool, it will enable you to do auto updates of your frontends. Yes, the first distribution you will need to get it to people somehow and that is in your court. But, if you have enabled auto updating, then you can just go into your master file on the network, make your changes, change the version number in two tables (one in the frontend and one in the frontend that is linked to the backend), then when your users open their frontend and the version numbers don't match it will tell them that their frontend is out-of-date and it will close, delete the old file, copy the new file, and then reopen for them automatically. I had to create this for a big healthcare provider I worked for which originally had over 100 users using a single mdb frontend on the server and they wondered why it crashed each week, or several times each week. So, once we implemented this and moved to frontends on each user's machine, they never had a corruption issue again as long as I was there. You can download it he http://www.btabdevelopment.com/main/...8/Default.aspx -- Bob Larson Access MVP Access World Forums Administrator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "sleeperjjb" wrote: I have a database that is shared across a network drive. I need multiple people to be able to open, and enter data in a form at the same time and save their work. Is it possible for concurrent saves in an access database? Does splitting the database into a back end and front end allow multiple users to save in a form at the same time? |
#3
|
|||
|
|||
data entry in multiuser environment.
Could i run into a problem with users having older versions of access and
trying to open my FE access 2000 version file? "boblarson" wrote: Yes, the database should be split. The frontend should be set so that EACH user has a copy on their machine. See here for more about splitting: http://www.members.shaw.ca/AlbertKallal/Articles/split/ And if you use my Frontend Auto Update Enabling tool, it will enable you to do auto updates of your frontends. Yes, the first distribution you will need to get it to people somehow and that is in your court. But, if you have enabled auto updating, then you can just go into your master file on the network, make your changes, change the version number in two tables (one in the frontend and one in the frontend that is linked to the backend), then when your users open their frontend and the version numbers don't match it will tell them that their frontend is out-of-date and it will close, delete the old file, copy the new file, and then reopen for them automatically. I had to create this for a big healthcare provider I worked for which originally had over 100 users using a single mdb frontend on the server and they wondered why it crashed each week, or several times each week. So, once we implemented this and moved to frontends on each user's machine, they never had a corruption issue again as long as I was there. You can download it he http://www.btabdevelopment.com/main/...8/Default.aspx -- Bob Larson Access MVP Access World Forums Administrator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "sleeperjjb" wrote: I have a database that is shared across a network drive. I need multiple people to be able to open, and enter data in a form at the same time and save their work. Is it possible for concurrent saves in an access database? Does splitting the database into a back end and front end allow multiple users to save in a form at the same time? |
#4
|
|||
|
|||
data entry in multiuser environment.
Yes. But, if you develop the fe and be in the oldest version, the newer
versions will have no problem with it. -- Dave Hargis, Microsoft Access MVP "sleeperjjb" wrote: Could i run into a problem with users having older versions of access and trying to open my FE access 2000 version file? "boblarson" wrote: Yes, the database should be split. The frontend should be set so that EACH user has a copy on their machine. See here for more about splitting: http://www.members.shaw.ca/AlbertKallal/Articles/split/ And if you use my Frontend Auto Update Enabling tool, it will enable you to do auto updates of your frontends. Yes, the first distribution you will need to get it to people somehow and that is in your court. But, if you have enabled auto updating, then you can just go into your master file on the network, make your changes, change the version number in two tables (one in the frontend and one in the frontend that is linked to the backend), then when your users open their frontend and the version numbers don't match it will tell them that their frontend is out-of-date and it will close, delete the old file, copy the new file, and then reopen for them automatically. I had to create this for a big healthcare provider I worked for which originally had over 100 users using a single mdb frontend on the server and they wondered why it crashed each week, or several times each week. So, once we implemented this and moved to frontends on each user's machine, they never had a corruption issue again as long as I was there. You can download it he http://www.btabdevelopment.com/main/...8/Default.aspx -- Bob Larson Access MVP Access World Forums Administrator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "sleeperjjb" wrote: I have a database that is shared across a network drive. I need multiple people to be able to open, and enter data in a form at the same time and save their work. Is it possible for concurrent saves in an access database? Does splitting the database into a back end and front end allow multiple users to save in a form at the same time? |
#5
|
|||
|
|||
data entry in multiuser environment.
I split the database into a FE and BE but then needed to add a new table. I
assumed that i create it in the BE but when i open the FE it doesn't show up and when i run linked table manager and refresh it, the new table still doesn't show up. How do you create new tables in the BE and have them linked in the FE "boblarson" wrote: Yes, the database should be split. The frontend should be set so that EACH user has a copy on their machine. See here for more about splitting: http://www.members.shaw.ca/AlbertKallal/Articles/split/ And if you use my Frontend Auto Update Enabling tool, it will enable you to do auto updates of your frontends. Yes, the first distribution you will need to get it to people somehow and that is in your court. But, if you have enabled auto updating, then you can just go into your master file on the network, make your changes, change the version number in two tables (one in the frontend and one in the frontend that is linked to the backend), then when your users open their frontend and the version numbers don't match it will tell them that their frontend is out-of-date and it will close, delete the old file, copy the new file, and then reopen for them automatically. I had to create this for a big healthcare provider I worked for which originally had over 100 users using a single mdb frontend on the server and they wondered why it crashed each week, or several times each week. So, once we implemented this and moved to frontends on each user's machine, they never had a corruption issue again as long as I was there. You can download it he http://www.btabdevelopment.com/main/...8/Default.aspx -- Bob Larson Access MVP Access World Forums Administrator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "sleeperjjb" wrote: I have a database that is shared across a network drive. I need multiple people to be able to open, and enter data in a form at the same time and save their work. Is it possible for concurrent saves in an access database? Does splitting the database into a back end and front end allow multiple users to save in a form at the same time? |
#6
|
|||
|
|||
data entry in multiuser environment.
"sleeperjjb" wrote in message news I split the database into a FE and BE but then needed to add a new table. I assumed that i create it in the BE but when i open the FE it doesn't show up and when i run linked table manager and refresh it, the new table still doesn't show up. How do you create new tables in the BE and have them linked in the FE The linked table manager only refreshes tables which are already linked - not new ones. To include a new table, open the frontend and use File... Get External Data... Link to find and connect to the new table. Then distribute the new frontend to the users (frontends contain no data so they can be safely just destroyed and replaced as needed). |
Thread Tools | |
Display Modes | |
|
|