>> Open another app in Runtime

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Jonathan said:
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
Click to expand...

You cannot automate Access in the runtime (sorry).
 
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.....
 
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.
 
Ofer Cohen said:
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.
Click to expand...

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/
 
Back
Top