Re: Compact and Repair in Front-Ends

You need to ensure that all users have Change permission (that's Read,
Write, eXecute and Delete) on the folder where the MDB file exists. This is
done through the operating system, not through Access.

You need to ensure that the permissions for the Share and for the folder
itself aren't contradicting one another.

For what it's worth, setting the backend to compact on close does nothing.
You're not actually opening the backend (even though you'll see a locking
file created when there's actually a connection to the database). As well,
you're generating far more network traffic having the frontends on the
server, rather than on each user's hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jim Normile" <JimNormile@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E996767D-F75B-4F43-A238-0054EE087D7B@xxxxxxxxxxxxxxxx
Attention MVP

I am sorry for posting the following in a reply box, but I cannot open a
new
post pane, no matter what I try...............Can you transfer this post
to
the correct category and give me some asistance???.....Again my apolagies
JN

Here's the query>>>>

Problem:

I have split an mdb database and placed the backend, the linked frontend
and
three linked copies of the frontend in a folder on a server. The folder is
accessible to users on four linked machines. The format is 2000 and the
installed version of Access on the machines is 2003. Shortcuts from each
of
the frontends have been placed on the desktops of the user machines. From
these the users can open their frontends and use them.

There is one problem. All frontends and the backend are set to compact and
repair automatically on close. This happens as required on one of the
machines, but on the other three the compact/repair fails, because the
database is behaving as write-protected on each of these machines. Thus
the
Backup temporary DB1 cannot be deleted, nor can due process be completed
with
the actual frontend. As a result, with each failure to compact, a residual
Db1,Db2, Db3 etc is being left in the server folder, while the actual DB
is
not being updated with a c/r.

The problem can be overcome by going to the server folder on the machine
which is behaving properly, deleting the temp Db1, Db2, Db3 etc and
performing a Compact/Repair on each frontend, which works fine on this one
machine, for all frontends.

I cannot see any write-protect/read only element in the DB properties when
I
examine each frontend, either from it's own operating machine, or from the
one machine which is OK.

If I go to the server folder through any of the problematic machines, I
cannot delete the temp Db1,Db2, Db3 etc...because the machine thinks they
are
write-protected also!!

I have a number of databases operating on different Client systems, each
following the same distribution idea......Folder with frontends and
backend
on server....short-cutted to user machines. I have not experienced this
problem before. I assume it's something to do with how the machines are
set
up on the network, which is not my strong area

So I think the question is how to persuade each of the "Problematic"
machines to see the databases in the server folder as NOT being
write-protected. Any advice???

You can e-mail a reply to me at jimnormile@xxxxxx, as I am having problems
sending this as a new post

Any Help appreciated

Jim Normile
,




.

Relevant Pages

  • Re: Compact and Repair in Front-Ends
    ... eXecute and Delete) on the folder where the MDB file exists. ... installed version of Access on the machines is 2003. ... the frontends have been placed on the desktops of the user machines. ... Db1,Db2, Db3 etc is being left in the server folder, while the actual DB ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Printers Folder
    ... "EMF formatted spl files. ... GDI files are usually in ... WINNT\temp folder? ... The 2000 machines are running with the latest SP ...
    (microsoft.public.win2000.printing)
  • Re: Home Networking
    ... Do both machines have identical userid/password combos? ... on the network. ... >therefore be viewed in the My Network Places folder, ... >> Using The Shared Documents Folder ...
    (microsoft.public.windowsxp.newusers)
  • Re: Best way to do a HD "back up"?
    ... Boot in target disc mode via firewire and just ... either network or TDM between machines. ... I know for eg that my movies and iTUnes folder hasn't ...
    (uk.comp.sys.mac)
Loading