[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