Is Access 2007 serious?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dennist685 - 24 Apr 2007 13:04 GMT

I want to help run an organization using access. That includes two way
access to the database. We aren't talking about heavy traffic.

Do real people use access on the web, or am I just fooling myself, and be
using visual web developer instead. I ask beause tomorrow I;m upgrading to
vista.
Wipping the hard disk clean then installing it with the help of a maven.

Thanks.

Oh, finalllly, do people host access database? Is it possible run run it
from my own computer - dedicated of course. How fast a line do I have to
have?

dennist

Reply to this Message

Rick Brandt - 24 Apr 2007 13:45 GMT

> I want to help run an organization using access. That includes two
> way access to the database. We aren't talking about heavy traffic.
[quoted text clipped - 12 lines]
>
> dennist

It depends on what you mean by "Access". If you mean can you use a jet
database file (either an MDB or the new AccDB) to store data and then
utilize that data in a web page then yes you can. It will not handle heavy
traffic, but it can be done.

Note that most people more familiar with Access would not even consider that
"using Access" because "using Access" is understood to mean using it to
build a complete application interface (forms, reports, code modules, etc.)
none of which can be used in a web page.

If you are thinking that you can build a complete Access application and
somehow run it from a web page then no, you cannot do that. You would need
to build a web interface just like every other web site you see that
utilizes databases in the background.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

dennist685 - 24 Apr 2007 15:14 GMT

Thanks Rick

I'm thinking about creating the application using vs 2005 or 'orcas',
storing the data in access 2007.

Does this change your perspective?

dennist685

> > I want to help run an organization using access. That includes two
> > way access to the database. We aren't talking about heavy traffic.
[quoted text clipped - 27 lines]
> to build a web interface just like every other web site you see that
> utilizes databases in the background.

Reply to this Message

Rick Brandt - 24 Apr 2007 16:30 GMT

> Thanks Rick
>
> I'm thinking about creating the application using vs 2005 or 'orcas',
> storing the data in access 2007.
>
> Does this change your perspective?

Are you going to be building a web application with vs 2005? If so, then
you should be able to use a jet database for the data.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Aaron Kempf - 02 May 2007 21:27 GMT

Jet isn't supported or included with windows, office or mdac

jet has been depecreated for 10 years
don't use JET , even if it's for a single record and a single user

it's just not reliable enough

> > Thanks Rick
> >
[quoted text clipped - 5 lines]
> Are you going to be building a web application with vs 2005? If so, then
> you should be able to use a jet database for the data.

Reply to this Message

David W. Fenton - 24 Apr 2007 20:49 GMT

> If you are thinking that you can build a complete Access
> application and somehow run it from a web page then no, you cannot
> do that. You would need to build a web interface just like every
> other web site you see that utilizes databases in the background.

Well, there is one exception to that: using a Terminal Server-hosted
app through the web browser control. But that is only "running from
a web page" in the most trivial sense -- you're using HTTP to
communicate with the Terminal Server and running it in a web
browser, but that's all the "web" there is involved in it. The only
thing that accomplishes is that you don't have to install the Remote
Desktop Client, which is not much of an issue these days, as it's
been included with WinXP from the beginning.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Aaron Kempf - 02 May 2007 21:26 GMT

no real people use Access for anthing

real people use SQL Server

Access MDB has been obsolete for a decade

move to ADP, File, New, Project (existing data)

good luck with SQL Server!

> I want to help run an organization using access. That includes two way
> access to the database. We aren't talking about heavy traffic.
[quoted text clipped - 11 lines]
>
> dennist

Reply to this Message