>> Open another app in Runtime

[Jonathan]

Hi, using Access 2002, I have an app loaded on a machine with a runtime
version of Access. One of the processes opens another database to run a
process in that app. This works fine when run on a full version of Access.
The runtime halts at the line...

set appAccess = CreateObject("Access.Application")

I guess that this is because it is trying to load a full version of Access.
So I tried...

set appAccess = GetObject(appPathAndName)

Still no joy.

Any ideas or suggestion appreciated

Many thanks, Jonathan

 

[Rick Brandt]

Hi, using Access 2002, I have an app loaded on a machine with a
runtime version of Access. One of the processes opens another
database to run a process in that app. This works fine when run on a
full version of Access. The runtime halts at the line...

set appAccess = CreateObject("Access.Application")

I guess that this is because it is trying to load a full version of
Access. So I tried...

set appAccess = GetObject(appPathAndName)

Still no joy.

Any ideas or suggestion appreciated

Many thanks, Jonathan

You cannot automate Access in the runtime (sorry).

 

[Jonathan]

Hi Rick, thanks for confirming this.

Jonathan

You cannot automate Access in the runtime (sorry).

 

[Albert D. Kallal]

You can't automate,but you *can* open the other database..and modify tables,
etc...

eg:


dim db as dao.database


set db = OpenDataBase("path to other database")


You can now modify table structures etc.....

 

[Ofer Cohen]

If you want to run a function in an MDB-2 from MDB-1, you can create
reference in MDB-1 to MDB-2 (Open code, in the menu select Tools -> Reference
-> select MDE-2)
Now from MDB-1 you can run all the functions from MDB-2.

Note: The refernce from MDB can be to MDB or MDE
Reference from MDE can be to MDE only.

 

[Tony Toews [MVP]]

If you want to run a function in an MDB-2 from MDB-1, you can create
reference in MDB-1 to MDB-2 (Open code, in the menu select Tools -> Reference
-> select MDE-2)
Now from MDB-1 you can run all the functions from MDB-2.

Note: The refernce from MDB can be to MDB or MDE
Reference from MDE can be to MDE only.

You can even open forms and such too. However you have to call a
function in MDB-2 which in turn opens the form.

See my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jonathan]

Hi Guys, All your contributions are very useful, thanks.

Jonathan