[AccessD] Call a function in an AccDb from outside it?

[Arthur Fuller]

Thanks, Jim.

I've never tried writing an Add-In. About time I did something about that.
It's the weekend, right? Not that that matters, when you're a retired
person.😀

On Fri, Oct 14, 2022 at 12:37 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>  Arthur,
>
>    Along the lines of what Susan is suggesting, what is this utility about
> exactly (sorry if I've missed it)?
>
>    Most utilities are written as an Access Add-in, at which point you have
> access to everything in the DB to which it has been added, along with your
> utility DB.   You can also simply have the user add a reference to their DB
> as well, then call some "starter" procedure to kick-off whatever your
> utility does.   Most of the utilities out there (Find and Replace, Access
> Wizards, etc) are written like this.   Some are written with Access, while
> others are written as a COM add-in with something like C#/.Net.
>
>    You also could have them execute your utility, which could then open the
> target DB and manipulate it as a database, or you can open a 2nd instance
> of
> Access, open the target DB in that instance, and manipulate it through
> automation.
>
>    There are pros/cons to each of the approaches.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Susan Harkins
> Sent: Friday, October 14, 2022 11:36 AM
> To: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Call a function in an AccDb from outside it?
>
> Arthur, when I run into any kind of task that I just can't work out, I
> usually take a few days away from it. Then, I go back to the beginning and
> strategize -- what can I change here to make this easier???
>
> It always works for me, and most often, I end up going a different route.
>
> Some of the reader requests that I get are so odd and complex that all I
> can
> say to them is, "why must you do this, this way?" It always starts a
> conversation that often leads to a different solution.
>
> Just a thought and this might not be what's going on with your requirements
> right now.
>
>
>
> Susan H.
>
> Thanks, Rocky. I'll give that a try and see how seamless it is.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur