Help with setting up a file server to host MS Access Database
Last response: in Business Computing
Good morning,
I recently bought a dell R310 server so that we can run a Microsoft Access Database on there. At the moment the sales team have to go to a single computer on a desk in the corner of the office to add new orders, clients etc to our access database.
The server will host the access database and all the sales staff will be able to update the database (adding customers etc) from their own workstation via access.
I'm pretty new to configuring servers, I've done an awful lot of googling to try and figure this out myself but this has to be done for Monday and I'm not in the office for weekend so I thought it was time to ask!
I've plugged all the server in etc, i've done the initial startup configuration of windows server so the server is activated but now I'm at a standstill with regards to actually being able to share a folder/file on the server.
Although we have windows server installed on there MS access just connects to the database which is simply a file (obviously) so I imagine windows server would have nothing to do with it apart from it being the UI for me to do things on the server would it?
I personally imagined it would be as simple as putting the DB on the server, sharing it and then simply configuring MS access to connect to the shared database.
I would be very grateful if somebody could help me out with this, if I'm honest I need help from start to finish (excluding the initial configuration of windows server of course).
Thank you
I recently bought a dell R310 server so that we can run a Microsoft Access Database on there. At the moment the sales team have to go to a single computer on a desk in the corner of the office to add new orders, clients etc to our access database.
The server will host the access database and all the sales staff will be able to update the database (adding customers etc) from their own workstation via access.
I'm pretty new to configuring servers, I've done an awful lot of googling to try and figure this out myself but this has to be done for Monday and I'm not in the office for weekend so I thought it was time to ask!
I've plugged all the server in etc, i've done the initial startup configuration of windows server so the server is activated but now I'm at a standstill with regards to actually being able to share a folder/file on the server.
Although we have windows server installed on there MS access just connects to the database which is simply a file (obviously) so I imagine windows server would have nothing to do with it apart from it being the UI for me to do things on the server would it?
I personally imagined it would be as simple as putting the DB on the server, sharing it and then simply configuring MS access to connect to the shared database.
I would be very grateful if somebody could help me out with this, if I'm honest I need help from start to finish (excluding the initial configuration of windows server of course).
Thank you
More about : setting file server host access database
Do what you're thinking. The problem is that with the database only one person would be able to connect to it at a time for modifications. Otherwise they may only receive a read-only copy.
Basically, you would share the database out and each person would access it from their computer. They would probably need Access or another application to input data into the database, or really it depends on how the database was setup.
Basically, you would share the database out and each person would access it from their computer. They would probably need Access or another application to input data into the database, or really it depends on how the database was setup.
Related ressources:
- ForumNeed help setting a gaming server
- ForumLinksys E2000 and Split MS Access Database
- ForumNeed help setting up small business!
- Forum$1500 - $1800 Server for Database and Filesharing
- ForumWhy is hosts file not being used?
- ForumUpdating an Access database with a PDA
- ForumSetting up a server
- Forumneed help setting up ICS, vista host , XP home client.
- Forumwhat Pocket PC will work with MS Works Database ?
- ForumSetting up a VPN server
- Forumhelp with setting up File Access Rights in Windows 2003
- ForumProblem sharing MS Access in windows 7
- ForumSetting up file server .
- ForumHelp with setting up a File & email & printer Server
- ForumSmall Business Server Build - Help Request!
- ForumSATA performance vs standard IDE for small database server
- ForumSetting up file sharing server - help !
- ForumBenefits of cloud computing
- ForumCombining 2 hard drives on a server
- ForumLooking for Dual WAN Router (Need Help Purchasing)
- More resources
Read discussions in other Business Computing categories
!
