Hi guys!
What query should I use to retrieve a list of all the table names in an Access database? The effect would be similar to that of a simple "SHOW TABLES;" in MySql. To clear thing up, "SHOW TABLES;" does not work in Access(it says something like: "SELECT, INSERT, UPDATE or DELETE expected").
Thanks in advance.
5  19533 
Hi guys!
What query should I use to retrieve a list of all the table names in an Access database? The effect would be similar to that of a simple "SHOW TABLES;" in MySql. To clear thing up, "SHOW TABLES;" does not work in Access(it says something like: "SELECT, INSERT, UPDATE or DELETE expected").
Thanks in advance.
I don't think this is possible with an SQL query, as they need tables to be pointed to. However, I am sure there would be some simple VB code you could embedd in a form to the same outcome.
ADezii 8,834
Recognized Expert Expert
Hi guys!
What query should I use to retrieve a list of all the table names in an Access database? The effect would be similar to that of a simple "SHOW TABLES;" in MySql. To clear thing up, "SHOW TABLES;" does not work in Access(it says something like: "SELECT, INSERT, UPDATE or DELETE expected").
Thanks in advance.
The following SQL will return all 'Non System' Tables: - SELECT MSysObjects.Name, MSysObjects.Type
-
FROM MSysObjects
-
WHERE MSysObjects.Name Not Like "MsyS*" AND MSysObjects.Type=1
-
ORDER BY MSysObjects.Name;
The following SQL will return all 'Non System' Tables:
- SELECT MSysObjects.Name, MSysObjects.Type
-
FROM MSysObjects
-
WHERE MSysObjects.Name Not Like "MsyS*" AND MSysObjects.Type=1
-
ORDER BY MSysObjects.Name;
Well that shut me up! Nice post ADezii
ADezii 8,834
Recognized Expert Expert
Well that shut me up! Nice post ADezii
Thanks. It just happened to be one of those 'little things' that I remembered over the years (LOL).
Thanks a lot!
My best regards!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: 'bonehead |
last post by:
Greetings,
I'd like to figure out some syntax for retrieving the data from a table
when I don't know all the of field names. What I do know are, the name
of the table, the names of the primary key fields, and the names of the
fields I want to use in the "where" clause of the SELECT statement. All
of the examples I've seen in my books only...
|
by: sci |
last post by:
Could someone help me by answering the questions below?
What's a cursor?
What's difference between Query and View?
Is a RecordSet just part of a table? Can it be part of a query of view?
If the content in a table changed, is it necessary for a old recordset to
renew itself by do "Requery()"?
Thanks for your help!
|
by: ynott |
last post by:
I have an Access database with 58 fields in one table. I wrote many
of the field names so that they were descriptive so that others could
figure it out in the future. As an example, one field name is called
MissingPart14990aDescribe.
Should I be worried about the length of the field name? I'm expecting
about 20,000 records a year to be...
|
by: Martin Lacoste |
last post by:
(Access 2000)
Two issues:
Within a query, I need to return a field name as data (see eg. below).
I need to search within 80 fields (same criteria) - is there a way to
avoid 80 separate expressions (the 80 field names are stored in a
table - can I get the query to look each of these up?)?
Here's an example:
|
by: ats |
last post by:
I have a table that contains the database names of external databases.
Each one of these external databases contain a table (which has the
same structure) that I would like to query together as one list.
For example, say each external db has a table of names.
tbNames (external db structure)
-------
name as text
- example db1.mdb
| | |
by: Brian |
last post by:
Hello,
Basically, I'm running a query on a form's activation, and I'd like to
have the results of the query be placed into other fields on the same
form automatically.
Does anybody know how this can be done?
I've tried setting the default value of the text fields on the form to
be equal to ! using Access' expression
|
by: Maxi |
last post by:
I have a table (Table name : Lotto) with 23 fields (D_No, DrawDate, P1,
P2,.....P21) and it has draw results from 1st Sep 2004 till date. I
have another table (Table name : Check) with 15 fields (F1,F2,....F10,
R6, R7, R8, R9, R10). I have few lacs combinations of 10 numbers in the
Check table in the first 10 fields F1-F10).
I want to check...
|
by: deko |
last post by:
When using OutputTo with a query, the 'File name' window in the 'Output To'
dialog gets populated with the name of the query by default. This makes the
exported file self-describing if the query is named on the fly.
The benefit is consistent file naming, and users don't have to enter a file
name when exporting.
The problem is the query...
|
by: Sam |
last post by:
Hi,
I have one table like :
MyTable {field1, field2, startdate, enddate}
I want to have the count of field1 between startdate and enddate, and
the count of field2 where field2 = 1 between startdate and enddate,
all in the same query.
|
by: hapnendad |
last post by:
In the question statement below Field names are in and variables are in (). All fields referenced are in what I have named the ‘PAR’ Table.
Using MS Access 2003, I am working on a project management database and have reached the point where I need to develop a way for managers to re-assign responsibility for all active projects to another of...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
