help with switchboard/ODBC connection

[acxy-1]

Hello, I am new to access switchboards and have been tasked with
displaying linked table information for associates to view for auditing
purposes. I am able to link to the tables via standalone ODBC link in
the 'tables' view but now I would like to create an interface that
would allow the user to open the database (and only see the
switchboard) then prompt for which type of table they would like to
audit (maybe this is warehouse or name address data) and corresponding
key (which in the link table prompt is preceeding the true table name)
I would then in the background the table type with the batchkey and
show the table (either in full or in a form/report level that
identifies just a few key fields, I'm thinking doing this as a DSN-less
connection would work, I just don't know about the parameters).

I know this sounds like a great concept but I have no idea on how to
get this to work functionally in an Access switchboard. Any help,
ideas, thoughts will be greatly appreciated.

As always thanks for your help.

 

[Guest]

Hi acxy-1,

Assuming you have successfully linked the tables, you should then be able to
run the wizards on the tables to create forms to display the data, then
create a switchboard to open each form as necessary.

To make your switchboard display, change your DB startup properties so that
the default form is your switchboard, and untick the checkbox that says
"display database window", which will hide the database tables etc from your
users.

Hope this helps.

Damian.