Viewing Access data without Access

Viewing Access data without Access

Post by am1zdHVyM » Wed, 20 Jun 2007 05:18:05


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.
 
 
 

Viewing Access data without Access

Post by Arvin Meye » Wed, 20 Jun 2007 05:43:05

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.

--
Arvin Meyer, MCP, MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/

 
 
 

Viewing Access data without Access

Post by Douglas J. » Wed, 20 Jun 2007 05:48:12

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.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no private e-mails, please)