Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unable to Open Macro Storage on Export from Access to Word

Posted on 2003-11-27
13
Medium Priority
?
639 Views
Last Modified: 2012-06-21
Guys:

Before you say anything, I did see "that MS KB article" that everyone talks about when this question is posted, but it didn't help. I am running on Windows XP, with local admin rights, and the code works fine. A user then comes and log into my machine (losing local admin) and they get the Unable to open macro storage error, failing on:

Set WordDoc = WordApp.Documents.Open(FileName:="C:\FSBDB\q3-blank.doc")

Is there any way around this? The document is a word form (form fields) that I am dumping data into from the database table.. It works SO beautifully when I do it and it'd just kill me if I couldn't use it because of permissions.

Here's the complete code:
If WordApp Is Nothing Then
    Set WordApp = New Word.Application
Else
    Set WordApp = GetObject(, "Word.Application")
End If

If err.Number <> 0 Then
    err.Clear
End If

On Error GoTo 0

WordApp.Visible = False

Do While Not rs.EOF

Set WordDoc = WordApp.Documents.Open(FileName:="C:\FSBDB\q3-blank.doc")

    Bookmarks("txtTitle").Range.Fields(1).Result.Text = rs!Title
       
    .FormFields("lstDivision").Result = rs!Division
    .FormFields("lstCoreBusiness").Result = rs!CoreBusines
    .FormFields("lstProgram").Result = rs!SubItem
    .FormFields("lstThroneSpeech").Result = rs!ThroneSpeech
    .FormFields("lstBudget").Result = rs!Budget
    .FormFields("lstKeyStrategies").Result = rs!KeyStrategy

etc.....
0
Comment
Question by:Mitchell_
[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
  • 4
  • 4
  • 3
  • +1
13 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9833660
Hey Mitchell_!

  This sounds more like a Word error being passed thru to Access.

  See this link:  http://www.support.softwaretechnology.biz/main/R10650.htm about mid page regarding your dilemma.
  See also: http://dbforums.com/arch/219/2003/1/666622  this refers to the MSKB thing but there's more.

regards
Jack
0
 

Author Comment

by:Mitchell_
ID: 9833689
Thanks but..

I don't see how it could be a word error when the export works fine under my administrative account.. It's just when a 'regular user' tries it that it fails.. wouldn't that mean permissions?

any other thoughts?
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9833705
Access permissions don't mean anything to a Word Document.

There is some |other| difference in operations when your other user is logging on.
If you want to completely rule out a permissions issue, put that user in the Admins group (or your SuperGroup) and try the op again.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 23

Expert Comment

by:heer2351
ID: 9833715
I woud say that it could be a rights issue. Check where the temp directory points to when the user logs in and make sure the user can create files in this directory.
0
 
LVL 23

Expert Comment

by:heer2351
ID: 9833717
Jack Mitchell means Operatings System permissions, not access permissions.
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9833887
oh,...ok
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9836443
Which version of MS-Office.
(Office97 has specific permissions issueswhen run on Win2000 or later).

Pete
0
 

Author Comment

by:Mitchell_
ID: 9836929
it's office 97 - you know of something offhand with O97 and macros?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9837042
Office 97 macros do not run on Win2000 and later for non-privileged users without registry changes.
I'll try to find the KB article.

Pete
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9837057
0
 

Author Comment

by:Mitchell_
ID: 9837679
Pete:

Thank you for the article. That's definetly been confirmed as the problem.

Now, My problem is that I do not have admin access on any machine other than my own to apply this fix, and the IT folks definetly won't want to update 100+ machines to accomdate my little application.

Is there another way to get this data out to word via access into these form fields?

0
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 9837800
I can't say whether there is any other solution.  In a way you have to hope there isn't, because it is a security issue at heart.
I have come across this issue in several customer sites.  In every case it has been resolved through the recommended registry changes.  It is a pretty fundamental issue for Office 97 users and I can't see how any site can run Office97 with the constraints the problem imposes.

I know very little about Windows admin, but if you have that many users there must a good chance that the required changes can all be done from a central point.  Show someone the KB article.

Pete

0
 

Author Comment

by:Mitchell_
ID: 9837845
Pete:

Thank you. I'll do that.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

730 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