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

Paul Wolstenholme Paul.W at industrialcontrol.co.nz
Thu Oct 13 17:04:45 CDT 2022


I made myself a database that could connect to another database and list
the tables, fields, indexes, relationships and all their properties into a
table.  It was just a quick tool to solve a temporary need.
I went no further than that, so you are in territory I haven't been to.

It looks like I was intending to run some SQL on the remote database but I
never quite got there.  I must have solved my issue another way.

Paul Wolstenholme

On Fri, 14 Oct 2022 at 10:00, Arthur Fuller <fuller.artful at gmail.com> wrote:

> I'm still working on my problem of opening an AccDb within a running one.
> Thanks to Stuart, I now have that part working beautifully. But as they
> say, inside every beautiful solution lurks a monster ready to bite you.
> So I've got my utility able to browse for a database to open, then list its
> TableDefs and QueryDefs. I want to move on to be able to process its forms,
> but I can't get at AllForms. Is there any way to do this?
> Failing that, I thought that maybe I could write a function inside the
> "target" db (the one opened within my utility) and maybe call it from the
> utility DB? Is that possible?
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list