Re: Replication, sharing and exclusive access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"=?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
.

Relevant Pages

  • replica changes do not match design master
    ... I have inherited an access database that uses synchronization and replicas. ... However when I fix the problem using the Design Master and try to ... turn synchronize to about 7 Area Databases which are then synchronized into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: cannot create design master
    ... >>> (different user logged on same data file). ... >> design master in multiple locations. ... >> Have you compacted the database before trying to replicate it? ... > have not actually created any replicas at all!!!! ...
    (microsoft.public.access.replication)
  • Re: is changing design master safe?
    ... There are replicas which have ... > all the current data in them, the design master has none. ... > master and modified database replicas all with current data. ... be part of your regular working scenario, ...
    (microsoft.public.access.replication)
  • Re: sync fails
    ... Ok it seems that from what I can find out I cannot copy replicas to another ... As we have now some problems synching data the next question is is the DM ... If the design master should be considered unusable what steps should I ... Should I/can I create a new database ...
    (microsoft.public.access.replication)
  • Re: Access 2007 On Open event error in mixed 2003/2007 replicated
    ... The reason I have not split the database is that the ... the databse preventing access to any synchronisation of the backend tables. ... Doug Steele, Microsoft Access MVP ... to the replicas as well. ...
    (microsoft.public.access.formscoding)