Please Guide
-
Hi All, This is my second post regarding the problem.i haven't got its solution yet.:( I am using access automation. Please Guide How can I Get number of tables & names in a database using access automation? I just want to figure out number of tables & table names in an access database.is it possible using access automation.How? i don't know if it is possible using database connectivity since i don't intend to do anything with data or data fields in the tables. I am using vc++ 6.0,access-2000. Please Help!! Regards, Ankush Mehta Ankush Mehta
-
Hi All, This is my second post regarding the problem.i haven't got its solution yet.:( I am using access automation. Please Guide How can I Get number of tables & names in a database using access automation? I just want to figure out number of tables & table names in an access database.is it possible using access automation.How? i don't know if it is possible using database connectivity since i don't intend to do anything with data or data fields in the tables. I am using vc++ 6.0,access-2000. Please Help!! Regards, Ankush Mehta Ankush Mehta
Hello. I feel I must respond, since noone else does. :) I'm not in any way DB expert, but I have a faint memory that a real expert once told me that all table and column names are stored in a special "system" DB table. I'm not sure if this is true for all DB's, but it might me worth investigating. Good luck. Kakan
-
Hi All, This is my second post regarding the problem.i haven't got its solution yet.:( I am using access automation. Please Guide How can I Get number of tables & names in a database using access automation? I just want to figure out number of tables & table names in an access database.is it possible using access automation.How? i don't know if it is possible using database connectivity since i don't intend to do anything with data or data fields in the tables. I am using vc++ 6.0,access-2000. Please Help!! Regards, Ankush Mehta Ankush Mehta
Ankush Mehta wrote:
This is my second post regarding the problem.i haven't got its solution yet.
No wonder about it. Your problem statement is not clear.
Ankush Mehta wrote:
don't know if it is possible using database connectivity
If you do not connect to the database, how do you plan to get information about the database?
Ankush Mehta wrote:
How can I Get number of tables
//No. of tables. CDaoDatabase::GetTableDefCount(); //Information about tables, including table names CDaoDatabase::GetTableDefInfo(); Regards, Rajesh R. Subramanian You have an apple and me too. We exchange those and We have an apple each. You have an idea and me too. We exchange those and We have two ideas each.
-
Ankush Mehta wrote:
This is my second post regarding the problem.i haven't got its solution yet.
No wonder about it. Your problem statement is not clear.
Ankush Mehta wrote:
don't know if it is possible using database connectivity
If you do not connect to the database, how do you plan to get information about the database?
Ankush Mehta wrote:
How can I Get number of tables
//No. of tables. CDaoDatabase::GetTableDefCount(); //Information about tables, including table names CDaoDatabase::GetTableDefInfo(); Regards, Rajesh R. Subramanian You have an apple and me too. We exchange those and We have an apple each. You have an idea and me too. We exchange those and We have two ideas each.
Thanks Rajesh, i was just trying to use access automation(functionality provided by access to manipulate access without making any connection) to achieve that.However, couldn't find an answer to that. Thanks, Ankush Mehta Ankush Mehta
-
Thanks Rajesh, i was just trying to use access automation(functionality provided by access to manipulate access without making any connection) to achieve that.However, couldn't find an answer to that. Thanks, Ankush Mehta Ankush Mehta
Hi All, // Build the SQL statement SqlString = "SELECT Name FROM MsysObjects where type = 1 AND (Left([Name],4) <> \"Msys\") AND (Left([Name],1) <> \"~\")"; // Execute the query recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly); I have found this piece of info. MsysObjects table contain all the info about tables, queries,reports in access database. when i try to query MsysObjects table "Access is denied". I don't know where is it located & also it is undocumented. How can i query MsysObjects table? Please Help! Regards, Ankush Mehta Ankush Mehta