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

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

 

[jacksonmacd]

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!

 

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

 

[Tony Toews]

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

 

[Tony Toews]

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

 

[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

 

[Tony Toews]

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

 

[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

 

[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