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