Replies

I ran across references to RDC 6.0, but it appears that the remote system has to be running Vista for the new features (for example, dual monitors) to work.

With the help of our network support folks, I removed the old printer driver, reinstalled the network printer (e.g., SERVERPRINTERNAME), but this time called it a “local printer” in the Add Printer Wizard, created a new port, a local port, and named the local port the printer name (SERVERPRINTERNAME), browsed to the printer .INF file (our network folks supplied this, but it’s usually available from the printer vendor, too), specified that the old driver should be replaced, and proceeded through the rest of the usual New Printer routine.

This solved the problem.

I’ll be curious to see if Bill Kessinger’s suggestion regarding deleting the security policy file will also solve this problem (I wonder whether this alternative has any undesirable side effects).

Thanks.

Yes, I’m using soEditor Pro (version 2.1) which is imbedded in the web page generator software. It does permit viewing and editing of “raw” HTML code, but some things (such as #include) seem to be ignored ( does work).

As I mentioned in the reply to Jerry, I don’t think I have at my disposal with the web design tool I’m using. I’ll try your “click” code to see if that works (of course, my preference would be to have the external html inserted automatically). does seem to work for me, although I have to futz with the parameters (fortunately the html I’m inserting does not change dimensions much so this works okay once it’s set up).

Thanks,

Jerry,

Thanks for the ideas… The web-design/maintenance tool I’m using does not appear to support nor #include. Otherwise (if I were designing from scratch), these certainly appear to be exactly what I was looking for.

Thanks again.

What a treat! I’ll look forward to your trying your “little application.” Thanks so much.

I’ve tried the approach and it seems to serve the purpose, but I’d like to try your alternative (the WIDTH and HEIGHT requirements of IFRAME seem to constrain me a little, but the scroll bars may come in handy if I continue to do this in other places).

Thanks again.

Thanks, I’ll look into using the or tag to see if one of these works for me.

Jerry,

Basically, yes. I’d like to leave the html content of index.htm unchanged. However, when I change xxx.htm, I’d like the appearance of index.htm to change to reflect the new content of xxx.htm.

Thanks for you help on this.

Mark,

I have four subforms defined.

I’ve delved into this a bit deeper by time-stamping various points in the code that executes during the Open, Load, and Current events when this form is opened. I found a real time hog in one routine where I was determining the status of each record based on various date fields that had values or didn’t have values, counting subordinate records in a linked table, etc. The way I was doing this (shame on me!) was with a user defined function in an update query. That function actually opened a recordset, then found the record, then determined the status (it was a little more complicated than this, but this is the gist of it). So, (gasp) the update query was opening and closing the back-end table once (at least) for every record it was creating. Since I didn’t see much of a performance issue when the back-end was local, it didn’t occur to me to see how efficient (or inefficient!) this code was. Now I’ve revamped the code so that the back-end table only has to be opened once. When the back-end is local, this process (the old way) took about 15 seconds (slower than I would have guessed); when on the network it took about 60 seconds. With the revamped code, it’s about 0.5 seconds on the network!

The whole form opening process still takes 5-10 seconds which, for the time being, is acceptable for me, but it would probably behoove me to scour the system for other similar inefficiencies. I may also try unbinding the record sources for the form and its subforms per your guidance to see how much better it gets.

Thanks.

Mark,

Yes, the front end is still local. I may try putting in some time stamps into the Form_Open and Form_Load events at various stages to try and localize where the delay is coming from (or to see if it’s all before the events even start processing).

Also, for this database, I don’t yet have any global relationships defined (the “Relationships” window is blank). Would adding these likely buy me anything in this regard?

Thanks.

I’ll try that, Hans. Thanks (again!)

Thanks for your suggestions (and pointing me to others’), Hans.

Indeed, the virus scanner was set to scan network drives. I turned this off for the backend file. The autocorrect was on for both the front- and back-end. I turned these off. And subdatasheet view was set to [Auto] for all tables (linked and unlinked) in the front-end and all the tables in the back-end. I changed these all to [None]. I do have a persistent form (startup “spash” form that set to not visible after a few seconds) that I had been using to log the session start and stop time (I capture the stop time in the form’s unload event). However, this form was not bound to any back-end table. I have now innocuously bound it to one of those tables (via the OWOP query). Needless to say, I expected a dramatic improvement (all the suspects were guilty!). Well, it is improved, I think, but still slower than it seems it ought to be — about 30 seconds to load the form mentioned in my original post.

Sigh.

Thanks, Hans. Sneaky, not terribly elegant, but it’ll do the trick. And I guess if I want to keep the table heading centered (the title in the same place on every page, with the “(cont.)” off to the side), I could either put the “(cont.)” on a second line in the same cell or I could put a “(cont.)” in front of the title as well as after it and have the one in front colored white…

Thanks for the tip — I’ll give it a try.

Thanks for the response, Andrew.

I’m trying to avoid having to change anything on the users’ computers. If I understand your response, your suggestion would require changing everybody’s NORMAL.DOT file, right?

Thanks,