Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / February 2005

Tip: Looking for answers? Try searching our database.

Please help me get started (Access on the Web)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bpn - 08 Feb 2005 21:13 GMT
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 - 08 Feb 2005 21:30 GMT
> 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
[quoted text clipped - 7 lines]
>
> 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.aspx?tabIndex=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 - 08 Feb 2005 21:37 GMT
> 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
[quoted text clipped - 7 lines]
>
> 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 - 08 Feb 2005 22:21 GMT
> > I have a Microsoft Access database on a web server that supports
> Access
[quoted text clipped - 13 lines]
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.