Hi Suzanne,
I was just looking at this again and realising that a .odc was probably now
required, so I was interested to see your message - id that what you needed
in the end, or did you find a way to make it work without an additional
file?
Peter Jamieson
"Suzanne" wrote in message
...
Ok so thanks to you my mailmerge is now successful, i'm now connecting
with
OLE DB and it's working good!!! Thank you very much for your help!!
"Peter Jamieson" wrote:
1. Which version(s) of Office/Word/Windows. (And are you setting this up
for yourself, a few users, or lots of users?)
2. Do you need or want specifically to connect with ODBC? OLE DB is the
default in Word 2002 and later and you may find ODBC connections
increasingly problematic with Word 2007 and/or Vista, especially Vista
64-bit? For ODBC you need DSNs, but for OLE DB you typically need .odc
files (or .udl files, maybe), although it is may be possible to do
without either.
3. Does your security database have a long pathname? If so, you are
likely to run into problems where Word truncates the connection string
containing logon information. You may be able to connect first time but
not subsequently. If you are encountering this problem, it may be better
to relocate/rename your security database so that it has the shortest
pathname you can manage.
4. When you re-opened your existing mail merge main documents I imagine
that they would fail to connect (not having the correct connection
info.) What happened next? If you were prompted to re-select your
database, were you then prompted for the connection method? If so, did
you see a logon screen? etc.
Peter Jamieson
http://tips.pjmsn.me.uk
Suzanne wrote:
Can anyone help.... I just recently set up user-level security on my ms
access database (.mdb). I have multiple mailmerges through word
connected to
my access database that will not open now because of the security. I
unsuccessfully tried to set up a new (MyDSN) User DSN using the ODBC
Administrator, when connecting to MyDSN everything goes well, i select
the
query i want and then when i finish i get the error message "word
cannot open
+connect to new datasource.odc as a data or header source because it
contains
no data". I don't understand what i'm doing wrong. Is there another
approach
to this problem? Any help would be greatly appreciated.