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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Yes.


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!
Click to expand...
 
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!
 
Ember said:
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?
Click to expand...

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
 
Ember said:
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?
Click to expand...

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
 
Thanks!

Tony Toews said:
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
Click to expand...
 
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
 
Marten said:
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?
Click to expand...

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
 
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
 
Back
Top