Personal MS Access server? - Tilted Forum Project Discussion Community

Silvy · 09-03-2004, 12:26 AM

Hi,

A friend asked me wether he could "share a database" between 2 pc's.
He's got a database in Access, and he has MS office XP Professional installed (IIRC). He wants to be able to edit the database 'simultaneously' from 2 locations.

I don't use MS office, so I can't check, but is there any way to serve the Access database to clients with that setup, or does he need extra software?

thanx for any tips!

NeoSparky · 09-03-2004, 08:24 AM

the access file is nothing more than a file in the setup you described. Yes you can edit the file in 2 locations but if your making any change other than database related you will encounter the old who saved last wins scenario.

Silvy · 09-04-2004, 12:28 AM

Quote:

Originally Posted by NeoSparky

the access file is nothing more than a file in the setup you described. Yes you can edit the file in 2 locations but if your making any change other than database related you will encounter the old who saved last wins scenario.

Exactly, and since the 2 clients cannot practically be synchronized, he will need some type of (sql?) server to handle table locking etc.

Any idea as to what the easiest way would be?
(I'm also thinking: it could be possible to use a locking file that shows who's editing. If the file exists the other is editing, and the client needs to wait. The file dissappears and the client can edit the database..... a mutex aproach
But I'd rather have a more elegant solution)

rubicon · 09-07-2004, 04:52 PM

I don't have an exact answer for you but the Access database can be accessed by multiple users at once. You may need to set an instruction in Access to perform record-level locking instead of table-level - I'm not sure what the default is.

Do a Google search for "multiuser access" and you'll find some advice. If this is an important database I recommend splitting the code from the tables as one of the articles explains. I support an Access database where everything is in one MDB file and it's tedious when I need to make changes, however it's used concurrently by 3-4 users just fine.

Silvy · 09-07-2004, 05:17 PM

Thanx a lot, this was the kind of answer I was looking for!

I'll check into that...

09-03-2004, 12:26 AM	#1 (permalink)
Silvy paranoid Location: The Netherlands	Personal MS Access server? Hi, A friend asked me wether he could "share a database" between 2 pc's. He's got a database in Access, and he has MS office XP Professional installed (IIRC). He wants to be able to edit the database 'simultaneously' from 2 locations. I don't use MS office, so I can't check, but is there any way to serve the Access database to clients with that setup, or does he need extra software? thanx for any tips! __________________ "Do not kill. Do not rape. Do not steal. These are principles which every man of every faith can embrace. " - Murphy MacManus (Boondock Saints)

09-07-2004, 04:52 PM	#4 (permalink)
rubicon Stop. Think. Question. Location: Redondo Beach, CA	I don't have an exact answer for you but the Access database can be accessed by multiple users at once. You may need to set an instruction in Access to perform record-level locking instead of table-level - I'm not sure what the default is. Do a Google search for "multiuser access" and you'll find some advice. If this is an important database I recommend splitting the code from the tables as one of the articles explains. I support an Access database where everything is in one MDB file and it's tedious when I need to make changes, however it's used concurrently by 3-4 users just fine. __________________ How you do anything is how you do everything.

09-07-2004, 05:17 PM	#5 (permalink)
Silvy paranoid Location: The Netherlands	Thanx a lot, this was the kind of answer I was looking for! I'll check into that... __________________ "Do not kill. Do not rape. Do not steal. These are principles which every man of every faith can embrace. " - Murphy MacManus (Boondock Saints)

09-03-2004, 08:24 AM	#2 (permalink)
NeoSparky Crazy	the access file is nothing more than a file in the setup you described. Yes you can edit the file in 2 locations but if your making any change other than database related you will encounter the old who saved last wins scenario.