Link one Access Application to another

[strangeryet]

Is it possible to link one Access Application to another (other than importing the needed tables and forms)?
I saw in the command button options a 'run application' function but when I put the link to the other Access app in there, nothing happened other than an error when the command button was clicked. I was hoping the other Access application would pop up.

thanks

 

[lespaul]

do you just need access to the other Access database? You can directly query a table in another Access database without linking, I'd have to look around to find a post with an example.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[lespaul]

Here's one, it's an insert not a select, but it shows the format for an "external" Access database:

INSERT INTO [;Database="J:\Proj\DB\MODCRCH.mdb"].dt_Field_Parameter  ([Table_Name], [sys_code], [measurement_date], [measurement_time],[param_code], [param_value], [param_unit])
VALUES ('1','test',#10/20/76#,'13:13','pH',7,'std units');

So maybe:

SELECT * FROM [;Database="J:\Proj\DB\MODCRCH.mdb"];

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[PWise]

this works
SELECT * FROM Digits IN 'C:\Issues.mdb

 

[strangeryet]

Thanks for your replies? But does your examples apply to a single function? I am looking for away to fire up an entire new instances of Access, with all the controls and features that the new opened Access app has to offer.
Basically there would be two instances of Access running.

Thanks.

 

[PHV]

Have a look at the CreateObject function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PWise]

Dim AppAccess As New Access.Application
Set AppAccess = CreateObject("Access.Application")
AppAccess.OpenCurrentDatabase ("c:\issues.mdb")
AppAccess.Visible = True

 

[strangeryet]

Thanks for all of your help. pwise's post did the trick!