?
Solved

Access app runs in XP, not in win7 pro

Posted on 2014-01-07
13
Medium Priority
?
489 Views
Last Modified: 2014-01-30
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.
0
Comment
Question by:jsgould
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 3
  • +1
13 Comments
 
LVL 1

Assisted Solution

by:jlipschitz
jlipschitz earned 375 total points
ID: 39762663
Windows 7 has User Access control.  Have you tried running the Application as an Administrator?  

You can also edit the properties of the shortcut to the application and set it to run in XP Compatibility mode to see that that helps as well.

I would try to run it as an Administrator by holding shift, right clicking on the application and select Run as Administrator.
0
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 375 total points
ID: 39762877
Do you get any error messages?

Also check to see if the correct drivers have been loaded.  Not all drivers are loaded by default when Access is installed.
0
 

Author Comment

by:jsgould
ID: 39762956
a handled error that says no table found and then quits. Table is there and populated
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 38

Expert Comment

by:PatHartman
ID: 39762998
Are you sure the path to the table is the same from both PC's?
0
 

Author Comment

by:jsgould
ID: 39763027
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
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 39763112
Perhaps the dbf is corrupted.  Do you have a way to repair it?
0
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 750 total points
ID: 39763889
Is the Win7 machine 64 bit?

And are you connecting via an ODBC call or is it going to a share?

And are you using mapped drives (F:\ShareName) or a UNC (\\ServerName\ShareName)?
0
 

Author Comment

by:jsgould
ID: 39763914
desktops and server are 64 bit

mapped drives
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39763938
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. ;-)
0
 

Author Comment

by:jsgould
ID: 39773733
Tks. won't have access until Mon/Tues. will try then
0
 

Author Comment

by:jsgould
ID: 39784024
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!
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 750 total points
ID: 39784329
So it is isolated to a machine issue.

At this point then maybe it is time grab some sort of network analysis tool and see if there are dropped packets, etc.

Another one to try is copying the Acc DB to the faulting client, do a compact and repair on that machine and see if you have still have an issue. You are always better off running the mdb/accdb from the local machine instead of across the network. Especially if you have a mixed XP/7 environment.

Anecdotal: I was building an AccDB on my Win7 64 bit machine, and then giving it to users for use on Win2k3 servers. I constantly had to go back and just do a debug on the DB and then it would start working on the servers. I finally just started doing the changes on a 2k3 server and haven't had problems since.
0
 

Author Closing Comment

by:jsgould
ID: 39822121
Thanks Folks. Have tried all ur suggestions to no avail. Will close out now and keep working the issue.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question