Front end for users who don't have Access

[Guest]

Is it possible to split an Access DB into a front and back end where users
who don't have Access on their PCs can view a form and input data? -Thanks

 

[Douglas J. Steele]

Nope. In order to user forms in Access, you must have Access installed on
the client.

However, there is a royalty-free run-time version of Access that you can
distribute with your application. Users who don't have Access installed can
install the run-time version and use your application.

See what Tony Toews has at
http://www.granite.ab.ca/access/developereditionfaq.htm for an introduction
to this topic.

 

[Guest]

It is not a question of splitting your db (this should be done anyways), what
you want to do is deploy a runtime version of your db.

take a look at the following for more info
Google it and you
should find a lot of info. or just search this forum!

You can info at
Previous post on this very subject
http://www.microsoft.com/office/com...&p=1&tid=4e002847-8ab5-462b-9d9c-17f006413d25
Abert's Info is invaluable (learn from the masters when you can)
http://www.microsoft.com/office/com...&p=1&tid=6e4ad1ca-61b6-432c-918e-4478eb69be21

http://support.microsoft.com/kb/842004
http://msdn2.microsoft.com/en-us/library/aa139974(office.10).aspx#acacclinks_topic3
http://www.granite.ab.ca/access/runtime.htm
http://www.granite.ab.ca/access/developereditionfaq.htm

Also,
"You can obtain tools that will allow you to package your file with a runtime
version of Access that can be installed on the user's PC if they do not
already have Access installed. This does nothing to alter your file. It
just provides you with a means (and license) to give your users a free
(though crippled) version of Access so they can run your app.

The runtime is not without "issues" so I suggest Googling on the topic and
doing some reading before plunging in. -- Rick Brandt, Microsoft Access MVP "