Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

Opening another instance of access.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Apples76 - 23 Mar 2007 11:14 GMT
I have created two separate DB's and wish to access the seccond db via a
command button/switchbord command from the first (main), and i am currently
not able to do so. (it's coming up with errors, as i am using the 'Run
application' command  wizard.)

could someone please advise me of the code required to open another DB and
be  able to work in it.

Both of the DB's share part o the same backend but only one makes changes to
the stored data

Thanks
Wayne-I-M - 23 Mar 2007 12:04 GMT
Hi

Create a button and place this behind the OnClick event

   Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\Documents and Settings\UKOPS\My Documents\NAMEofDATABASE.mdb""", 1)

Notes
Microsoft Office\OFFICE11\MSACCESS
I assume you are using Office11
If not change this

C:\   I assum you are working on C  -
if not change this

C:\Documents and Settings\UKOPS\My Documents\NAMEofDATABASE.mdb
Insert the full path to the DB
A tip = if you don't know the path.  Click Start / Run / Browse to the DB
then click Open.  DON'T RUN - but click the the path in the run dialog box
and paste it into the code above.

Have fun

Hope this helps

Signature

Wayne
Manchester, England.

> I have created two separate DB's and wish to access the seccond db via a
> command button/switchbord command from the first (main), and i am currently
[quoted text clipped - 8 lines]
>
> Thanks
Apples76 - 23 Mar 2007 16:36 GMT
Hi Wayne,

thanks for that worked a treat.... only one more bug....

when i try to exit the second db it states "There was ana error executing
the command"

i assume that this is because i am using the Exit application function,
could you please advise on the code to close the second db.

thanks again.

> Hi
>
[quoted text clipped - 33 lines]
> >
> > Thanks
Apples76 - 28 Mar 2007 00:13 GMT
still have the second issue stated below. can anyone help.

cheers.

> Hi Wayne,
>
[quoted text clipped - 45 lines]
> > >
> > > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.