By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Send Stored Proc Parameters When Using ODBC Table

P: 1
hi,
I import a data to access table from sql view by DoCmd.TransferDatabase acImport, "ODBC Database" command.
I want to send aparameter to the view.
can it possible ?
thanks
Jul 19 '18 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,489
You need to be a lot more careful with what you type when working with databases. Such sloppiness as you display here in your own question will cause you no end of problems.

The Database Type parameter is "ODBC Databases".

From the Help page you can work out what to use for the Database Name parameter by following these instructions :
For ODBC databases, type the full Open Database Connectivity (ODBC) connection string. To see an example of a connection string, link an external table to Access by pointing to Get External Data on the File menu and clicking Link Tables. Open the table in Design view and view the table properties. The text in the Description property setting is the connection string for this table.

For more information on ODBC connection strings, see the Help file or other documentation for the ODBC driver of this type of ODBC database.

What is possible for your particular scenario I don't know. I've shown what you need to do as far as the Access end is concerned. That's how you use whatever is supported by your ODBC database. What it does and doesn't support I can't help with I'm afraid.
Jul 19 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.