Help With Datbase Setup

the_rmg

the_rmg

the_rmg

Associate
Joined
13 Nov 2006
Posts
41
Location
Solihull
Hi All,

I am hoping that you may be able to help me with a database problem.

I work for a company that deals in a lot of second hand items, so I end up selling a lot on that well known auction site. The problem that I have is that is becoming quite a pain keeping track of the items listed/sold etc in excel. I am able to set up an access database, but was wondering if it was possible for more than one person to work on the one file at the same time?

If this is not possible, what would be the best approach into organising and setting up a database for more than 2 people to use at any one time?

All help greatly appreciated.

Cheers

Ross
 
You can have a number of people using an Access database although if you have too many it can be slow. How many people are going to use this database?
 
Between 2 and 4 people at any one time, so not too many people. How do I go about setting it up for use by more than one person?
 
I do have a book on MySQL, php and apache. I just havnt managed to get the time to go through it. I think that an SQL type would be more suitable in the long run. Would I have to program a user interface (GUI) for this method?
 
the_rmg said:
I do have a book on MySQL, php and apache. I just havnt managed to get the time to go through it. I think that an SQL type would be more suitable in the long run. Would I have to program a user interface (GUI) for this method?
Click to expand...
For using PHP you would if you wanted like a web page GUI, but it's not *very* hard to do, just a little complex and could be a bit daunting if you've not used PHP + MySQL before. If you are planning though to give it a whirl, you could check out EasyPHP which installs apache, mysql and php pre-configured and it is VERY easy to use it. Then just get a MySQL editor, such as MySQL Query Browser. I use both on my home development box for offline coding and they worth great.
 
That great, thanks for that info.

If I did want to use a single access file with more than one user how would I go about it? As I tried to do this by putting it in the my shared folder and opening it on two machines, and it would not open on the second, only the first machine.
 
Not sure, but I had a quick check on internet for you and found this thread which might be able to help, seems you might have to split the database up into 2 parts.
 
Sorry guys but why bother with all the hassle this could be accomplished in a few hours in Access easily. Create a few tables, setup some queries and design a few forms and reports, job done.
 
I agree, you obviously dont need a complex or big database. Access is perfect for small low user databases, its UI is easy to pick up.

Go with Access but try your best to ensure your tables and relationships are up to scratch, purely so that you make the database as future proof as possible.
 
Hi Guys,

I can set up the database in access, I feel that this would be a good idea due to the low user volume, but I do need to be able to access the database by more than one user at the same time. So I need to figure out how to go about that. The database will be in use by at least two users simultaneously.

Cheers
 
the_rmg said:
Hi Guys,

I can set up the database in access, I feel that this would be a good idea due to the low user volume, but I do need to be able to access the database by more than one user at the same time. So I need to figure out how to go about that. The database will be in use by at least two users simultaneously.

Cheers
Click to expand...

Hi Mate

It's simple just have the database on your network and any user who wants to use the DB just opens it. Access has record level locking so it shouldn't be a problem. I've got a 50mb Access DB being used by 6 people without any problems. One of my tables has 80,000 records.

You can split the front end and backend but due to some Oracle queries I use in Access I couldn't but it was fine.
 
You must log in or register to reply here.
Back
Top Bottom