Open Table Upon Opening Database

[Joe4]

I know that you can have a form automatically pop-up upon opening a database, but is it possible to have Access goto and open a specific table upon opening a database.

If not directly, how about running a macro that opens the table?

I guess I need something that is similar to Autpen from Excel.

 

[Mudface]

Not sure why you'd want to do this (surely a form set to datasheet view would be better?), but if you create a macro to open your table and save it as AutoExec, then that will fire as the database is opened. Note that a user pressing the Shift key can bypass this.

 

[Joe4]

Thanks.

It is just a "reference" database of Access that was created using http://support.microsoft.com/default.aspx?scid=kb;en-us;268721&Product=acc2000. This table is the only thing in the database, and when I open the database, I want to go directly to it.

If it was a database that I was going to be updating & maintaining, I agree that a Form would be better.