Helping voluntary center - Muliple users, one access file.

S

SpencerK

New member

Local time

Today, 10:25

Joined

Sep 18, 2008

Messages

3

• Sep 18, 2008

• #1

[FONT=&quot]Hey there folks.. I'm helping a voluntary center with an Access database problem.

Basically I need some help with getting an Access database available to all users on the network. They have a small business server running Windows Server 2003. I have built them a database, this database allows user to be able to put in information regarding callers specific disabilities. There can be upto 3 callers at any one point, and 3 operators.

Problem.
I need to find out how 3 people can access the same database file, at the same time, without getting an error. Each user must be able to save and edit the same records, if needed, and add records. The database is not complexe, by any means, just a few forums with some basic quiries.

Any ideas on how to allow user to access this database and still be able to save data.

I understand this is more of a server administration specfic problem. But some of you here may have actually implemented what we need. I am new to the Windows 2003 server envoirnment, so any tips, links, advice would be great.

Thank you very much for any response.

Spencer K [/FONT]

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 02:25

Joined

Aug 30, 2003

Messages

36,270

• Sep 18, 2008

• #2

I'd start here:

http://allenbrowne.com/ser-01.html

You'll have trouble letting multiple users edit the same record at the same time however.

 

S

SpencerK

New member

Local time

Today, 10:25

Joined

Sep 18, 2008

Messages

3

• Sep 18, 2008

• #3

Thank you very much indeed for the link. To be honest, I could never see a situation whereby 2 operators would be using, or need to use, the same file - but it was something that was asked.

Will have a look through that link, and report back if it works. But if anyone else has anymore links to give, that would be great. The more the merrier.

Spencer K

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 02:25

Joined

Aug 30, 2003

Messages

36,270

• Sep 18, 2008

• #4

It's no problem for more than one person to use the db at the same time, but it should be split as described in the link. You want more?

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

 

S

SpencerK

New member

Local time

Today, 10:25

Joined

Sep 18, 2008

Messages

3

• Sep 21, 2008

• #5

Thank you very much for those links. There is a lot of good information within, not just on splitting the database, but performence enchancing tips etc..

Good stuff.

Have a nice day

Spencer K