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
|
|||
|
|||
Make an Access Database multi user
I work at a place that has An Access Database. There are five departments.
Each department is using its own version of the same access database. They use post it notes to add data from department to department. I want to make it multiuser. In a design to make it multi-user, I am thinking that I need to: 1) Install and configure our network 2) Install Microsoft SQL Server 3) Create a SQL Server database from the Access Tables 4) Change the application to use the SQL Server database tables 5) Put the application on a network share drive. Is this the proper way to upscale an Access 2003 application to be available to multiple users? Thanks Tony |
#2
|
|||
|
|||
Make an Access Database multi user
"Webtechie" wrote in message
... I want to make it multiuser. In a design to make it multi-user, I am thinking that I need to: 1) Install and configure our network 2) Install Microsoft SQL Server 3) Create a SQL Server database from the Access Tables 4) Change the application to use the SQL Server database tables 5) Put the application on a network share drive. Is this the proper way to upscale an Access 2003 application to be available to multiple users? You don't *need* to upsize to SQL Server, you *can* use a file containing Access tables. More info he http://www.granite.ab.ca/access/splitapp/index.htm Keith. www.keithwilby.co.uk |
#3
|
|||
|
|||
Make an Access Database multi user
How many users in each department? How many total active users? If 50, you
may get by with splitting the db, putting the backend on the network, and a common frontend on each user station. search this site for splitting a db "Webtechie" wrote: I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. They use post it notes to add data from department to department. I want to make it multiuser. In a design to make it multi-user, I am thinking that I need to: 1) Install and configure our network 2) Install Microsoft SQL Server 3) Create a SQL Server database from the Access Tables 4) Change the application to use the SQL Server database tables 5) Put the application on a network share drive. Is this the proper way to upscale an Access 2003 application to be available to multiple users? Thanks Tony |
#4
|
|||
|
|||
Make an Access Database multi user
On Wed, 10 Jun 2009 02:04:01 -0700, Webtechie
wrote: I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. They use post it notes to add data from department to department. I want to make it multiuser. In a design to make it multi-user, I am thinking that I need to: 1) Install and configure our network 2) Install Microsoft SQL Server 3) Create a SQL Server database from the Access Tables 4) Change the application to use the SQL Server database tables 5) Put the application on a network share drive. Is this the proper way to upscale an Access 2003 application to be available to multiple users? Well, it's a bit like buying an 18-wheeler semitrailer truck to haul a couple of bales of hay... when you already have a perfectly capable pickup. Access is multiuser and network capable right out of the box. Split the database into a "backend" containing your tables and a "frontend" containing the forms, reports, and other user interface; give each user a copy of the frontend all linked to the same backend, and you're good to go. SQL/Server makes a very good backend, and you wouldn't be "wrong" to do as you suggest, but it's certainly not essential, and will be a lot more work. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Make an Access Database multi user
Thanks everyone. I never heard of splitting the database. I will do some
proper research and compare it to installing SQL Server. Thanks again. Tony. "Maarkr" wrote: How many users in each department? How many total active users? If 50, you may get by with splitting the db, putting the backend on the network, and a common frontend on each user station. search this site for splitting a db "Webtechie" wrote: I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. They use post it notes to add data from department to department. I want to make it multiuser. In a design to make it multi-user, I am thinking that I need to: 1) Install and configure our network 2) Install Microsoft SQL Server 3) Create a SQL Server database from the Access Tables 4) Change the application to use the SQL Server database tables 5) Put the application on a network share drive. Is this the proper way to upscale an Access 2003 application to be available to multiple users? Thanks Tony |
#6
|
|||
|
|||
Make an Access Database multi user
Webtechie wrote:
I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. Are those departments on the same LAN and in the same building? Or are the spread out in different buildings? How stable and fast is the connection between the buildings? If it's a WAN environment then either SQL Server or Terminal Server should be used. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/ |
#7
|
|||
|
|||
Make an Access Database multi user
Tony,
There are in different buildings. There is not a network now. That is the first thing I need to do is create a network. So I hope it will be stable and fast. I am leaning more toward using SQL Server. Thanks. Tony "Tony Toews [MVP]" wrote: Webtechie wrote: I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. Are those departments on the same LAN and in the same building? Or are the spread out in different buildings? How stable and fast is the connection between the buildings? If it's a WAN environment then either SQL Server or Terminal Server should be used. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/ |
#8
|
|||
|
|||
Make an Access Database multi user
Webtechie wrote:
There are in different buildings. There is not a network now. That is the first thing I need to do is create a network. So I hope it will be stable and fast. Ahh, ok, then that's a bit or a lot more troublesome. I am leaning more toward using SQL Server. Yes, if not on a LAN then SQL Server or Terminal Server is strongly recommended. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/ |
Thread Tools | |
Display Modes | |
|
|