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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PDF Viewer 5
Use Snapshot view with access 4
Access Viewer? 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Am I disturbing a machine in production floor if I access its database remotely? 4
access viewer 1
Data on a password-protected website 1

Back
Top