XP SP2 problem

C

Chris

am involved in the development of a delphi application
created with links to an access database.

The program has been working well works well with on
computers using Win 2000 with Access 2000 and on machines
using Win XP (SP1) with Access 2003.

I have recently upgraded to Win XP to SP2 and now the
program does not run. The following error message appears.

"Windows cannot access the specific device, path or file.

You may not have appropriate permissions to access this
item"

I have tried editing various permissions in Access
without result, can you advise please.

Thank you

Chris Tuckwell
 
6

'69 Camaro

Hi, Chris.
"Windows cannot access the specific device, path or file.

You may not have appropriate permissions to access this
item"
Click to expand...

Unless your database name is called "Windows," this is an error generated
from the operating system, not Access. If it were from Access, the message
would be something like: "DatabaseName cannot open ObjectName. Please see
your administrator or the owner of the object to grant you permissions for
this object."

You'll need to check the mapped drive, directory path and file that your
Access application is trying to open to ensure that your Windows user
account still has appropriate security permissions assigned for access to
the file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
J

J. Clay

XP SP2 and BDE do not work nicely when Access is involved.

I have a large access app (.adp) on SQL 2000 that is highly integrated
w/Goldmine on SQL. Goldmine uses the BDE for data access. My integration
includes making calls to Goldmine's API, which requires that the BDE be
loaded in the app. On my test machine w/SP2 installed, I cannot get the BDE
to load up if there is another app (Goldmine) using the BDE. In otherwords,
the BDE is locking down into single app mode and I haven't been able to
figure out how to get it to work. At this point, we are not installing SP2
on any of our XP machines.

Jim
 
S

Steve_K

I'm having the same issue with a database that contains
links to dBase tables (GoldMine). This problem occured
immediately after installing XP SP2.

I've searched the KB for a solution, and didn't find any.
Surely they would have caught this before releasing SP2?

Any help (Microsoft), would be appreciated.
 
J

J. Clay

Steve - If you are using the GM API for this (thus loading BDE in Access)
this is a known issue w/SP2. There is a way around it if you are
programming in VB, but not in Access. I have not had time to work on the
issue any more, but have one thing I am going to try. I would suggest
viewing the Goldmine news groups for more info. (gmNews.goldmine.com)

Jim
 
S

Steve_K

I'm thinking it's a problem with having BDE installed on
the machine. Another workstation with SP2 has no problems
running Access, but it does have BDE (or GoldMine)
installed. On this workstation Access won't run at all,
with any database (or even a new blank db). It just
immediately throws the "Windows can't access ..." error.
 
S

Steve_K

Sorry, typo. Should read:

"...but it does NOT have BDE..."
-----Original Message-----
I'm thinking it's a problem with having BDE installed on
the machine. Another workstation with SP2 has no problems
running Access, but it does have BDE (or GoldMine)
installed. On this workstation Access won't run at all,
with any database (or even a new blank db). It just
immediately throws the "Windows can't access ..." error.
-----Original Message-----
Steve - If you are using the GM API for this (thus loading BDE in Access)
this is a known issue w/SP2. There is a way around it if you are
programming in VB, but not in Access. I have not had time to work on the
issue any more, but have one thing I am going to try.
Click to expand...
I
would suggest
Click to expand...
 
J

J. Clay

I do have my tablet that runs it all up on SP2. The only problem is that
any integration w/Goldmine does NOT work. So, my recommendation (and that
of some of the bigger names in the GM community) is to not install SP2 if
you are running anything but a completely vanilla Goldmine install with no
integration.

As an FYI - Goldmine is supposedly (Rumor mill) coming out with version 7
some time after the first of the year and it will NOT use BDE for data
access. Wouldn't that be a treat.

Jim

Steve_K said:
Sorry, typo. Should read:

"...but it does NOT have BDE..."
Click to expand...
 
Top