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

I need to be able to get the Schema name

P: 1
I need to concatenate the schema name to a table name that is in an ODBC linked Oracle Server for use in a query in MS Access VBA. How do i get the schema name from the connection?
Jun 22 '17 #1

✓ answered by NeoPa

They can vary. What do you see in the Immediate Pane if you use (Assuming Oracle-linked table name of [tblOracle]) :
Expand|Select|Wrap|Line Numbers
  1. ?CurrentDb().TableDefs("tblOracle").Connect;

Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,419
They can vary. What do you see in the Immediate Pane if you use (Assuming Oracle-linked table name of [tblOracle]) :
Expand|Select|Wrap|Line Numbers
  1. ?CurrentDb().TableDefs("tblOracle").Connect;
Jun 22 '17 #2

ADezii
Expert 5K+
P: 8,624
It is my understanding that the Schema name will qualify the Table(s) in the Connection String. If this is the case it should be relatively easy to extract:
Expand|Select|Wrap|Line Numbers
  1. [MySchema].[TableName]
Jun 23 '17 #3

Post your reply

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