Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

Front end for users who don't have Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dmasch - 29 Mar 2007 16:54 GMT
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 - 29 Mar 2007 17:07 GMT
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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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
Daniel - 29 Mar 2007 17:12 GMT
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/community/en-us/default.mspx?&query=runtime+albe
rt&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access&p=1&tid=4e002847-8a
b5-462b-9d9c-17f006413d25

Abert's Info is invaluable (learn from the masters when you can)
http://www.microsoft.com/office/community/en-us/default.mspx?&query=runtime+albe
rt&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access&p=1&tid=6e4ad1ca-61
b6-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 "

Signature

Hope this helps,

Daniel P

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.