Results 1 to 14 of 14

Thread: Tables

  1. #1
    Join Date
    Mar 2008
    Posts
    29

    Exclamation Unanswered: Tables

    Hi all,
    I am very new to Access. Can any one tell me how i can get list of tables from database. using select statement.
    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    SELECT * FROM MsysObjects WHERE type = 1
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2008
    Posts
    29
    HI pootle,
    But when i execute " SELECT * FROM MsysObjects WHERE type = 1 "
    I am getting error as " Error: ACCESS:-1907[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MsysObjects'. "

  4. #4
    Join Date
    Mar 2008
    Posts
    29
    HI pootle,
    But when i execute " SELECT * FROM MsysObjects WHERE type = 1 "
    I am getting error as " Error: ACCESS:-1907[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MsysObjects'. "

  5. #5
    Join Date
    Mar 2008
    Posts
    29
    HI pootle,
    But when i execute " SELECT * FROM MsysObjects WHERE type = 1 "
    I am getting error as " Error: ACCESS:-1907[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MsysObjects'."
    Thanks

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I only need telling once
    Do you have limited permissions to the database? Do you log in?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Mar 2008
    Posts
    29
    hi,
    i am new to access. i converted my sqlbase database to access. i dont about where to give permissions. can u tell me please.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I must say, I can't imagine a circumstance when I would "downgrade" from SQL Server to Access.

    Anyhoo - by default you will have permission. Somewhere or other your permissions appear restricted. I don't really know - I tend to roll my own security. You didn't mention if you log in or not. Also what version of Access?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Mar 2008
    Posts
    29

    error abt list of tables

    Hi Pootle,
    ya i loged in with admin user. I am using 2003 version.
    when i executed " SELECT Name FROM MsysObjects where type = 1"

    I am getting error as " Error: ACCESS:-1907[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MsysObjects'. "
    Can u help please.
    Thanks in advance

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ok - never had to do this but found this on t'interweb:
    http://www.dotnetspider.com/qa/Question32974.aspx
    My system tables have never misbehaved for me like this - I would be furious with them if ever they did.

    You can also use an object library (DAO is perfectly suited, ADOX I am less familiar with) and iterate the tables container for the objects. I went down the SQL route since it should be more straight forward but just so you know there are alternatives.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm wondering if the downsize has worked correctly. If the data is in native Access tables and you're getting that error, my next step would be to create a new blank database and import all the objects into it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  12. #12
    Join Date
    Mar 2008
    Posts
    29

    Thank you

    Thank you to all. I got it. Thank you for your help.

  13. #13
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ... and it was?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, it's good to have closure!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •