Viewing Access data without Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to view an Access table, query, form, etc. without having
Access, or other database software, intalled on your computer? I wonder if
there is a viewer, other than the Snapshot Viewer, that would let one, who
has no database software, view and search data in an Access table.

Thanks.
 
As long as the tables and queries do not return more than 64K rows (I think
1 million rows in 2007), you can view the data from either tables or queries
in Excel. You cannot (and should not) try to filter it because there is too
great a chance that you'd corrupt it. Instead, save it as an Excel
spreadsheet and use MS Query to query it. I also caution that without Access
installed, only 1 user at a time can view the data.
 
Any ODBC-compliant application, such as Excel, is capable of getting the
data from an MDB or MDE file. To use forms or reports, though, you must have
Access: no other possibilities.
 
Back
Top