Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2004

Tip: Looking for answers? Try searching our database.

Merge to secure Access Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Debbie - 20 Jan 2004 23:34 GMT
I have a form letter which uses information from a secure
access database as its source. When I open the form file,
I am prompted for the database log-in, which is fine,
however, I have to log in twice before the file opens. If
I make changes to the selection criteria, I again have to
log in (3rd time) and when performing the merge, I again
have to log-in (4th time). And again, when I go to close
the form file, I have to log in for the 5th time before
the document will close.  I end up with the access
database open 5 separate times, which is excessive to say
the least.  Any ideas on how to prevent multiple log-ins
would be appreciated.

Thanks
Cindy M  -WordMVP- - 21 Jan 2004 20:17 GMT
Hi Debbie,

Which version of Office are we dealing with?

This sounds like it might be 97 or 2000? And a DDE
connection to the Access UI... Have you (or someone else)
set a custom caption for the Access window's title bar?

The problem with DDE is that it looks for a very specific
caption among loaded applications, and if it can't find it,
the application will be started up again (and again, and
again...) Sometimes, removing that custom caption will get
rid of the problem you describe.

> I have a form letter which uses information from a secure
> access database as its source. When I open the form file,
[quoted text clipped - 8 lines]
> the least.  Any ideas on how to prevent multiple log-ins
> would be appreciated.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.