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

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.

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

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, bodleyhenley@yahoo.co.uk (Chicken Kebab
Abdullah) wrote:
[color=blue]
>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.[/color]

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

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

"Steve Jorgensen" <nospam@nospam.nospam> wrote in message
news:pbg5uv84ijsir62u71mmftv6pn0ousmgs6@4ax.com...[color=blue]
> Well, it looks to me like Microsoft actually has quite a winner with[/color]
ASP.NET.[color=blue]
> You can develop Web-based applications for ASP.NET using either
> VisualStudio.NET (costs $) or Web Matrix (free, but for Web App[/color]
development[color=blue]
> only). ASP.NET abstracts away a mountain of complexity regrding binding a[/color]
Web[color=blue]
> front-end to a database back-end.
>
> Another other option is to host an ordinary Access application using[/color]
Windows[color=blue]
> Terminal Server or Citrix, but that needs a termnal server to host the app[/color]
and[color=blue]
> 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, bodleyhenley@yahoo.co.uk (Chicken Kebab
> Abdullah) wrote:
>[color=green]
> >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.[/color]
>[/color]

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

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" <bodleyhenley@yahoo.co.uk> wrote in message
news:dbf3c3a2.0312190025.26812a00@posting.google.c om...[color=blue]
> 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.[/color]