Viewing Access data without Access

[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.

 

[Arvin Meyer [MVP]]

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.

 

[Douglas J. Steele]

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.