By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Run procedure in a different database

P: n/a
Is there a way to run a procedure in a different open database?

Aug 21 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
rkc
On Aug 21, 12:27 pm, "Karl" <some...@sbcglobal.bizwrote:
Is there a way to run a procedure in a different open database?
Probably. Why?
Aug 21 '08 #2

P: n/a
On Aug 21, 12:27*pm, "Karl" <some...@sbcglobal.bizwrote:
Is there a way to run a procedure in a different open database?
Maybe Application.Run. See:

http://groups.google.com/group/comp....cd8f3e06382521

James A. Fortune
CD********@FortuneJames.com
Aug 21 '08 #3

P: n/a
Sure.

On Aug 21, 12:27*pm, "Karl" <some...@sbcglobal.bizwrote:
Is there a way to run a procedure in a different open database?
Aug 22 '08 #4

P: n/a
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
'--------------------------
Aug 22 '08 #5

P: n/a

"rkc" <rk*@rkcny.comwrote in message
news:4e**********************************@m36g2000 hse.googlegroups.com...
On Aug 21, 12:27 pm, "Karl" <some...@sbcglobal.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.

Aug 22 '08 #6

P: n/a
rkc
On Aug 22, 9:12 am, "Karl" <some...@sbcglobal.bizwrote:
"rkc" <r...@rkcny.comwrote in message

news:4e**********************************@m36g2000 hse.googlegroups.com...
On Aug 21, 12:27 pm, "Karl" <some...@sbcglobal.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.
Aug 23 '08 #7

P: n/a
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...@sbcglobal.bizwrote:
I'm using follow hyperlink in an mdb to represh the html screen display.
Aug 24 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.