Re: Replication, sharing and exclusive access
- From: "John Barnes" <JohnBarnes@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 3 Oct 2005 19:16:03 -0700
David,
Thanks for the response.
Yes, I tried file open/open exclusive. It's set to do that by default.
Yes, there is an ldb file, and it doesn't delete. I use the following
procedure: users store their replicas on their desktop. Mine (design master)
is in a directory on my hard drive. I bring their replicas to my desktop,
sync, then send back to them. Sometimes it leaves an ldb from a replica, and
sometimes from the design master. Seems to be quite random as to which one
it leaves.
As to your question about someone still being logged on, that's the
confusing part. The computers aren't actually networked. I did have them
set to share some directories and printers (through windows small office
wizard), but they are no longer set to have sharing priveleges. There is no
server. The last time design master did allow me to work in design mode for
creating a report for about 30 minutes, then suddenly gave me an exclusive
access error message. No one truly logs on to a network, so nothing had
changed. Almost seems like there is a timeout setting somewhere . . .
Can the exclusive access violation have something to do with exactly what
drive and folder replicas are stored in on users drives, or where I move them
for replication on my drive?
I just don't understand how there can be sharing violation when there is no
actual sharing occuring.
Thanks!
"David W. Fenton" wrote:
> "=?Utf-8?B?Sm9obiBCYXJuZXM=?="
> <JohnBarnes@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:C9E17D90-2D22-4DE7-A800-1160E623820F@xxxxxxxxxxxxx:
>
> > Have a replicated 2003 database on several machines. Recently
> > networked XP pro machines using small office wizard to share
> > directories and printers. Once that was done, design master no
> > longer allows changes, saying "You do not have exlusive access to
> > the database at this time." I ran the wizard again, removed all
> > shared directories and printers, recovered design master, synced
> > with replicas, and I had design privelges for about 30 minutes,
> > then suddenly it gave a message as I was designing report saying
> > "you do not have exclusive access..."
> >
> > Any ideas on how to convince Access that this is once again a
> > replicated database and design master does have exclusive access?
>
> Have you tried opening Access, hitting the FILE OPEN dialog and
> checking the OPEN EXLUSIVE checkbox? That forces it open.
>
> Also, have you looked to see if there's an LDB file? It could be
> that the LDB file is not getting deleted and it has corrupt
> information in it indicating erroneously that someone has the design
> master open.
>
> If you can't delete it, that either means that someone does, in
> fact, have it open, or that the server process of your machine
> *thinks* it's open. In that case, you can go to the Computer
> Management console in Control Panel | Administrative Tools and check
> the Server listings. That should tell you the last person to have
> the file open. You can then have them close it/log off.
>
> I would never force close the file, as that can corrupt an MDB file.
>
> You might try opening immediately after a reboot of the machine on
> which the file is stored, and open it from that machine.
>
> --
> David W. Fenton http://www.bway.net/~dfenton
> dfenton at bway dot net http://www.bway.net/~dfassoc
>
.
- Follow-Ups:
- Re: Replication, sharing and exclusive access
- From: David W. Fenton
- Re: Replication, sharing and exclusive access
- References:
- Re: Replication, sharing and exclusive access
- From: David W. Fenton
- Re: Replication, sharing and exclusive access
- Prev by Date: Re: Solving conflicts
- Next by Date: Re: Jet 4 Replication Service Pack
- Previous by thread: Re: Replication, sharing and exclusive access
- Next by thread: Re: Replication, sharing and exclusive access
- Index(es):
Relevant Pages
|
