Home All Groups Group Topic Archive Search About

Secure database and merging with Word files

Author
17 Jun 2009 9:15 PM
Nomy
Hi,
How do you merge a query from a user level secured Access 2003 database with
a Word merge file.

We have a database that has been secured with user level security and is
split into a front and back end.  Prior to securing the database, there were
a number of Word files that were merged with data from the unsecured
database.   The merge was performed by opening a query and selecting "Merge
it with Microsoft Word."

Now the merge won't work even after typing in the user name and password.
The user is a member of the Admins group.

Thanks in advance for help.
Joy

Author
18 Jun 2009 5:04 AM
Tom van Stiphout
On Wed, 17 Jun 2009 17:15:14 -0400, "Nomy" <noname@nonsense.invalid>
wrote:

The only way I can think of that could possibly yield good results is
to do the mailmerge more programmatically. Then when you specify a
datasource, use an ODBC connection string that can include the
username/password. See connectionstrings.com for details.

Or have the app export a CSV file that Word can pick up and work with.

-Tom.
Microsoft Access MVP


Show quoteHide quote
>Hi,
>How do you merge a query from a user level secured Access 2003 database with
>a Word merge file.
>
>We have a database that has been secured with user level security and is
>split into a front and back end.  Prior to securing the database, there were
>a number of Word files that were merged with data from the unsecured
>database.   The merge was performed by opening a query and selecting "Merge
>it with Microsoft Word."
>
>Now the merge won't work even after typing in the user name and password.
>The user is a member of the Admins group.
>
>Thanks in advance for help.
>Joy
>
>
>
>
Author
18 Jun 2009 2:16 PM
Nomy
Tom,
Thank you for the reply.  I'll check the site you suggested.


Show quoteHide quote
"Tom van Stiphout" <tom7744.no.spam@cox.net> wrote in message
news:liij355inum4h4rfjneg0kqfdakh1jtc70@4ax.com...
> On Wed, 17 Jun 2009 17:15:14 -0400, "Nomy" <noname@nonsense.invalid>
> wrote:
>
> The only way I can think of that could possibly yield good results is
> to do the mailmerge more programmatically. Then when you specify a
> datasource, use an ODBC connection string that can include the
> username/password. See connectionstrings.com for details.
>
> Or have the app export a CSV file that Word can pick up and work with.
>
> -Tom.
> Microsoft Access MVP
>
>
>>Hi,
>>How do you merge a query from a user level secured Access 2003 database
>>with
>>a Word merge file.
>>
>>We have a database that has been secured with user level security and is
>>split into a front and back end.  Prior to securing the database, there
>>were
>>a number of Word files that were merged with data from the unsecured
>>database.   The merge was performed by opening a query and selecting
>>"Merge
>>it with Microsoft Word."
>>
>>Now the merge won't work even after typing in the user name and password.
>>The user is a member of the Admins group.
>>
>>Thanks in advance for help.
>>Joy
>>
>>
>>
>>
Author
19 Jun 2009 10:11 AM
Albert D. Kallal
"Nomy" <noname@nonsense.invalid> wrote in message
news:Outqp9B8JHA.1196@TK2MSFTNGP03.phx.gbl...
> Tom,
> Thank you for the reply.  I'll check the site you suggested.
>

I have a working sample word merge that works with secured database....

You can find it here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
Author
19 Jun 2009 7:30 PM
Nomy
THANK YOU, THANK YOU, THANK YOU!

This worked absolutely great.   Thank you so much.


