Run procedure in a different database

[Karl]

Is there a way to run a procedure in a different open database?

[rkc]

Re: Run procedure in a different database

On Aug 21, 12:27 pm, "Karl" <some...@sbcglo bal.bizwrote:

Is there a way to run a procedure in a different open database?

Probably. Why?

[CDMAPoster@fortunejames.com]

Re: Run procedure in a different database

On Aug 21, 12:27 pm, "Karl" <some...@sbcglo bal.bizwrote:

Is there a way to run a procedure in a different open database?

Maybe Application.Run . See:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/1bcd8f3e06382521

James A. Fortune
CDMAPoster@Fort uneJames.com

[lyle fairfield]

Re: Run procedure in a different database

Sure.

On Aug 21, 12:27 pm, "Karl" <some...@sbcglo bal.bizwrote:

Is there a way to run a procedure in a different open database?

[John Mishefske]

Re: Run procedure in a different database

Karl wrote:

Is there a way to run a procedure in a different open database?

Unless the "different open database" is referenced as a "library
database" you'll need to use Automation to open the other database file
and call the procedure using Application.Run - which is not very efficient.

I don't know what your goal is but I'd suggest you research library
databases and see if is a suitable solution.

Good luck.

--
'--------------------------
' John Mishefske
' UtterAccess Editor
' Microsoft MVP 2007, 2008
'--------------------------

[Karl]

Re: Run procedure in a different database


"rkc" <rkc@rkcny.comw rote in message
news:4e09fa6c-5813-44c7-ba71-455178fd2221@m3 6g2000hse.googl egroups.com...

On Aug 21, 12:27 pm, "Karl" <some...@sbcglo bal.bizwrote:

>Is there a way to run a procedure in a different open database?

>
Probably. Why?

On 1 computer, I have an mdb for data entry of a simple list of names. I
need this list to be displayed on a second computer.

When the names are added to or deleted from the list on computer 1, I need
the list displayed on computer 2 to be updated.

The list on computer 2 is displayed by an html file using VBScript, not by
an mdb. (the display contains other web stuff)

I'm using follow hyperlink in an mdb to represh the html screen display.

I need to able to call a procedure in the mdb on computer 2. This procedure
has the follow hyperlink call in it.

In summary

A change in an mdb on computer 1 triggers and call to a procedure in an mdb
on computer 2 which hyperlinks to the html file causing the list to be
updated.

If you have other ideas on how to do this, I would be interested on hearing
them.

[rkc]

Re: Run procedure in a different database

On Aug 22, 9:12 am, "Karl" <some...@sbcglo bal.bizwrote:

"rkc" <r...@rkcny.com wrote in message
>
news:4e09fa6c-5813-44c7-ba71-455178fd2221@m3 6g2000hse.googl egroups.com...
>

On Aug 21, 12:27 pm, "Karl" <some...@sbcglo bal.bizwrote:

Is there a way to run a procedure in a different open database?

>

Probably. Why?

>
On 1 computer, I have an mdb for data entry of a simple list of names. I
need this list to be displayed on a second computer.
>
When the names are added to or deleted from the list on computer 1, I need
the list displayed on computer 2 to be updated.
>
The list on computer 2 is displayed by an html file using VBScript, not by
an mdb. (the display contains other web stuff)
>
I'm using follow hyperlink in an mdb to represh the html screen display.
>
I need to able to call a procedure in the mdb on computer 2. This procedure
has the follow hyperlink call in it.
>
In summary
>
A change in an mdb on computer 1 triggers and call to a procedure in an mdb
on computer 2 which hyperlinks to the html file causing the list to be
updated.
>
If you have other ideas on how to do this, I would be interested on hearing
them.

I'm still not sure of exactly what you're doing, but you have been
given two
ways to do what it appears you want to do.

Set a reference to the 2nd .mdb file in the 1st .mdb and just call any
public function
the same way you would if it were in the 1st .mdb file.

Automation and Application.Run . There's an example in the VBA help
file.

I think I would just train the users to reload the html file
periodically.

[lyle fairfield]

Re: Run procedure in a different database

How does that work? Follow the hyperlink where?

You enter some data on Computer A.

You want the data to be displayed on an html file on Computer B.

You want the html file to be current.

You could:


On Aug 22, 9:12 am, "Karl" <some...@sbcglo bal.bizwrote:

I'm using follow hyperlink in an mdb to represh the html screen display.