Full access DB on-line

[Wayne-I-M]

Hi

Our company has quite a few websites that I created that have on line forms
and "very" basic on-line access DB's. Basically I have a table that is
filled by a simple form on an asp page. All the other "stuff" is done after
I download the data into an Off-Line DB.

Has any one put a "real" access form on-line. I know this may sound silly
(and may not be possible) but I am not too good with asp codes but I'm not
that bad with access DB's. I just wondered if it was possible to put a
normal access DB on-line (with maybe a couple od small tables, some queries
and a few forms) as it would make the data collection much better.

Any ideas ??

 

[Stefan Hoffmann]

hi Wayne,

Has any one put a "real" access form on-line. I know this may sound silly
(and may not be possible) but I am not too good with asp codes but I'm not
that bad with access DB's. I just wondered if it was possible to put a
normal access DB on-line (with maybe a couple od small tables, some queries
and a few forms) as it would make the data collection much better.

There are data access pages in Access, but I don't know if anyone has
ever used them in a production environment.

Honestly, ASP(.NET) is not that complicated. Using ADO and VBScript is
easy to learn. Give it a try.


mfG
--> stefan <--

 

[Wayne-I-M]

Been looking this all day - and think will use mysql which is already on the
host's server as I am not too bad with this and should be able to do
something.

Many thanks for your interest

 

[Mark Andrews]

You could start with some easy asp pages against your mysql db. It's an
easy way to start since you can just use Notepad to develop them and there
are lots of samples everywhere. Then grow into using asp.net. Hopefully
you will stay on the Microsoft path.

Javascript would be the next thing to learn to make better web based front
ends.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[David W. Fenton]

Has any one put a "real" access form on-line. I know this may
sound silly (and may not be possible) but I am not too good with
asp codes but I'm not that bad with access DB's. I just wondered
if it was possible to put a normal access DB on-line (with maybe a
couple od small tables, some queries and a few forms) as it would
make the data collection much better.

Windows Terminal Server is the only way to do that.

 

[David W. Fenton]

There are data access pages in Access, but I don't know if anyone
has ever used them in a production environment.

Honestly, ASP(.NET) is not that complicated. Using ADO and
VBScript is easy to learn. Give it a try.

Ridiculous advice, given the question.

Access is much richer in terms of the UI and event model than
anything ASP (or ASP.NET) can ever do.

 

[a a r o n _ k e m p f]

yes, you can easily setup Access Data Projects to work over the
internet.
Jet doesnt' really run over _ANY_ practical networks-- so move to a
real database platform that just works

 

[a a r o n _ k e m p f]

hey David-- you're WRONG

terminal services is just anothr unnecessary layer.

ADP works great over the internet, maybe if you knew more about
databases, you could begin to know how to use the most powerful pieces
of MS Acess.

Access Data Projects work great across the internet, across the WAN,
across wireless-

When your database is too crappy to work over a network- upsize to SQL
Server and just use ADP.

Do you know how much terminal services licensing costs?

ADP is basically freee!!!

 

[a a r o n _ k e m p f]

David;

that's not correct.

Classic ASP is easy to use if you learned Dreamweaver.

Maybe if you werent stuck in the 90s you could start giving
professional advice.