Replies

Creating a new folder makes no difference.

But it’s starting to look like your original idea of conflict with Anti-Virus may be the culprit. When using FireFox, a “download” window is displayed during the download process. This is followed by a progress bar that states “… scanning for virus…” The file is deleted immediately upon this progress bar being dismissed. I have double-checked that AVG 8.0 Anti-virus is disabled — there is a checkbox in the AVG 8.0 user interface to turn off its Resident Shield. When I turn off Resident Shield and reboot the computer, Windows Security Centre reports that both Anti-Virus and Spyware are disabled.

Regardless of the Resident Shield setting, FireFox continues to display its “… scanning for virus…” progress bar, and *something* deletes the file when the progress bar reaches completion. Makes me think that either FireFox is mis-reporting what is currently happening or that AVG is not completely disabled.

I have not tried uninstalling AVG anti-virus.

Tried disabling AVG Free 8.0 anti-virus (… cannot disable the AVG anti-spyware component). Tried running the browsers as Administrator. Same result every time — file appears for a few seconds in the target folder, then is deleted spontaneously. Very weird. At least the “downloader” component of my primary browser continues to work separately from the bare-bones download, so I am not stuck, but I sure wish I knew what changed to cause this annoying behaviour.

Thanks all for your suggestions.

A clue… when I download to the desktop, the file is visible for a few seconds. But when the “file transfer” dialog box diappears, then the file is deleted automatically. Tried the same concept into an arbitrary blank folder: the file was visible for as long as the “file transfer” dialog box was visible, but was deleted as soon as the file transfer dialog box was closed. The “close this dialog when transfer is completed” checkbox is CLEARED, but the dialog closes automatically anyway. Have toggled it to both states, always with the same results (dialog closes automatically).

Tried disabling the Windows Firewall, but no difference. Have cleared all the entries from the FireFox download dialog.

I will be away from web access for a week, so will not be able to respond to any suggestions until I return. Any help still appreciated!

My *guess* is that you will need to decide for yourself which of the contact list is the master, and do all your editing in that location. Otherwise, consider the case where you edit the same record in both locations — how will the system know which one is correct? If you want to know how complicated *that* gets, look into Access replication… As Hans suggested, you should do all your editing in Outlook.

Since Outlook provides a programming interface, you could probably write a customized solution that allows edits in both locations, but you would be faced with manually managing the conflicts between edits done in two locations. Not a trivial undertaking.

My

Slight addition to the custom function: Application.Volatile makes it recalculate whenever the filter is changed. Otherwise you must select the cell containing the formula, move the cursor to the formula bar, and press Enter.

Excellent as usual, Hans. Thanks very much.

(Edited by HansV to make URL clickable – see Help 19)

Found a method:
http://groups.google.com/group/microsoft.p…a68ea933e442655%5B/url%5D

Found the answer…
The frontend is A2000 format, running under A2003 on my computers. When used on a Vista machine, it exhibits the problem with sluggish performance. It works fine when used on XP. It also works fine when the frontend is converted to A2003 format.

I converted the old application from A97 to A2000 because I thought it would be the best common format for all the machines used at the clients worksite. Time to re-evaluate that decision! My understanding is that the preferred format for backend is A2000 regardless of the frontend format

(Aside: I enabled the menus and saw the sluggish performance. Then disabled the menu in code and closed the frontend manually WITHOUT using code to remove the menu. Re-opened the frontend (with the menu-code disabled). Performance was now at proper level — not sluggish. It appears to be the *creation* of the menu, not the *presence* of the menu that is causing the sluggish performance.)

Good idea. I will add the code to another Access project and see what happens. Will let you know the outcome.

Thanks, Hans. That fixed it. I’ve never used that setting myself, so the divide-by-1000 behaviour was a complete surprise to me.

I guess the Windows Regional settings was a red herring – he now admits to changing that Excel setting himself. Dunno why he did not check its effect immediately, and turn it off when it gave the undesired results.

Thanks also to Kaplinb – I appreciate your input.

FYI

I got impatient, and killed the Excel process after about 10 minutes. Re-jigged the VBA statement to delete 10000 rows, which took about 3-4 minutes, so deleting the 50000+ rows would probably take about 15-20 minutes. Anyway, I can now work with the spreadsheet again.

Setting recalc to “manual” made no difference.

I have launched the VBA solution (Range(“A10001:A65536”).EntireRow.Delete) and my CPU has been pegged at 100% utilization for the past 5 minutes according to Windows Task Manager. No indication how long it will remain pegged at 100%. While it’s deleting those rows, Excel is completely unresponsive to other inputs.

It sure is a lot easier to inadvertently *create* those rows than it is to delete them!

Thanks once again for your help.

I have a similar situation where I send periodic updates to a client. Also using .MDB and full version of Access. She manually opens the specific reports and changes the printer settings to the required printer. Then she distributes the modified frontend to other users on her LAN; they get the advantage of her tweaking the report. Although we don’t use .MDE and runtime, I suppose it is possible in this situation she could have MDB/full Access and other users on the LAN could have MDE/runtime. Perhaps this setup would work for you?

PS – I was planning to post a message inquiring whether anybody has a more elegant solution. Hans has already responded “no” which I will take as a definitive answer!

Despite the official documentation, replication is intended for Jet objects only – tables and queries. It is not intended for forms, reports, etc. So part of your solution will be to split your application into frontend and backend components. Use replication to sync the data (backend) between multiple locations, and use an alternative method to distribute the frontend to your remote locations. Here’s a good resource to study:

http://www.dfenton.com/DFA/Replication/ind…title=Main_Page%5B/url%5D

Drat! I am just in the process of upgrading a major app from A97 to A2003. When I saw this post I thought it was going to provide a really cool additional benefit of the upgrade. Now you burst that balloon. Oh well — easy come, easy go.