Please help me get started (Access on the Web)

[bpn]

I have a Microsoft Access database on a web server that supports Access
databases. All I want to do is have a couple of users be able to enter data
into the database via a browser.

This is not for a database driven web site, just for data entry.

Could someone point me in the right direction.

Any help is appreciated.

Thanks.

[Bob Alston]

bpn wrote:

I have a Microsoft Access database on a web server that supports Access
databases. All I want to do is have a couple of users be able to enter data
into the database via a browser.

This is not for a database driven web site, just for data entry.

Could someone point me in the right direction.

Any help is appreciated.

Thanks.

Suggest you take a look at Microsoft's FREE Web Matrix product. It is
kind of a lite development tool, similar to but less powerful than
Visual Studio.NET. It has some templates that will help you build such.

See http://www.asp.net/webmatrix/default...dex=4&tabId=46

At the left corner is an FREE online tutorial. There is a forum for help.

You are in for a bit of a learning curve if coming from Access database
development. I am still in the steep part of the learning curve. Two
books on web matrix help (try the used vendors on Amazon's site).

If you want a slick easy to use table editor - edit any number of tables
in a database, add, edit and delete without any special formatting or
validation, consider getting DataSet Editor. Free to try $19 to
license. A bit easier than using the templates in Web Matrix.

http://mayers.us/MayerSoft/DataSetEditor.aspx

And finally, a really nice program, free (for the lite version), which
generates "grids" to do list, add, edit and delete - - RapTier

It generates add/change/delete programs from an Access database.

http://www.sharppower.com/

Their lite version is free.
I found it very easy to use. And it is one of the few generators which
worked first time.

My biggest issue has been with the commercial server I am trying to use.
Having problems getting detailed error messages.

Also I found getting to identify the actual path of the database, when
you put it on a commercial server you don't control, a bit difficult. I
finally learned about the mappath command and how to use it.

Good luck.

Bob

[joni]

bpn wrote:

I have a Microsoft Access database on a web server that supports Access databases. All I want to do is have a couple of users be able to enter data into the database via a browser.

This is not for a database driven web site, just for data entry.

Could someone point me in the right direction.

Any help is appreciated.

Thanks.

What is the format of the web server? Depending on the technology it
supports, you could use ASP or JSP to make the connection to the
database and write a few simple web pages for the data entry.

[bpn]

"joni" <be******@airmail.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

bpn wrote:

I have a Microsoft Access database on a web server that supports

Access

databases. All I want to do is have a couple of users be able to

enter data

into the database via a browser.

This is not for a database driven web site, just for data entry.

Could someone point me in the right direction.

Any help is appreciated.

Thanks.

What is the format of the web server? Depending on the technology it
supports, you could use ASP or JSP to make the connection to the
database and write a few simple web pages for the data entry.

The list of technologies supported is:

ASP 3.0
ASP.NET
PHP, 100 MB MySQL
Frontpage 2003
Shared ssl support
25+ ASP Components
XML 4.0
WAP Enable
Flash Enable
SSI - Server Side Includes
MDAC 2.8
MS Access
..NET Mobile Inet Toolkit
Verisign PayFloW Pro dLL

The problem I am having is finding resources to make the connections and
create the ASP pages. Major newbie here.