How to get all the table names in Access? Consideration: Old typical ... Ask MVM problem, MVM answered me. Although not what I think, I don't want to be a typical. See http://blog.joycode.com/mvm/archive/2004/07/27/28502.aspx
MVM language ------------------------- I saw his letter, to search, to SCAN search results, to find the answer, and even included Verify that SQL is really effective, a total flower is only two or three minutes.
So, you can find the answer to the answer, why do you want to write to me to ask me? Is it because it is not enough, don't know http://groups.google.com? Still because English is not good enough, I can't choose a valid keyword? In fact, I don't think I am an excellent programmer, but at least I will not ask someone else to search on the Internet or MSDN. There are many people who feel that many people in 9cbs and newsgroup always ask some answers to their hands, and there is a place that Chinese programmers have to improve. I have a similar feeling from today's things.
BTW, if you search for the keyword "Microsoft Access All Table" with Baidu Search, the first one returned is the correct answer. It is easy. ------------------------- For this kind of accusation, if you really say that MVM is said, it will be. Blindly painted as typical, still quite angry mood. Looking back, think about it, where did I do wrong? So I answered MVM ------------------------ MVM, I am the "unrestrained" programmer! I finally took some time again to visit your blog ... It turns out that you are not good about my own evaluation. First of all, I want to declare that your comments seem to have some arms. For you, I first express my gratitude to you as a teacher. But I want to explain, I will ask you before searching for 2 hours before Google, as for MSDN, I also search, found approach, I have already included your first time. I have tested the requirements that do not meet the requirements or there is no need. Specific reasons in the second letter I explained in detail, but you seem to have been concluded that I am a beginning, just told me to upgrade ASP.NET privileges. In fact, I am a 5-year programmer. Needless to say, pay attention to search first, and pay attention to the possibility of knowing people, and finally ask you, and understand the skills of your questions. And I think I will put forward my answer in the second letter, I don't have to make friends with you. Ha ha. It seems that you didn't want to look carefully. Thanks to "Happy" to the explanation of http://groups.google.com. It is not intended to be mentioned in the second letter to MVM. Thanks to people from Bo Hall, heavy particles, ripper, etc., thanks to MVM twice answered. Originally after summed up this problem, then let's take a look at your blog. Unfortunately, it is a typical ... an old typical: (--------------------- Give MVM comrades, MVM good people do the bottom
---------------------------------------------------------------------------------------------------------------------------------------
Also: This friend asked me later later told me that I gave the answer wrong, cloud cloud, the specific one can see the following message.
So, this, good people do it, I will list the program of the Table name in ACCESS 2003 in ASP.NET:
private string GetTableList () {string result = ""; ADODB.Connection Cn = new ADODB.ConnectionClass (); ADODB.Command Cmd = new ADODB.CommandClass (); ADODB.Recordset Rs1; Cn.Open ( "Provider = Microsoft. Jet. OleDb.4.0; Data Source = C: //inetpub//wwwroot//accesstables//aaa.mdb "," admin "," ", 0); rs1 = cn.openschema (adoDb.schemaenum.adschematables, systema .Reflection.Missing.Value, System.Reflection.Missing.Value; Do {foreach (adodb.field Field in {result = field.value ";";} result = "/ r / n"; RS1 .MOVENEXT ();} while (rs1.eof == false); rs1.close (); returnrate;} When used, the project to add ADO 2.7 reference (I think 2.6 or 2.5 is certain) No other configurations do not need. Users and groups permissions do not need to be changed, nor does it need to do Impersonate on the ASP.NET. The result is like this:
;; musysaccessObjects; Access Table ;;; 2002-12-17 1: 48: 35; 2002-12-17 1:48:35 ;; msysaccessxml; access table ;;;; 2004-7-29 16:56 : 40; 2004-7-29 16:56:40; ;; msysaces; system table ;;;; 2000-4-6 17: 49: 34; 2000-4-6 17:49:34 ;; msysobjects; System Table ;;;; 2000-4-6 17:49: 34; 2004-7-29 16:57:18; ;; msysqueries; system table ;;; 2000-4-6 17: 49: 34; 2000 -4-6 17:49:34; ;; msysrelationships; system table ;;; 2000-4-6 17: 49: 34; 2000-4-6 17:49:34 ;; Table_ASDFA; TABLE ;;; 2004-7-29 16: 56: 51; 2004-7-29 16:56:51 ;; Table_Lkjlkjlkj; table ;;;; 2004-7-29 16: 56: 40; 2004-7-29 16: 56:40;
This time I use "Access MsysObjects Permission Select Table" for the keyword (not groups). In the first page, there is a section of Code is right, I just changed from the code of VB to C #. ------------------------ This is basically a ending, although I still use my own way ---------- ----------------