Show quoteHide quote
"Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
news:epRKOZM8JHA.2120@TK2MSFTNGP02.phx.gbl...
> "Nomy" <noname@nonsense.invalid> wrote in message
> news:Outqp9B8JHA.1196@TK2MSFTNGP03.phx.gbl...
>> Tom,
>> Thank you for the reply.  I'll check the site you suggested.
>>
>
> I have a working sample word merge that works with secured database....
>
> You can find it here:
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
>
>
> --
> Albert D. Kallal    (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@msn.com
>
Author
10 Jul 2009 7:57 AM
replica handbags
We retail and wholesale AAAAA+grade replica handbags in China. We can ship
the parcel to any address in the world via EMS,DHL,UPS,TNT.We accept
WesternUnion,T/T(Bank transfer), Moneygram,Visa or MasterCard payment. We
provide Louis Vuitton, Gucci, Fedi, Chanel, Chole, Hermes, Coach, Prada,
Miumiu, Balenciaga, Jimmychoo, and Dior replica handbags of AAAAA
quality.Also we can offer OEM and ODM service for high quality handbags.If
you have need,Please contact us.

Louis Vultton AAAAA+grade Replica Handbags
http://www.7handbag.com/Louis_Vultton_Handbags_1.html

Louis Vultton 2009 Collection handbags
http://www.7handbag.com/2009_Collection_86.html

Louis Vultton Mahina handbags http://www.7handbag.com/Mahina_3.html

Louis Vultton Monogram Canvas handbags
http://www.7handbag.com/Monogram_Canvas_2.html

Louis Vultton Monogram Jokes handbags 
http://www.7handbag.com/Monogram_Jokes_4.html

Louis Vultton Monogram Tisse handbags
http://www.7handbag.com/Monogram_Tisse_15.html

Louis Vultton Monogram Mirge handbags
http://www.7handbag.com/Monogram_Mirge_6.html

Louis Vultton Monogram Denim handbags
http://www.7handbag.com/Monogram_Denim_7.html

Louis Vultton Monogram Mini Lin handbags
http://www.7handbag.com/Monogram_Mini_Lin_8.html

Louis Vultton Monogram Leopard handbags
http://www.7handbag.com/Monogram_Leopard_9.html

Louis Vultton Monogram Rivets handbags 
http://www.7handbag.com/Monogram_Rivets_10.html

Louis Vultton Monogram Miroir handbags
http://www.7handbag.com/Monogram_Miroir_11.html

Louis Vultton Monogram Perfornis handbags
http://www.7handbag.com/Monogram_Perfornis_12.html

Louis Vultton Monogram Vernis handbags
http://www.7handbag.com/Monogram_Vernis_13.html

Louis Vultton Monogram Dentelle handbags
http://www.7handbag.com/Monogram_Dentelle_14.html

Louis Vultton White Murakami handbags
http://www.7handbag.com/White_Murakami_70.html

Louis Vultton Black Murakami handbags
http://www.7handbag.com/Black_Murakami_71.html

Louis Vultton Luggage handbags http://www.7handbag.com/Luggage_17.html

Louis Vultton Damier Canvas handbags
http://www.7handbag.com/Damier_Canvas_18.html

Louis Vultton Damier Geant handbags
http://www.7handbag.com/Damier_Geant_20.html

Louis Vultton Taiga Leather handbags
http://www.7handbag.com/Taiga_Leather_21.html

Louis Vultton Suhali Leather handbags
http://www.7handbag.com/Suhali_Leather_22.html

Louis Vultton Epi Leather handbags http://www.7handbag.com/Epi_Leather_23.html

Louis Vultton Utah Leather handbags
http://www.7handbag.com/Utah_Leather_24.html

Gucci Handbags AAAAA+grade replica handbags
http://www.7handbag.com/Gucci_Handbags_2.html

2009 new Gucci AAAAA+grade replica handbags
http://www.7handbag.com/2009_New_Gucci_Bags_84.html

Gucci AAAAA+grade replica bags
http://www.7handbag.com/Gucci_Replica_Bags_59.html

Gucci AAAAA+grade replica wallet
http://www.7handbag.com/Gucci_Replica_Wallet_75.html

Fendi AAAAA+grade replica Handbags
http://www.7handbag.com/Fendi_Handbags_3.html

Chanel AAAAA+grade Replica Handbags
http://www.7handbag.com/Chanel_Handbags_4.html

2009 new model Chanel AAAAA+grade replica handbags
http://www.7handbag.com/2009_New_Chanel_bags_87.html

Chanel AAAAA+grade replica handbags
http://www.7handbag.com/Chanel_Replica_Bags_58.html

Chanel AAAAA+grade replica Wallet
http://www.7handbag.com/Chanel_Replica_Wallets_74.html

Chloe AAAAA+grade Replica Handbags
http://www.7handbag.com/Chloe_Handbags_5.html

Hermes AAAAA+grade Replica Handbags
http://www.7handbag.com/Hermes_Handbags_6.html

2009 new model AAAAA+grade Replica handbags
http://www.7handbag.com/2009_New_Hermes_bags_83.html

Hermes Birkin AAAAA+grade Replica replica handbags
http://www.7handbag.com/Hermes_Birkin_Bags_65.html

Hermes AAAAA+grade Replica Wallet
http://www.7handbag.com/Hermes_Wallet_81.html

Coach AAAAA+grade Replica handbags
http://www.7handbag.com/Coach_handbags_7.html

2009 new model Coach AAAAA+grade Replica handbags
http://www.7handbag.com/2009_New_Coach_bags_82.html

Coach AAAAA+grade Replica handbags
http://www.7handbag.com/Coach_Replica_Bags_72.html

Coach AAAAA+grade Replica Wallet
http://www.7handbag.com/Coach_Replica_Wallets_73.html

Prada AAAAA+grade Replica Handbags
http://www.7handbag.com/Prada_Handbags_8.html

2009 new model AAAAA+grade Replica handbags
http://www.7handbag.com/2009_New_Prada_Bags_85.html

Prada AAAAA+grade Replica Replica handbags
http://www.7handbag.com/2008_Collection_bags_61.html

Prada AAAAA+grade replica bags
http://www.7handbag.com/Prada_Replica_Bags_62.html

Miumiu AAAAA+grade Replica Handbags
http://www.7handbag.com/Miumiu_Handbags_9.html

Balenciaga AAAAA+grade Replica Handbags
http://www.7handbag.com/Balenciaga_Handbags_10.html

JimmyChoo AAAAA+grade Replica Handbags
http://www.7handbag.com/JimmyChoo_Handbags_11.html

Christian Dior AAAAA+grade Replica Handbags
http://www.7handbag.com/Christian_Dior_Handbags_12.html

Marc Jacobs AAAAA+grade Replica Handbags 
http://www.7handbag.com/Marc_Jacobs_Handbags_15.html

Bottega Veneta AAAAA+grade Replica Handbags
http://www.7handbag.com/Bottega_Veneta_Handbags_16.html
Author
18 Jun 2009 5:57 AM
tiber2008 via AccessMonster.com
2009 new Chanel 6276 blue handbags.Replica handbags,wholesale bags,designer
purses,fake Wallets,faux tote,China Copy.

Materials: sheepskin
Main Color:blue
size: W41XH33XD12.5
Attachment:Dust Bag,Care Booklet,Authenticity Card.
Chanel 1:1 level,you can find the quality best in replica and nearest with
original edition.

links: http://www.7handbag.com/2009_new_Chanel_6276_blue__999.html