Re: Opening an AccessXP db Question

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

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)
  • 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: Opening an AccessXP db Question
    ... The network isn't trusted. ... (Could be a database design issue or a PC config issue.) ... The shortcut only has the path to the database file instead of the ...
    (comp.databases.ms-access)
  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)