Reply
 
Thread Tools Display Modes
  #1   Report Post  
 
Posts: n/a
Default How to prompt for ODBC Connection in mail merge using MS query

Hello,

I have a MS Word mail merge document that runs OBDC using MS Query.

The problem is I do not want to have it automatically connect to the
datasource when the
word document is open.

I would like it to prompt for the odbc login ID and password before
running the connection.

Is this possible?

Thanks
Tom Horton

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ronald Nissley
 
Posts: n/a
Default How to prompt for ODBC Connection in mail merge using MS query

On 7 Nov 2005 08:19:32 -0800
wrote:

Hello,

I have a MS Word mail merge document that runs OBDC using MS Query.

The problem is I do not want to have it automatically connect to the
datasource when the
word document is open.

I would like it to prompt for the odbc login ID and password before
running the connection.

Is this possible?

Thanks
Tom Horton


Tom,

I don't know about an OBDC login ID/Password, but if you set a database
password (I'm assuming you're using Access), you will be prompted to
supply the password when opening a mail merge document that uses OBDC
to connect to the database.
To set the database password, you will need to open the database in
'Exclusive' mode. Open Access and trigger the Open dialog (File -
Open). Navigate to the database you wish to password protect and select
it. On the Open button (to the far right), you should see a small,
down-pointing arrow. Press the arrow and choose Open Exclusive. When
the database is open, go the Tools - Security menu to set the database
password. There is an option to 'allow saving password' when you are
prompted for the password--leave that unchecked if you wish to be
prompted for a password each time you open the merge document.
This worked for me in Office 2003 Professional. I didn't test
it in other versions.

Hope that helps!

--
Ronald Nissley
A+, MCP
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default How to prompt for ODBC Connection in mail merge using MS query


Ronald Nissley wrote:
On 7 Nov 2005 08:19:32 -0800
wrote:

Hello,

I have a MS Word mail merge document that runs OBDC using MS Query.

The problem is I do not want to have it automatically connect to the
datasource when the
word document is open.

I would like it to prompt for the odbc login ID and password before
running the connection.

Is this possible?

Thanks
Tom Horton


Tom,

I don't know about an OBDC login ID/Password, but if you set a database
password (I'm assuming you're using Access), you will be prompted to
supply the password when opening a mail merge document that uses OBDC
to connect to the database.
To set the database password, you will need to open the database in
'Exclusive' mode. Open Access and trigger the Open dialog (File -
Open). Navigate to the database you wish to password protect and select
it. On the Open button (to the far right), you should see a small,
down-pointing arrow. Press the arrow and choose Open Exclusive. When
the database is open, go the Tools - Security menu to set the database
password. There is an option to 'allow saving password' when you are
prompted for the password--leave that unchecked if you wish to be
prompted for a password each time you open the merge document.
This worked for me in Office 2003 Professional. I didn't test
it in other versions.

Hope that helps!

--
Ronald Nissley
A+, MCP




Hello,

Thanks for the input, but what I am trying to do is this.

I want to create a mailmerge document in MS Word, easy enough...so I
thought.

I want the document to query ORACLE database and obtain a fresh set of
data when
the document is opened. This was easily accomplished using the mail
merge and MS query
while in MS Word.

The only problem now is that when the user' password for the ORACLE
database expires (the password was used in the merge to get the data
via MS query) the document is total useless, you cannot reset the
password for a user.

Is there anyway to create a mailmerge that connects to an ORACLE
database, returns data to the mailmege and that will prompt you for the
ODBC login and password when you open the word document?

Our problem is that our users password expire every 3 months, and its
seems there is no way to have Word mailmerge document prompt you for a
login / PW to the database.

Thanks
Tom

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default How to prompt for ODBC Connection in mail merge using MS query

Hello,

Thanks for you input.

But my problem is this: I have a mailmerge in MS word then MS Query
that connects to an Oracle database.And it works fine and brings back
data to MS word and populates labels.

However, you have to use a userid an password in the mailmerge to
connect to the Oracle database. But in 3 months the users password for
Oracle will expire (have to be renewed) and
the document is totally useless.

Is there anyway to have MS word prompt for the ODBC or Oracle login and
password?

Thanks
Tom

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query a mail merge for multiple letters at once? Brese Mailmerge 1 May 20th 05 02:10 PM
Mail Merge Access to Word using a Query Winston Mailmerge 3 May 4th 05 09:17 PM
how do I set up a query for my mail merge Laura Mailmerge 1 March 22nd 05 09:31 PM
Mail Merge from Access Query KelMon Mailmerge 1 March 1st 05 01:52 AM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM


All times are GMT +1. The time now is 11:16 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"