Link to home
Start Free TrialLog in
Avatar of Ralph Gould
Ralph GouldFlag for United States of America

asked on

Access app runs in XP, not in win7 pro

Access 2k10 app opens a linked .dbf table and extracts some data with a query. This works fine when run on an XP system. Exact same app run on a win7 pro system and it doesn't work. it doesn't extract the data. It almost seems like the app continues running before the I/O operation is finished. Not sure how to trouble shoot this.

this is a split database residing on a win2k8 server, on a LAN. The app is stored on a usb hard drive on the server.
SOLUTION
Avatar of jlipschitz
jlipschitz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ralph Gould

ASKER

a handled error that says no table found and then quits. Table is there and populated
Are you sure the path to the table is the same from both PC's?
positive! if I step around this piece of code, the vba runs to successful completion utilizing other .dbf's in the same folder. The app is stored on the server and the front-end is the same for XP & Win7
Perhaps the dbf is corrupted.  Do you have a way to repair it?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
desktops and server are 64 bit

mapped drives
I'm going to assume it is the 32K Access on both the XP and the Win 7.

Have you tried turning off the firewall on the Win7 machine?

But if that fails, because it's the first DBF you are accessing, it might be a timing issue. I've run into that as well. So one to try is this. Put this code at the top of a VBA module:
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Open in new window

Then do a command like
Dim Dummy as String
Dummy = Dir("F:\Share\MyDBFName")
Sleep 1000'
'Your import commands.

Open in new window

Basically what that will do is get the authentication going between the workstation and the server/file location. Then do the read.

I know it's a bad workaround, but if it's stupid and it works, it isn't stupid. ;-)
Tks. won't have access until Mon/Tues. will try then
set the timer to 7000 with no change.
disabled firewall with timer in place - no change

it appears to be waiting to open a file that is there.

I can run the same app from an XP system or another win 7 pro system and all is well.
HELP!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Folks. Have tried all ur suggestions to no avail. Will close out now and keep working the issue.