[AccessD] Naturally....

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.
______________________________________________________________________