Tilted Forum Project Discussion Community

Tilted Forum Project Discussion Community (https://thetfp.com/tfp/)
-   Tilted Technology (https://thetfp.com/tfp/tilted-technology/)
-   -   Personal MS Access server? (https://thetfp.com/tfp/tilted-technology/67760-personal-ms-access-server.html)

Silvy 09-03-2004 12:26 AM

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!

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...


All times are GMT -8. The time now is 04:47 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54