Replies

Sounds like you’re stuck with having to ask the powers that be to pony up the cash for a Developer’s edition of Office. Act quickly before you can’t find a retail version for Office 2000!

Mark:

Head on up to the Knowledge Base search page, and look for KB article Q210372 – Imported Excel Carriage Returns become Square Boxes. This will give you a solution that you can implement as long as you’re generally familiar with coding and queries. If you have trouble, just post back! Good luck!

Kathy:

I’m glad you got a quick resolution; check this post from Charlotte with a link to a great sample db from Microsoft that addresses this issue and a host of other functionality that you might not know you need yet!

…and then you’re doing a nightly repair and compact on the db, right?

Roberta:

Glad you got everything working; someday soon I may ping you with Macromedia questions! For now, I prefer a good stout.

That KB article gives me the impression that once you install one of the umpteen versions of MDAC, you should be all set. Best of luck!

Are you displaying the information in a form or in a report?

Perdone mi espa

Roberta:

Happy to help if I can; goodness knows I’ve taken enough out of the Lounge!

If you open Windows Explorer and surf to the WINNT folder, right-click on it and choose Properties. Click on the Security tab and you’re almost home. On the Security tab is a list of users that currently have permissions of some sort set on the WINNT folder; when you click on one of the users, their permission level is shown below. It sounds like you need to give the local group named Everyone read and write permissions on the WINNT folder; as an aside, I’d check with your network admin if you have one to be sure he/she is hip with that level of access being granted on such an important directory.

See if that does the trick for you, and post back with your results. Good luck!

Roberta:

The folks in Redmond have this to say:

CAUSE
This is by design. The error occurs because the permissions in the Winnt folder are too restrictive.

RESOLUTION
Give the local Everyone group at least Add and Read permissions on the Winnt folder.

Note: If you are editing in a subweb and using the Global.asa file in the root Web, the author’s user account, as well as any anonymous account in use, must have at least browse access explicitly specified on the root Web.

MORE INFORMATION
The Jet Database Engine writes temporary files to the Winnt folder as the account accessing the Web. In the case of Authoring, the account is the logged on user, and in the case of browsing, it is the Iusr_machinename account.

Roberta:

I’ve only config’d IIS 5.0, so bear with me! You should have the engine that process active server page scripts if you have installed IIS 4; it is asp.dll and can usually be found in C:WINNTSystem32inetsrv.

Launch the Management Console and make sure you’ve enabled scripts to run in the virtual directory you’re putting your ASP files in. Remember that you have to address ASP pages via http for them to work; that is, if your virtual dir is named Develop and you have Test.asp, you must address it with http://ServerName/Develop/Test.asp ,but just opening it with a File -> Open in IE won’t do the trick.

Here’s hoping this gets you heading down the right path! Post back if you’re still having troubles.

You can link to an Excel worksheet and append into it via an append query in Access.

Hans:

The resulting code from that macro does look like it’ll get me started down the right path. Thanks for the post!

Yes and yes! That’s an excellent tip; thanks!

I’ve done a Paste Special -> As Values with the resulting sheets so the user doesn’t get the live pivot table out of synch with the name of the sheet. I think that I’m still going to poke at the VBA to see if I can come up with a function to do it without pivot tables, but your post surely saved me a punch of cutting and pasting in the meantime! Thanks again!

Thanks for the quick reply! My first pass at it was to make a pivot table with the build as the page, but they find the concept of choosing a build from a combo-box confusing . I’m not sure I understand the 2d bit about the splitting the info into seperate sheets using “show all pages”..