User Profile

Collapse

Profile Sidebar

Collapse
AaronMason
AaronMason
Last Activity: Nov 9 '06, 02:34 AM
Joined: Oct 30 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AaronMason
    replied to Accessing MS Access database catalog using SQL
    in Access
    Hey,

    Thanks for the quick reply, when I tried that query, this was the response I got:
    Code:
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'msysobjects'.
    Any idea as to how I can acquire read permission on that table?

    Thanks in advance
    See more | Go to post

      Leave a comment:

    • AaronMason
      started a topic Accessing MS Access database catalog using SQL
      in Access

      Accessing MS Access database catalog using SQL

      Hi,

      Is it possible to use SQL to get a database's structure, like
      Code:
      SHOW TABLES
      in MySQL? I'd like to create a database access interface for MS Access databases in JSP/Java Servlets and I need to be able to access the database structure. Of course, I would port this to other languages as well, but since I'm learning JSP/Servlets I'd like to start with that for the time being.

      Thanks in advance
      See more | Go to post
      No activity results to display
      Show More
      Working...