Distributed File System (DFS)

[Alan]

Has anyone used access databases with Microsoft's DFS? We
currently have a DFS Setup that is fully replicated. Users
connect to \\domain\server that is point to two servers in
a dfs replica. My question is how do the access databases
keep in sync if two users open the same database on
different servers?

 

[Douglas J. Steele]

Unless you're using DFS differently than we do, you don't actually have the
same file on two different servers. What DFS allows you to do is treat
multiple servers as a single share point: you map a drive to \\server\share,
but the folders that are underneath that share point can be on multiple
servers. In other words, if you've mapped \\server\share to your G: drive,
G:\Folder1 might actually exist on server1, while G:\Folder2 might exist on
server2.

 

[Guest]

We are using it differently. Our DFS is setup as full
replication partners. Identical structures on both
servers, one master and one secondary. Both replicate
changes to each other

 

[Tony Toews]

We are using it differently. Our DFS is setup as full
replication partners. Identical structures on both
servers, one master and one secondary. Both replicate
changes to each other

Then you could run into all kinds of troubles with an Access database.
Does DFS support Access replication or not? If not then when someone
updates the MDB on one system the entire MDB will likely be copied to
the other system. If it does then you really need to be reviewing
replication in depth.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm