Help With Datbase Setup

the_rmg · 7 Jun 2007 at 15:21

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

the_rmg · 7 Jun 2007 at 15:44

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?

the_rmg · 7 Jun 2007 at 15:55

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 · 7 Jun 2007 at 17:03

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.

the_rmg · 7 Jun 2007 at 17:47

Thanks for that I will have a look at that.

the_rmg · 8 Jun 2007 at 10:06

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