Home All Groups Group Topic Archive Search About

Do all users need the MS Access Program installed...

Author
30 Jun 2006 1:24 AM
Ember
I am in need of publishing a database by using the BE/FE technique, but was
wondering if all end users must have the Access program installed on their
local PC to access the BE? 

Thanks!

Author
30 Jun 2006 2:56 AM
jacksonmacd
Yes.


On Thu, 29 Jun 2006 18:24:02 -0700, Ember
<Em***@discussions.microsoft.com> wrote:

>I am in need of publishing a database by using the BE/FE technique, but was
>wondering if all end users must have the Access program installed on their
>local PC to access the BE? 
>
>Thanks!

--
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Author
30 Jun 2006 4:50 PM
Ember
Thanks...As a follow up question.  If there are multiple users accessing the
backend does that create any problems with data entry?  My reasoning is, I
thought that when you open a database you "lock" down those tables you are
currently useing.  If that is the case would that not restrict the following
users from data entry to those tables?

Thanks!

Show quoteHide quote
"jacksonmacd" wrote:

> Yes.
>
>
> On Thu, 29 Jun 2006 18:24:02 -0700, Ember
> <Em***@discussions.microsoft.com> wrote:
>
> >I am in need of publishing a database by using the BE/FE technique, but was
> >wondering if all end users must have the Access program installed on their
> >local PC to access the BE? 
> >
> >Thanks!
>
>  --
> jackmacMACdon***@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>
Author
30 Jun 2006 11:20 PM
Tony Toews
Ember <Em***@discussions.microsoft.com> wrote:

>Thanks...As a follow up question.  If there are multiple users accessing the
>backend does that create any problems with data entry?  My reasoning is, I
>thought that when you open a database you "lock" down those tables you are
>currently useing.  If that is the case would that not restrict the following
>users from data entry to those tables?

You lock the tables if you go into them in design view, that is if you
are adding fields or indexes to the table.  But when just adding data
Access works quite well with multiple users.

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
Author
14 Nov 2006 9:23 PM
Brandon
You can also distribute your Access data through the web using Data Pages. These are XHTML documents that are linked to the original database.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Author
30 Jun 2006 11:19 PM
Tony Toews
Ember <Em***@discussions.microsoft.com> wrote:

>I am in need of publishing a database by using the BE/FE technique, but was
>wondering if all end users must have the Access program installed on their
>local PC to access the BE? 

Yes, but you can also distribute your app along with the runtime.
Thus you only need to purchase Access, which you presumably already
have and the runtime software.  For A2003 this is the Access
Developers Edition contained within Visual Studio Tools for Office.

Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

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
Author
30 Jun 2006 11:51 PM
Ember
Thanks!

Show quoteHide quote
"Tony Toews" wrote:

> Ember <Em***@discussions.microsoft.com> wrote:
>
> >I am in need of publishing a database by using the BE/FE technique, but was
> >wondering if all end users must have the Access program installed on their
> >local PC to access the BE? 
>
> Yes, but you can also distribute your app along with the runtime.
> Thus you only need to purchase Access, which you presumably already
> have and the runtime software.  For A2003 this is the Access
> Developers Edition contained within Visual Studio Tools for Office.
>
> Microsoft Access (Office) Developer Edition FAQ
> http://www.granite.ab.ca/access/developereditionfaq.htm
>
> 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
>
Author
4 Jul 2006 10:31 PM
Marten
I am looking at needing to distribute a database to my office where
not all users have Access installed as well. I was of the
understanding I would be able to create a web based version running
off our W2K3 server. Needless to say I haven't reached that point yet.

What did I miss? Is intranet web based data browsing not possible?

Marten


On Fri, 30 Jun 2006 17:19:31 -0600, Tony Toews
<tto***@telusplanet.net> wrote:

Show quoteHide quote
>Ember <Em***@discussions.microsoft.com> wrote:
>
>>I am in need of publishing a database by using the BE/FE technique, but was
>>wondering if all end users must have the Access program installed on their
>>local PC to access the BE? 
>
>Yes, but you can also distribute your app along with the runtime.
>Thus you only need to purchase Access, which you presumably already
>have and the runtime software.  For A2003 this is the Access
>Developers Edition contained within Visual Studio Tools for Office.
>
>Microsoft Access (Office) Developer Edition FAQ
>http://www.granite.ab.ca/access/developereditionfaq.htm
>
>Tony
Author
5 Jul 2006 5:52 PM
Tony Toews
Marten <absolut***@hotmail.com> wrote:

>I am looking at needing to distribute a database to my office where
>not all users have Access installed as well. I was of the
>understanding I would be able to create a web based version running
>off our W2K3 server. Needless to say I haven't reached that point yet.
>
>What did I miss? Is intranet web based data browsing not possible?

Not using Access.  There is something called DAPs or OWC for such but
it wasn't very practical.

Also web based software isn't anywhere near as rapid for data entry or
for ease of use.

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
Author
6 Jul 2006 8:13 PM
Marten
Thanks for the reply. I had come across something for making web pages
inside Access but of course I can't find it now.

The project I am working on was strictly lookup for those using
non-full Access means. We currently have a job number list stored in a
99 page Excel spreadsheet. Only one person has the responsibility to
add. Everyone just looks up job numbers.

I'll have to look at the executable and runtime distribution.

Marten

On Wed, 05 Jul 2006 11:52:15 -0600, Tony Toews
<tto***@telusplanet.net> wrote:

Show quoteHide quote
>
>Not using Access.  There is something called DAPs or OWC for such but
>it wasn't very practical.
>
>Also web based software isn't anywhere near as rapid for data entry or
>for ease of use.
>
>Tony