Re: Word mail merge data source

Yes, setting SQLSecurityCheck may do the trick, but I would also inspect
the permissions anyway.

Peter Jamieson

"Markus" <Markus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6724FAD5-DB74-4866-ABEE-830F6C8F2D35@xxxxxxxxxxxxxxxx
Peter,

Yes, I also thought that, but we have tried running it with max admin
privileges.

I know newer versions of word have a security check that can cause mail
merge files to produce a message when they open regarding the running of
an
sql command. Could be that affects a programmatic change as well (makes
sense) but does not return an interpretable errror. We'll try disengaging
this security check and see if that gets by the problem (or maybe someone
else has already tried this and will check in here).

Thanks,
Mark

"Peter Jamieson" wrote:

The chances are that it's a permissions issue, probably to do with the
permission to create a file on the network drive - e.g. if your database
is
a .mdb, Jet will try to create a .ldb file in the same folder as the .mdb
and will fail if you don't have the necessary permissions.

Peter Jamieson
"Markus" <Markus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B235C47-2C2D-4C1A-8678-152FAEDE8389@xxxxxxxxxxxxxxxx
I am trying to use VB using OLE to change the datasource in a Word mail
merge
file to a server drive from the C: drive. When I try to make this
change
to
another location on the C drive, there is no problem. When I try to
use
the
UNC path to the server drive, I get an OLE Exception error.

Anyone have a similar problem, or have any ideas on why Word will not
let
me
make this change to the datasource location? Any ideas on how to get
around
the problem?

Any and all ideas appreciated,
Mark





.

Relevant Pages

  • Re: Word mail merge data source
    ... "Peter Jamieson" wrote: ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • Re: Word mail merge data source
    ... It must be permissions since SQLSecurityCheck did not solve ... "Peter Jamieson" wrote: ... I know newer versions of word have a security check that can cause mail ... make this change to the datasource location? ...
    (microsoft.public.word.vba.general)
  • Re: Adding new users to an Access 2002 DB
    ... So the mdb opens when you are using the standard system.mdw. ... It sounds like someone didn't secure it properly, ... When you open it, go to Tools, Security, permissions and check to see what ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... I checked the permissions box and the Users group has no ... Open/Run and open exclusive on database object ... "Joan Wild" wrote: ... properly on the single mdb. ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)