Problem Opening Approach Files
Posted on 2006-06-20
I'm having a problem opening Approach .apr files on our office network. The largest file is actually the front end/data entry for 7 databases joined to make up our main company database. I can quickly open this .apr file on any of the other 10 computers in our office, except for one problem workstation. When I try to open most .apr files on the problem computer, it starts to load the file but it never gets to the password login box. I either just get the hourglass on the screen until Approach finally stops responding, or after 5-7 minutes it may open the file.
This problem computer has been opening these Approach files for several years just fine, but has been getting progressively slower at opening these files for about the last month or so. If/when this problem computer manages to get one of the apr files open, then everything runs and works fine in Approach. On the other machines in our office (even old Windows 98 machines) it will open the largest .apr files we have in about 10-15 seconds.
I imagine it's something specific to this one computer but I can't figure out what. Maybe someone else has run into this problem before. The problem machine is a 733 pentium with a gig of ram, running XP Pro, with 14g of hard drive space, our network is TCP/IP. This computer is fast at opening large files (on our network) in other programs and is fast on the internet & downloading. The database is on our server (Windows Server 2003).
Uninstalled Approach v 9.5, rebooted and installed v 9.7
Compressed all of the .dbf files
Run checkdisk, spyware & antivirus scans - all clean
Defragged the drive
Deleted all of the .tmp files
Changed network card settings with no effect (full duplex vs half duplex vs Auto)