database window - 2007

[Emma]

Hi I made a switchboard for my database now I'm wondering how to open it
without going into the database window. I can see for 2003 you go to tools
startup and turn off database window but how do I do it in 2007?
Thanks Emma

 

[Maurice]

Goto the Officebutton -> Access Options -> On the left choose "Current
database" - on the right choose the fourth option "Display form" and select
your switchboard from the dropdown. Close and reopen the db and you should be
fine.

hth

 

[Maurice]

And if you don't want to see the nav.pane then deselect the check in front of
Show Navigation Pane in the same Access Options...

 

[a a r o n _ k e m p f]

hey, if you used 'Access Data Projects' and you wanted to see your
tables / queries-- you could see them in a professional level tool
called 'SQL Server Management Studio'

Access (Jet) is for babies, so they dumbed down the interface to make
it simpler

 

[docmike]

Try 'Access Options' (at foot of menu which opens when you click on the
yellow button in top left corner of screen). Select 'Current database' and
under 'Application options' > 'Display form' enter 'Switchboard'. This
ensures your database always opens with the Switchboard displayed

Hope I've understood your problem correctly

Mike

 

[Emma]

Could you tell me a little more about this as we are hoping to run the MS
Access on the front end and MySQl on the back end. Would this tool help us
with that implementation?

 

[Gina Whipp]

Emma,

Please do NOT pay attention to Aaron Kempf, as he OFTEN gives misinformation
and/or not enough information and/or irrelevant information. To find out
more about using MySQL as a back-end and Access as a front end search the
newsgroups or Google it, I got 54,300 returns.

As for your original question...

Click the Office button (upper left hand corner)
Go to Access Options...
Then Current Database...
Where it says 'Display Form:', select your form there.

 

[Tony Toews [MVP]]

Could you tell me a little more about this as we are hoping to run the MS
Access on the front end and MySQl on the back end. Would this tool help us
with that implementation?

Aaron is monomaniacal on the subject of SQL Server and ADPs.

ADPs *only* work against SQL Server and do not work against mySQL, Jet
or others. That said SQL Server Express is free for a maximum
database size of 4 Gb. Another alternative is to use ODBC linked
tables against mySQL.

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/