Is Access 2007 serious?

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

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

 

[Rick Brandt]

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

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.

 

[dennist685]

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

 

[David W. Fenton]

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.

 

[Aaron Kempf]

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!

 

[Aaron Kempf]

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