I want to make a web interface for my database...

[Chicken Kebab Abdullah]

Hello,

I'm relativly new to access and have finally got to grips with most of
it and made a fully functional database.

Now I want to go one step further and make a web interface for it.

Basically I want to be able to do the same things to my dbase via
I-explorer on any computer, that I would be able to do on my own comp
with access forms.

What is the best tool to use to design a web interface?

I was thinking of purchasing dreamweaver or would it be better to just
learn vb script or asp/php or something.

Is it a big step to make a web front end so will I have to learn a lot
of things from scratch?

Is there a way of transporting code from my events in access or will
they not work with web stuff?

tia,

Jon.

[Steve Jorgensen]

Well, it looks to me like Microsoft actually has quite a winner with ASP.NET.
You can develop Web-based applications for ASP.NET using either
VisualStudio.NET (costs $) or Web Matrix (free, but for Web App development
only). ASP.NET abstracts away a mountain of complexity regrding binding a Web
front-end to a database back-end.

Another other option is to host an ordinary Access application using Windows
Terminal Server or Citrix, but that needs a termnal server to host the app and
requires serious hardware on the server for more than a few simultaneous
clients.

If you have a fairly finished app, I would lean toward the terminal server
options initially, otherwise, I'd look into ASP.NET.

On 19 Dec 2003 00:25:13 -0800, bo**********@yahoo.co.uk (Chicken Kebab
Abdullah) wrote:

Hello,

I'm relativly new to access and have finally got to grips with most of
it and made a fully functional database.

Now I want to go one step further and make a web interface for it.

Basically I want to be able to do the same things to my dbase via
I-explorer on any computer, that I would be able to do on my own comp
with access forms.

What is the best tool to use to design a web interface?

I was thinking of purchasing dreamweaver or would it be better to just
learn vb script or asp/php or something.

Is it a big step to make a web front end so will I have to learn a lot
of things from scratch?

Is there a way of transporting code from my events in access or will
they not work with web stuff?

tia,

Jon.

[MX1]

You may also want to explore the Data Access Pages built into Access. I'm
just starting to explore them...

"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:pb********************************@4ax.com...

Well, it looks to me like Microsoft actually has quite a winner with ASP.NET. You can develop Web-based applications for ASP.NET using either
VisualStudio.NET (costs $) or Web Matrix (free, but for Web App development only). ASP.NET abstracts away a mountain of complexity regrding binding a Web front-end to a database back-end.

Another other option is to host an ordinary Access application using Windows Terminal Server or Citrix, but that needs a termnal server to host the app and requires serious hardware on the server for more than a few simultaneous
clients.

If you have a fairly finished app, I would lean toward the terminal server
options initially, otherwise, I'd look into ASP.NET.

On 19 Dec 2003 00:25:13 -0800, bo**********@yahoo.co.uk (Chicken Kebab
Abdullah) wrote:

Hello,

I'm relativly new to access and have finally got to grips with most of
it and made a fully functional database.

Now I want to go one step further and make a web interface for it.

Basically I want to be able to do the same things to my dbase via
I-explorer on any computer, that I would be able to do on my own comp
with access forms.

What is the best tool to use to design a web interface?

I was thinking of purchasing dreamweaver or would it be better to just
learn vb script or asp/php or something.

Is it a big step to make a web front end so will I have to learn a lot
of things from scratch?

Is there a way of transporting code from my events in access or will
they not work with web stuff?

tia,

Jon.

[Jerry Boone]

This is complex, but if you have a webserver at your disposal... then it
gets less complicated.

I would definitely recommend that you check into ASP or ASP.NET. If you are
a good at html and vbscript, then ASP is great. I build web apps with .Net
every day of the week, and I have to say - it has taken me 9 months to get
proficient at it, even after being VERY comfortable with ASP. Working with
ADO objects (connection, command, and recordset) is also very important for
accessing, executing a query, and looping through a recordset to fill your
page as the webserver is rendering it.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Chicken Kebab Abdullah" <bo**********@yahoo.co.uk> wrote in message
news:db**************************@posting.google.c om...

Hello,

I'm relativly new to access and have finally got to grips with most of
it and made a fully functional database.

Now I want to go one step further and make a web interface for it.

Basically I want to be able to do the same things to my dbase via
I-explorer on any computer, that I would be able to do on my own comp
with access forms.

What is the best tool to use to design a web interface?

I was thinking of purchasing dreamweaver or would it be better to just
learn vb script or asp/php or something.

Is it a big step to make a web front end so will I have to learn a lot
of things from scratch?

Is there a way of transporting code from my events in access or will
they not work with web stuff?

tia,

Jon.