View Database without MS Access

A

Andy

I am attempting to let users view the database without MS Access. Does anyone
know if any software exists in the market or within MS Office that allows
user to view data in an Access database but not able to manipulate the data?
Thank you very much.
 
R

Rosco

Andy,
What exactly are you atempting to do.

Do you want users to interact with the DB , data enter without Access as
if it were a distinct application? If so, that is not possible with an access
db. You could get the developers extendstions, that would allow you to
package a runtime version of Access with your app and simulate a seperate
application.

I think however you just want people to be able to view the data in your DB.
Is this correct? If so, there are a couple of simple solutions.

1. You could export your tables or queries to an excel workbook.

2. You could create an Access report and export the report as a "Snapshot"
file. Anybody that has a FULL installation of Office will have a snapshot
file viewer.

3. The last thing you can do is get a third party PDF print driver (google
for pdf print drivers), there are many low cost or free versions out there,
print the report to the pdf file. Just about anybody will have Adobe Acrobat
reader on their PCs and will be able to open and read your report.

Hope this is of some help to you.
Rosco
 
J

Jamie Collins

An .mdb file contains Jet elements (tables, rows, columns, data types,
constraints, indexes, stored queries, etc... oh yeah, plus the data in
the tables) and may contain MS Access-specific elements (forms,
reports, etc). The Jet elements are accessible outside of the MS
Access UI, the MS Access are generally not. Subject to permissions, an
Excel user could open an ADO connection to the .mdb and make changes
to the data or schema. It's not just MS Access applications that use
Jet databases! If you don't want certain users (or applications) to
make changes then revoke their 'write' permissions.

Jamie.

--
 
Top