Can users enter info into forms who don't have Access?

[Guest]

I have Acess 2003. I want to set up a db for users to just fill out forms at
other locations and keep the DB locally on my machine. Is it possible for
users to seee the switchboard interface and enter info into forms at
different locations who do not have Access on their machines? Or does this
require a license for all client who need to use the db?

 

[John Vinson]

I have Acess 2003. I want to set up a db for users to just fill out forms at
other locations and keep the DB locally on my machine. Is it possible for
users to seee the switchboard interface and enter info into forms at
different locations who do not have Access on their machines? Or does this
require a license for all client who need to use the db?

They need either a license for Access, or the royalty-free "Runtime"
edition of Access. This can be obtained as part of the variously-named
"Access Developers Edition" - the current incarnation is Visual Studio
Tools for the Microsoft Office System:

http://msdn.microsoft.com/office/understanding/vsto/

This entails a one-time fee which lets you generate a distributable
runtime version of Access, which lets users work with a database (but
not do any design changes to it).

An alternative would be to develop a Web interface using ASP or XML.

John W. Vinson[MVP]

 

[Douglas J. Steele]

In order to use forms from an MDB, it is necessary to have Access installed.
There's no other way. However, there is a royalty-free runtime-version of
Access that you can bundle together with your application. Users who don't
already have Access installed can install the runtime and use your
application.

Tony Toews has some good information about this topic at
http://www.granite.ab.ca/access/developereditionfaq.htm