Adding oracle linked table

[AT76]

Hi,

I ran across a cool way to link an oracle table to an access app.

http://www.techonthenet.com/access/modules/link_table.php

Here's the command:
DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=;UID=;PWD=;SERVER=", acTable, "oracle_Table_Name", "Access_table_name", False, False

When the code reaches this command it prompts the user to enter the fields you want to come with the linked table.
Question: Is there a way to avoid the prompt and just go on to the next line of code?

Thank you!

 

[SkipVought]

Hi,

Don't know if this will suit you, but I often link Oracle tables MANUALLY in the Table tab of my Access database.

Then I can use that table just like any other table in queries & VBA.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}