We help IT Professionals succeed at work.
Get Started

DFSr and Access Database issues & questions

1,247 Views
Last Modified: 2013-11-27
We are running two servers with Windows 2003 R2 SP2 using DFSr. We are replicating a large number of folders between sites. I am well aware of how DFSr replicates and the sharing violations that can and will occur if you have users accessing files on both sides. What is troubles me relates to Access databases.
In one instance we have an Access database, most likely Access 97,  When a user accesses it, the ldb file is generated and then replicates across. This I have observed myself. What I have not observed is that the database updates while the user is in it, which is contrary to how DFSr works, but is what a user is telling me happens.
The other database is Access 2003 and when it is opened the ldb file is generated and it does NOT replicate across to the other server. If I create a file and rename it as an ldb it will replicate, but it does not when Access creates it so replication is working on this folder. The database does not update until the database is closed. All this I have observed
What I am trying to figure out is how Access databases and DFSr interact, or maybe just how these Databases work so I can relate that to how DFSr works. DFSr will not replicate changes until the file is closed and there are no locks. So why am I seeing different behavior?
Questions:
So are the two version of Access working differently with the mdb and ldb files?
1.      Does Access 2003 lock the ldb preventing replication and Access 97 doesnt?
2.      What would you think the expected behavior is for each type of DB?
3.      Can any of this be altered?
Basically I have a user who insisted that last week all databases replicated as soon as the user entered data and that all ldbs replicated, but I am not seeing that now and cannot verify how it was in the past. Looking for answers I can use to settle this issue. Thanks.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE