Re: Opening an AccessXP db Question

On Jun 5, 8:52 am, Gigamite <Gigamit...@xxxxxxxxxxxxxxx> wrote:
bobh wrote:
This may not be the right place to ask for help with this issue

This is the right place.  Come on in!

I have contacted the IT group and they insist it's a database issue
and not a pc configuration issue.

Three things can affect this if the users already have read, write and
modify (and some of them have delete) privs on the network directory:

1) The network isn't trusted.  (A PC config issue, so it the IT group's
responsibility.)
2) The db is being opened exclusively to accommodate a design change.
(Could be a database design issue or a PC config issue.)
3) The shortcut only has the path to the database file instead of the
full paths to msaccess.exe and the database file.  (A database
deployer's responsibility.)

I have pointed out that the
'exclusive' message only appears for 'new' pc's and that all the other
users desktop shortcuts pointing to the same database work fine and
have worked for 2+ years which also has not gotten me anywhere with
them.

Save your breath.  Placing blame on the IT group won't get you their
cooperation, even when you're right about who's at fault.

Anyways, my question is has anyone run into this kind the issue
before?

Of course.  Happens all the time.  Usually it's a PC config problem, as
the network isn't trusted when you pull those new PCs out of the box.

Things to do:

1) Open Internet Explorer.  Tools + Internet Options + Security + Local
Intranet.  Click on the "sites" button and select all three choices to
include as the local intranet.  Now the network is trusted.  (If you
change this setting, now would be a good time to test your "mysteriously
exclusively opened" databases to see if this solves the problem.  So you
can say "Aha!")

2) Check if Adobe Acrobat PDFMaker or another vendor's custom toolbar is
installed in Access.  That alters the database design when opening the
database.  Disable the toolbar if it is.

3) Check your shortcut.  Did you take a shortcut and not put the full
paths in there?

also in access97, under tools -> options
advanced tab, there's "default open mode", which can be set to
exclusive
.

Relevant Pages

  • Pathname to access and usernames in shortcut
    ... We are about to deploy a database on our network (Windows/2000 servers ... What we are thinking of is having a batch file or command file which ... same command as we would use for a shortcut) but with the username ...
    (microsoft.public.access.security)
  • Re: Access2000 Security in Network environment
    ... Place your secure .mdw file on the network somewhere and either have each ... shortcut to launch your secure database and have that shortcut point to the ... appropriate workgroup information file. ...
    (microsoft.public.access.security)
  • Re: [opensuse] Ontological Relevance
    ... There is no new addressbook database. ... Microsoft moved from individual config files to the "Registry". ... documentation and external documentation is often difficult to find or ... The comparison is ambiguous because we're talking about data here, not configuration and invalid because KDE PIM data is still stored in the standard text based format, not in a binary database. ...
    (SuSE)
  • Access Icon shortcut for the security for Time keeping program
    ... This is the path for the Shortcut for the timekeeping Access Database Program ... but now we are converting the network to be using a ...
    (microsoft.public.access.security)
  • Re: Ideal Web Development Environment?
    ... only developer in a 1 server department with no budget, few resources, ... sandboxed area of the dev box. ... php, database, third party tools, onto your own computer (which could ... Config Files: There have to be many types of config files. ...
    (comp.lang.php)