[AccessD] Naturally....

Aaaah, In the cool clear light of the morning I have finally got this
working elegantly and as expected (including BE Password protection
integrity).

'-------------------------------------
            strConnect = "MS Access" _
                & ";PWD=" & pcstrPW & "" _
                & ";DATABASE=" & pcstrDataSource
        
            With CurrentDb
                Set tdf = .CreateTableDef(rsSP("tblName"))
                tdf.Connect = strConnect
                tdf.SourceTableName = rsSP("sqlName")
                .TableDefs.Append tdf
            End With
-----------------------------------------

Much nicer.  Thanks everyone for the feedback.

Cheers
Darryl.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, 19 August 2009 10:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Naturally....

Yep, if is password protected, the password is part of the connection
string and needs to be at the start of pcstrDataSource.


On 19 Aug 2009 at 21:00, Darryl Collins wrote:

> 
> 
> hehehe, after this week running a kinky boot shop for young ladies
sounds rather appealing.  I have to admit I am still looking at options
on this (relinking tables, not kinky boots.. although now you mention
it)....
> 
> One stupid issue I have bumped into is the code below doesn't work if
the BE database is password protected... Duh! what genius came up with
that??? Some days I really don't like MS Access at all!! :-/  Heresay on
the Access List I am sure,
> 
> "shoe size ladies?"...
> 
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
> Sent: Wednesday, 19 August 2009 8:28 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Naturally....
> 
> 
> That has got to be the most hilarious syntax I have ever seen. But if
it
> works, then go for it. But it's a great excuse to give up computing
and
> instead buy a ladies shoe store LOL.
> 
> On Wed, Aug 19, 2009 at 12:37 AM, Collins, Darryl
<Darryl.Collins at anz.com>wrote:
> 
> > Hah! As usual, after several days of struggling with this, I figure
out
> > the solution about 2.4 minutes after I emailed the list.  Thanks for
the
> > inspiration - that is what I say :)
> >
> > The magic syntax is
> > DoCmd.TransferDatabase acLink, "Microsoft Access", pcstrDataSource,
> > acTable, rsSP("sqlName"), rsSP("tblName"), False, True
> >
> > Where "pcstrDataSource" is the path and file name.
> >
> > Cheers
> > Darry.
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> ______________________________________________________________________
> This email and any attachments may contain privileged and confidential
> information and are intended for the named addressee only. If you have
> received this e-mail in error, please notify the sender and delete
> this e-mail immediately. Any confidentiality, privilege or copyright
> is not waived or lost because this e-mail has been sent to you in
> error. It is your responsibility to check this e-mail and any
> attachments for viruses.  No warranty is made that this material is
> free from computer virus or any other defect or error.  Any
> loss/damage incurred by using this material is not the sender's
> responsibility.  The sender's entire liability will be limited to
> resupplying the material.
> ______________________________________________________________________
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."