Do you need Access to use an Access Database for data entry only?

[JT in VN]

We have an Access database completed. Now we will use it for reading as well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?

 

[boblarson]

No you don't necessarily need Access on every computer. You CAN use the
Access Runtime and if it is in Access 2007 you can use it for free. If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime.

If you do have 2007 and want to use the runtime, make sure your Full version
of Access does NOT have Office 2007 Service Pack 1 installed or it will
render your database unusable by the runtime until Microsoft gets the service
pack update for the runtime distributed.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Norman Yuan]

Access2007 Runtime cannot be used with back-end database made with older
Access version (2000/2002/2003)?

 

[boblarson]

Didn't I say that:
"If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime. "
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Dirk Goldgar]

We have an Access database completed. Now we will use it for reading as
well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?

In addition to the Access-runtime option, you should be aware that other
programs can read the data in the database, even without any version of
Access installed.* However, none of the Access-specific user-interface
elements such as forms and reports can be used, as those are managed by the
Access application. So you can't run the database application without some
version of Access, and I think that's what you're probably asking about.

*Note: If you made the database with Access 2007 and created the database in
the Access 2007 format, then I don't think other programs will be able to
read it unless Access 2007 or its runtime module are installed. I could be
wrong about that, but you'll need the new Access Data Engine, which would
not be installed without Access. Maybe it can be installed independently;
I've never looked into that.

 

[Tony Toews [MVP]]

Access2007 Runtime cannot be used with back-end database made with older
Access version (2000/2002/2003)?

Sure it can.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/