Database stuff

VeNT

VeNT

VeNT

Soldato
Joined
9 Jan 2003
Posts
21,137
Location
Cornwall
ok I'm a total noob with databases etc and I'm totaly basing this on the bits I know about DB's but here goes

I've a situation where I need 2-3 users to be able to edit a spreadsheet/database at the same time, its very simple sheet but would like the extra functionality of a database (filters etc)
we're getting a Small business server soon so I dunno if SQL would help or be even part of the solution but I was wondering if theres some kinda way to make a excell spreadsheet available to three users at the same time?
 
in my work, we just need a very simple excel doc for multiple users, so we just use googledocs excel, lol
 
If it's only small, a network hosted access database would be fine for this. Create a form for adding data and some simple reports and away you go :)
 
so that would work with access yeah? was hoping you'ed say that
is there another option that would use a server/SQL and if so what advantages would it have?

also would I need copys of access on each PC or just for making the database?
 
Last edited:
VeNT said:
so that would work with access yeah? was hoping you'ed say that
is there another option that would use a server/SQL and if so what advantages would it have?

also would I need copys of access on each PC or just for making the database?
Click to expand...

Running on a SQL backend would be faster, but Access is fine for several users and probably easier to pickup. With SQL you would probably create a front end in ASP/PHP etc, whereas Access you just drop fields in easily. If it is potentially a larger scale in future, you could start off in SQL, but you should be able to port Access->SQL in future relatively fine.

You will need Access on client machines, the back end file is basically the mdb of your tables, and so you chuck that on a network share. I made a small db for someone like this, i created a bat file that mounted the share to a drive letter then loaded the Access front end.
 
hmm, thats looking more and more expencive with access
4-5 copys of access are gonna be quite a bit
 
might be worth doing what bledd suggests, googledocs, it's cheaper (free), or if you have time build a php/sql "solution", if its basic stuff you need to do it shouldnt take you that long.
 
You must log in or register to reply here.
Back
Top Bottom