Re: Accessing .mdb files from network share on TS

Tech-Archive recommends: Fix windows errors by optimizing your registry

yes, when I copy it to the local drive it opens fine

"Anthony" wrote:

Just trying to narrow it down a bit.
Does it open correctly with double-click if you copy it locally?
(http://support.microsoft.com/kb/303650)

--
Anthony
http://www.airdesk.co.uk


"HWhite" wrote:

I'll answer all of your questions with the understanding that this has been
working in our environment for years and the only thing that has changed was
the replacement of a W2K TS to a W2K3 TS.

Yes, the mdb was created in Access 2000 and is being accessed using a newer
version (2002) on the TS.

Any given machine only has one version of Access installed on it. Access
2000. Access 2000 runtime is also installed on every workstation and the old
TS for a specific program we use. I need to install it on the new TS. But
otherwise, each workstation has only one full version of Access installed.

Yes, it works if you create the shortcut using the access path followed by
the database path. I'm using that as a workaround right now. It will work
for this db, but we have dozens of databases and they are going to want to
open the databases directly from their location. So, this isn't a very
efficient workaround in the long run.

It works fine on every workstation except the TS. And it WAS working on the
TS immediately after I made the IE7 security setting changes, but that seems
to have stopped working for some reason.

Thanks for your help.

"Anthony" wrote:

Access double-clicking and shortcuts can behave unusually. Do you have more
than one version of Access in use (on the server or on the desktop)? Was the
mdb created in one version and being opened in another? Does it always works
if you run [path]access.exe [path].mdb? Does it work OK from a desktop but
not from the TS? Does it work OK at the server console but not through TS?
Anthony
http://www.airdesk.co.uk






"HWhite" <HWhite@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47F46847-DE00-4A1F-8B57-9476F9C3AAA4@xxxxxxxxxxxxxxxx
I just installed a W2K3 Terminal Server, fully patched, and am having an
issue with accessing an Access database file on a network share (also W2K3
server). I was having restricted permissions error accessing a lot of
things
on that share, but I went into IE7 and added file://servername to the
trusted
sites list and then changed the security options to allow launching of
applications and unsafe files. That solved the problems for a couple of
days, but the Access issue came back and now nobody can launch the
database
by double-clicking on it or launching the shortcut that points to the db.
Opening Access first and then finding the file works fine. Only the
administrator account can open the database directly. Not even members of
the Domain Admins group can do it. Only the domain administrator.

Any ideas what I'm missing here?

Thanks for any guidance.



.

Relevant Pages

  • Re: Tracking Log In and Log Out times of Users
    ... The fact that the database is on the server should be irrelevant. ... Type mismatch and then highlights Set rst = ... On my startup form, (that opens every time the database is open, ... I then went to the load ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code causes error 2486 in access 2000, IPF in 2002
    ... Compact the database to get rid of this junk: ... Allen Browne - Microsoft MVP. ... Windows 98 machine. ... update queries and opens another form - ...
    (microsoft.public.access.formscoding)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)