Re: get the names of all the different user tables in a database
- From: prateek aggarwal <prateekagarwal99@xxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Wed, 27 Oct 2010 18:10:50 +0530
hey martin, thanks for that URL, i'll surely have a look on this and
try out the things discussed there.
@D, J, i didn't understand the concern you raised, access does support
the table names though, this means that one can name the tables of
course.
cheers!
prateek agarwal.
On 10/27/10, D!J!X! <megamansuperior@xxxxxxxxxxx> wrote:
> Doesn't Access support tables names as well? I remember making database when
> I was starting out with coldFusion on access and being able to create my own
> tables and give them my own names.
>
> HTH, D!J!X!
>
> -----Original Message-----
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of prateek aggarwal
> Sent: Wednesday, October 27, 2010 1:07 AM
> To: programmingblind
> Subject: get the names of all the different user tables in a database
>
> Hi fellow list mates,
> for a project, I need to get the names of all the different user tables in a
> database.
> I've been trying to get this worked, but no luck since morning.
>
> The problem is that its an access database, where I don't have much prior
> experience.
>
> I've done it successfully in sql, by the following query:
>
> Select * from sysobjects where type = 'u'
>
> Since access doesn't have a system table called sysobjects, its obvious that
> the command won't work here.
>
> i got to know that the table MSysObjects is one that contains information
> about different database objects in ms access.
>
> Considering this, I've passed the following query too, which didn't execute:
>
> SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE
> MSysObjects.Name Not Like 'MsyS*' AND MSysObjects.Type=1
>
> By doing this, I've got the following error Message:"Invalid SQL statement;
> expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'."
>
> Does someone have any idea how can I accomplish this?
>
> I just need to retrieve the names of different tables in a database, which I
> will use to populate into a combobox in my c# made user interface.
>
> Any help will be appreciated.
>
> Regards,
> Prateek agarwal.
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
>
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
