This is probably an easy question. I do know how to develop databases but so far the use has only been locally. I need to know the correct termnology and be pointed in the correct direction to start this.
I have MS Access 2000.
I want to put a MS Access 2000 database on the interent. Users will be able to log in and insert/update records in a table. This information will update the database that is on the server.
Here is my question please - what are the components? Do I create a Data Access Page on the particular table? Is that the same as creating an ASP page? Do I have to create a pathname link to the database from the web page? Can I have the same features that are currently available at the table level (combo box, etc)
Let me know please. I am just looking for how to get from pt A - pt Z
Pam Polk
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
All a web page can do is gather the input in a form and submit to the server , and then display a response page. A web page cannot directly access a database. What you need is server side scripting to manage the processing of the form into procedures that can be applies to the database, and build the response page.
What server side scripting language are you using.
Cd&
The components that you will need are:
1. ASP (Pages/Application) - They will display the data to your users and do all the logic. They run inside IIS. Make sure you have set up a new Virtual Directory with scripting permissions.
2. The ASP pages will need some way to connect to your database. The easiest is way is to set up a ODBC connection to your Access database.
3. Database - Database where data is stored.
From my experience, there is no out-of-the-box solution that will be able to do what you want it to. You can have all the functionality that you currently have in Access on a web page, it will just take a little bit more time to set up.
Going to bed now, I'll post a sample page tomorrow if you want.
Short answer: see links at the bottom
Long Answer:
First off check out this site: http://www.fmstocks.com. This is a great resource for developing "Best-Practice" high-powered web applications. There is tons of code to download and once you download the code, print out the white papers to follow along.
Secondly, FYI - Access will create web pages for you by saving reports or forms as web pages (File>>Save As>>Select Type). This may give you alot of code to look at but may also be confusing. I don't recommend data-access pages for this reason, they are "heavy" because they do alot of the "work" for you but the "work" is not that complex to need all of the "stuff". Also, as previous posts said, the web has greate resources for this (Google>>ASP+tutorials)
Thirdly I recommend scaling your database up to SQL Server 2000 as soon as you possibly can. The benefits are too many to go into here.
Basically ASP pages sit in the IIS process space on the server computer. When someone makes a REQUEST for a file (example: http://yourserver/yourfile
IIS and PWS (sometimes called Personal Web Server OR Peer Web Services) are web servers. IIS is the Enterprise version and PWS is the 'personal' version. Basically they let you host web pages under the default location directory 'C:\Inetpub\wwwroot\'. The only time I have used PWS is when I was at home or at some other location and I didnt have access to a "Server" but I wanted to test my pages.
IIS/PWS Setup:
Environment OS: Windows 95, 98, ME, NT 4.0 (Web server not part of the OS)
Environment Web Server: Windows NT 4.0 Option Pack (IIS 4.0 OR Personal Web Server OR Peer Web Services)
or
Environment OS: XP, 2000 Professional, 2000 Server (Web server bundled with OS but may not be installed)
Environment Web Server: Control Panel>>Add Remove Programs>>Windows Components
or
Environment OS: XP, 2000 Professional, 2000 Server with .NET Framework installed
Environment Web Server: installed by default
ASP Page setup:
1. Create DSN pointing to any ODBC compliant datasource. Performance will vary depending on users, server speed, etc. (you may also use a DSN-less connection which is popular for hosted sites which charge you to setup a DSN)
2. Put your ASP file under the wwwroot or create a virtual directory by using Start menu>>Internet Services Manager a.k.a. IIS/PWS MMC (Microsoft Management Console)
3. Open a web browser (Internet Exlorer 6.0) and type the name of the server along with your file (including any directories/sub-directorie
ASP Code:
ASP files have basically 2 main sets of code within them:
1. Server side processing code. Everything within the <% and %> tags.
2. HTML code. This is the code that is used to display and interact with the user.
Server Side code sample:
myFile1.asp
<%
OPTION EXPLICIT
Dim displayText
displayText = "Hello World"
Response.Write displayText
%>
Client Side code sample:
myFile2.asp
<%
OPTION EXPLICIT
Dim displayText
displayText = "Hello" & "nbsp;"
%>
<HTML>
<HEAD></HEAD>
<BODY>
<%=displayText%>World
</BODY>
</HTML>
The 2 samples above produce the same output. The first example uses no HTML code and the entire file is "written" by the server by using the RESPONSE object (which is 1 of the 6 built-in ASP objects). The second example uses both server & client side code. It also uses INLINE SCRIPTING, which is fast to develop but is sloppy and you loose performance (see performance link below). Note: the equal sign after the first <% is the same as saying 'Response.Write'.
Notes: Microsoft marketing will confuse you with names and buzzwords, but with sites like EE and others you'll find your way. Since you are beginning web development I recommend going down the .NET path as it will lend huge benefits not found or not easily reproduced prior to this. One drawback here is that there are not as many resources available for this development as there are for pre .NET development.
Links:
1. Single File asp web site manager (siteman.asp): http://www.alief.com/anypo
2. Access manager version of siteman: http://www.planet-source-c
3. everything asp: http://www.ultimateasp.com
4. http://www.msdn.microsoft.
5. http://www.15seconds.com
6. http://www.asptoday.com
7. not asp but huge resource: http://www.dynamicdrive.co
8. http://www.aspin.com
9. http://www.activeserverpag
10. ASP Speed and performance tips: http://msdn.microsoft.com/
11. More tips: http://www.evolt.org/artic
12. http://www.aspobjects.com/
13. the asp object defined: http://www.asp101.com/reso
Wow! Thank you to all the above for posting so much great information. I am afraid I am a bit overwhelmed-I am used to doing perl5/cgi scripting on a unix server and I am trying to make the comparison to the IIs world.
I am going to read through all of your posts again on Sunday and respond back.
I have developed this database on windows xp using access2000.
The target system(school system) is running (I went to netcraft.com) Microsoft-IIS/5.0 on Windows 2000.
I may be getting ahead of myself so let me please explain what this database will be used for.
Users will need to enter council information into this database. There are 67 schools. My inital goal(I have done this before with 17 users) was to have the backend on the network server(intranet) and have the front end in 20 schools. They would only be able to insert/update data AND run reports. This would not be concurrent usage, they will do the entry once a month at their choosing. I have done this before like I said with up to 17 user.
Then I heard a lot of opinions that access would not be able to handle 67 front ends linked to one database even though there will probably not be much concurrent using and the record lock feature is on.
Others thought it was not problem. Others suggested asp pages. that is why I came here!
So then I thought I could put the database on their web server, with a link off the county web page, password protected, and the users could enter data into a form (would emulate the screen) and this data would be inserted into the db.
--
--
I know how to do this so easily in html/perl/etc but I am lost doing it this way as I am now using a database.
I guess what I am looking for is a working example that I could look behind the scenes, piece by piece, to understand this better. A simple insert from a form inserting into a table would be a good start.
I don't have any of the above hardware on my computer but I think I would pick a lot up by seeing a sample.
To andres101 -> Yes a sample page would be nice. you can use the northwind db if you want to and one of the tables.
To Bit_Twiddler -> I checked out some of the links and the 101 was most helpful to me
To Cd& -> thank your for clarifying - I guess I would need asp pages to directly access a database, the only scripting language I know is perl.
To rdmjrb-> I will see if the county has sqlserver 2000. Your tips and tricks were very good and I need to go through them again.
How do I split up points when I am done? I am new to this!
Thanks
Pam
>>I am afraid I am a bit overwhelmed
the easiest way is to break down the comments posted with parts that are confusing. This way you narrow the scope of the comments returned.
>>doing perl5/cgi scripting on a unix server
this is usually associated with high-end financial applications like banking and finance instruments modeling web tools (apache server). the drawback here is resources (both electronic and developers who can help you do what you need to do).
>>Then I heard a lot of opinions that access would not be able to handle 67 front ends linked to one database
Tools such as a C++ or VB application connected to a SQL Server can be left alone for years and you will never have to touch them (Just make reports and tweak performance), but tools such as Access front-ends need very special attention and time, so I would not recommend this for data applications that was critical. You can build prototypes and develop business rules (encapsulated in table/relationship structure, queries, forms and reports) very quickly using access, but it is what it is.
>>running (I went to netcraft.com) Microsoft-IIS/5.0 on Windows 2000
I recommend Visual Studio or you can go to http://www.download.com and search for 'asp editor' or 'html editor' or you can use Notepad.exe (run from DOS command prompt for simple editing.
>>with a link off the county web page, password protected/I know how to do this so easily in html/perl/etc
Password Protection/Security is often used very loosely (FYI - http://www.thestandard.com
>>I know how to do this so easily in html/perl/etc but I am lost doing it this way as I am now using a database.
Install IIS 5.0 and your knowledge of cgi and the other scripting languages will make asp very easy to understand. The configuration of the systems (IIS, .NET, ODBC DNSs, SQL Server, etc.) will be the hard part. FYI - the .NET framework can handle many languages including perl (this is before the .NET framework: http://msdn.microsoft.com/
>>I have developed this database on windows xp using access2000.
xp has a home version and a professional version. I have used xp professional before running IIS 5.0 with success and i do recommend it as well as with the .NET framework (both versions can run side-by-side easily). I am not running xp now so I cannot give the exact steps to install IIS, however if you have the xp operating system software (cd or network) available simply go to the control panel and select add remove programs, then select windows components, then you will see IIS, install this and accept all of the defaults, this will make your system a web server (C:\Inetpub\wwwroot). Once this is done you can run asp pages from your system and connect to an Access database that is also on this system.
>>There are 67 schools
I also recommend installing SMTP because this will enable your web application to handle emails. If you have Microsoft Outlook or a simalr email program you use then your web server (read: after you install IIS) can use to process email creation and delivery. You can easily create an email to send to alot of users, example: each school has a list of email users in a table in the database. You can loop through the users (read: ADODB.Recordset) and send a plain text or html email to an email address using data from the database or just a simple text message or even from a form on the web site, such as a Survey Questionnaire.
>>I don't have any of the above hardware on my computer but I think I would pick a lot up by seeing a sample.
True, but no extra hardware is required. Only for performance. If you have more money then you have a much larger system probably connected or "rack mounted" at a high-speed warehouse. You can either purchase a big computer and place your application files on this computer and fedex it to a hosting company (this is how ppl host their own web sites, etc) or you can just purchase some space on a big computer (free: http://www.brinkster.com/
or more high end: http://www.rackspace.com , http://www.interland.net/ , http://www.cedant.com/)
>>I guess what I am looking for is a working example
This would mean that you have a "working environment". Once you have this then I first recommend downloading some code and this would come in the form of a zip file containing some asp files, perhaps a text readme file detailing how to install and configure the code and perhaps a access database file. The first piece of code i would download would be one of two or both:
1. the last link recommended by the post: Comment from Bit_Twiddler Date: 06/21/2003 11:38AM PDT
2. link #2 from the post: Comment from rdmjrb Date: 06/21/2003 06:28PM PDT
I know at least the link from myself contains a single asp file that will manage your database and perhaps multiple database. What this means is that a developer encapsulated many database administration tasks (which can be hard enough to do by using the database itself) into a single file and this is a very small "foot-print" which is very easy to maintain and learn.
I can go over a sample piece of code. However to save time until you have a system where you can save and run the code posted here I will not test this code it will only be sample code just "to understand this better." Bear in mind there are many ways to develop these applications; you will carve out the best practices and your own style as you go. This sample contains client side code (usually javascript) to handle the user entering in their username (email addresses are useful because they are unique and can be used to send emails with less processing) and server side (usually vb script) code. Note: these new technologies (for you) are highly documented and tested and therefore you can implement your own solution according to samples.
ASP FILE CODE (default.asp) (FYI - IIS can load pages without the user typing out the whole filename. 'Default.asp' happens to be one of the pages IIS will load by default. Example this: http://youServer.com is the same as this: http://yourServer.com/defa
<%
OPTION EXPLICIT
'begin by setting page variables
DIM bSubmit
bSubmit = "" 'initialize this variable so there are no suprises
bSubmit = ucase(trim(Request("submis
if len(bSubmit) <> 0 then 'there is a value in the request object (the user probably submitted the form)
if bSubmit = TRUE 'this is case sensitive so 'true' is not the same
'we are being submitted so lets process the request
dim oCon, oRs, strSql, username, password
username = trim(request("email"))
password = trim(request("password"))
Dim vPath, pPath, ConString
vPath = "data.mdb" 'put an ms access database called data in the same place as this file
'if this doesnt work you can "hard-code" this value and replace pPath with vPath
'vPath = "C:\inetpub\wwwroot\data.m
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OL
SET oCon = Server.CreateObject("ADODB
oCon.Open ConString
SET oRs = Server.CreateObject("ADODB
strSql = "SELECT * FROM SchoolUsers WHERE username = '" & username & "' AND password = '" & password & "' AND Active = True"
' NOTE: the strSql variable will be one of the most popular variables in your code
'as it will contain your database commands (no matter if you are using access,
'sql server or sybase or any other ODBC datasource
'i find it very helpful to develop the tables/relationships/queri
'first. then take those queries/stored procedures and place them as values in the strSql variable
'this is also known as encapsulating business rules. Once the query/stored procedure
'does what you want it to do in the database you can get it to work on your web app
'but first getting it to work in the db is perfect.
SET oRs = oCon.Execute(strSqlLogin)
IF oRs.EOF = TRUE THEN 'this user does not exist
Response.Redirect("default
ELSE
SET oRs2 = Server.CreateObject("ADODB
strSqlLogin = "SELECT tblFacility.fldID, tblFacility.fldFacilityID,
SET oRs2 = oCon.Execute(strSqlLogin)
Session("strTitle") = oRs2("fldFacilityID") & " " & oRs2("fldHTMLSeparator") & " "
Session("strFacility") = oRs2("fldFacilityID")
Session("bAuth") = TRUE
Session("bSessionType") = oRs("fldUserTypeID")
Session("sUserName") = sUsername
Response.Redirect("action.
END IF
'any variable you SET "equal" to something, please also set it "equal" to "nothing" (this is best practice)
SET oRs = NOTHING
SET oRs2 = NOTHING
SET oCon = NOTHING
else
'bSubmit = FALSE so do something else like take them back to the start
Response.Redirect("default
end if
ELSE 'most likely when users first load this page they will go here first (just paint a form to let them log in)
%>
<html>
<head>
<title>Login</title>
<style type="text/css">
<!--
a:link { color: #808080 }
a:visited { color: #808080 }
a:hover { color: #0066CC }
-->
</style>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function pageInit() {
document.forms[0].email.fo
}
function submitOnEnter(p_nKeyCode) {
if (p_nKeyCode == 13) {
submissionHandler()
}
}
function submissionHandler() {
if ((document.forms[0].email.
alert("Please Enter Your Username/Password.");
document.forms[0].email.fo
} else {
document.forms[0].submissi
document.forms[0].submit()
}
}
//-->
</SCRIPT>
</head>
<body bgcolor="#ffffff" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" text="#808080" onLoad='pageInit()'>
<FORM NAME="LoginForm" ID="LoginForm" METHOD="POST" ACTION="default.asp">
<INPUT TYPE="HIDDEN" name="submission" ID="submission" VALUE="">
<basefont face="Verdana" size="2">
<table border="0" cellspacing="0" cellpadding="0" width='100%'>
<tr>
<td width='50%'>
<font face="Verdana" size="1">Email Address: </font>
</td>
<td>
<SCRIPT LANGUAGE="JavaScript">
var bName = navigator.appName;
if (bName == "Netscape")
var browser = "NN"
else
var browser = "IE"
if (browser == "NN")
document.write("<input type=\"INPUT\" ID=\"email\" name=\"email\" size=\"14\" maxlength=\"30\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT;\" onfocus=\"rollover(img1TXT
else if (browser == "IE")
document.write("<input type=\"INPUT\" ID=\"email\" name=\"email\" size=\"19\" maxlength=\"20\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT; COLOR: #000000; BACKGROUND-COLOR: #FFFFFF; border-style: solid; border-width:1;\" onKeyPress=\"submitOnEnter
</SCRIPT>
</td>
</tr>
<tr>
<td width='50%'>
<font face="Verdana" size="1">Password: </
</td>
<td>
<SCRIPT LANGUAGE="JavaScript">
var bName = navigator.appName;
if (bName == "Netscape")
var browser = "NN"
else
var browser = "IE"
if (browser == "NN")
document.write("<input type=\"PASSWORD\" ID=\"password\" name=\"password\" size=\"14\" maxlength=\"30\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT;\" onfocus=\"rollover(img1TXT
else if (browser == "IE")
document.write("<input type=\"PASSWORD\" ID=\"password\" name=\"password\" size=\"19\" maxlength=\"20\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT; COLOR: #000000; BACKGROUND-COLOR: #FFFFFF; border-style: solid; border-width:1;\" onKeyPress=\"submitOnEnter
</SCRIPT>
</td>
</tr>
<tr>
<td colspan='2'>
</td>
</tr>
<tr>
<td colspan='2'>
<INPUT TYPE="SUBMIT" VALUE="SUBMIT" STYLE="FONT-FAMILY: VERDANA; FONT-SIZE: 7PT; BACKGROUND-COLOR: #CCCCCC; COLOR:#000000;" NAME=SUBMIT1 ID=SUBMIT1 onClick="submissionHandler
</td>
</tr>
</table>
</FORM>
</body>
</html>
<%
END IF
%>
>>Users will need to enter council information into this database. There are 67 schools. My inital goal(I have done this before with 17 users) was to have the backend on the network server(intranet) and have the front end in 20 schools. They would only be able to insert/update data AND run reports. This would not be concurrent usage, they will do the entry once a month at their choosing. I have done this before like I said with up to 17 user.
You do NOT run Access on ANY of the front ends. That's not how it works. You create ASP pages that have some (but not all) of the same features as your Access database does. All of the examples given are fine -- but I'll recommend a book instead.
Look for Active Server Pages 3.0 from Scratch, I forget the author. It's a very good beginners book -- it gives you ALL the code, builds on what you start with, and going through the book will give you not only a solid foundation BUT a database driven, personalizable, news and auction site.
Don't go with the code given -- I see some very confusing things and some very wrong styles.
Perl/cgi has nothing to do with high end anything -- it's just old.
You don't need Visual Interdev. You don't need anything -- you can use notepad if you want. There are lots of good, free (or cheap) code editors. I use HomeSite, there are many others. If you have Dreamweaver, that's fine (don't use the database wizards). DO NOT USE FRONTPAGE.
You don't need .NET. Heck you don't even need ASP/Access -- you can use PHP/MySQL if you want. Just convert your Access database (and if you've done much development, you'll have to redo it anyhow).
You don't need SQL server. You don't need to host this yourself (unless that's been part of the plan). IIS is a little weird sometimes, but you don't NEED to use IIS if it's not already set up. You can use Linux/ChiliSoft ASP. Or no ASP at all.
Remember -- you're NOT going to be able to use anything you have in the Access database EXCEPT for the tables, and if you use IIS, some of the queries. That's it. No forms, no reports, NOTHING else. You'll have to build it all. If it's easier for you to do with PHP/MySQL, use that.
to: webwoman
Thank you for your thoughts. Everyone has brought up some good points including you. Let me ask you this to clarify.
When I mentioned the above system I did, the database was on their network and the front end(screens for entry) was on 17 pcs so users could enter data. All I had to do was implement the path name when I split the database and put the front end on each pc. This did work and no one had any problem updating data and I did not need ASP. I am assuming that was because I was not using html pages and not on the interent.
--
--
I do all my html in word and my cgi/perl in vi editor. So the package to do the asp pages is not important to me - I could use word or notepad.
--
--
This database will go on the county school system interent
--
--
I guess I am getting at this (please bear with me because this is not my area of expertise)...
1. I will develop asp pages that will reside on the county server
2. These asp pages will emulate in some form the entry screens that are currently a part of the database
3. Users will be able to enter their data into these aps pages
4. The database, which will also reside on the county server, will be updated
That is what I need to do in its simplest form.
webwoman please respond back and let me know if I am on track. Thank you all very much for your help. you all are experts at this and hopefully I will get this.
Pam
im not webwoman but for what its worth here is my 2 cents...hope it helps:
>>1. I will develop asp pages that will reside on the county server
yes assuming the server is configured properly to host asp pages.
>>2. These asp pages will emulate in some form the entry screens that are currently a part of the database
yes. the more you try to emulate access forms the more time you will spend trying to make it look right and time spending handling client-side form validation. it would serve you greatly to get your users to agree upon a single browser (like Internet Explorer 5.5 or 6.0). this is called your "target browser". if you can do this you will eliminate the need to have multiple code for different browsers and you will encounter less bugs and inconsistancies across browsers.
>>3. Users will be able to enter their data into these aps pages
yes. most of your time will be spent validating what the users put in. example: if they have to login using their email address, then you will have some code that checks if its a valid email address. this is called client-side form validation and i find that this is where i spend the majority of my coding efforts and if someone finds a bug its usually here.
>>4. The database, which will also reside on the county server, will be updated
yes.
>>Don't go with the code given -- I see some very confusing things and some very wrong styles.
nice. then please enlighten us with your rich code samples :)
>>Remember -- you're NOT going to be able to use anything you have in the Access database EXCEPT for the tables
i must disagree alot. it is true you cannot use the actual forms or reports, but you can use all of the business rules and logic encapsulated in these forms, reports and queries, which can take up a huge part of the effort. you can copy/paste your queries directly (delete the trailing semi-colon). also, access can save its forms and reports as web pages.
like most things you get out of it what you put into it. your biggest resource will be your own motivation to find the answers you need and thats it. very simple.
i cud give you the simple answer of the minimum requirements, however in the spirit of giving and judging from your limited knowledge background i give a broad scope of information and let you decide. remember this is INFORMATION technology - the more you have the more empowered you CAN be - happy programming :)
Basefont is deprecated. Styles are MUCH preferred.
This...
<SCRIPT LANGUAGE="JavaScript">
var bName = navigator.appName;
if (bName == "Netscape")
var browser = "NN"
else
var browser = "IE"
if (browser == "NN")
document.write("<input type=\"INPUT\" ID=\"email\" name=\"email\" size=\"14\" maxlength=\"30\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT;\" onfocus=\"rollover(img1TXT
else if (browser == "IE")
document.write("<input type=\"INPUT\" ID=\"email\" name=\"email\" size=\"19\" maxlength=\"20\" STYLE=\"FONT-FAMILY: VERDANA; FONT-SIZE: 7PT; COLOR: #000000; BACKGROUND-COLOR: #FFFFFF; border-style: solid; border-width:1;\" onKeyPress=\"submitOnEnter
</SCRIPT>
Is totally redundant. If you're going to use a browser checker, use it ONCE. However, it's usually unnecessary, and if you do need one it's MUCH better to use it to load a style sheet optimized for a particular browser.
Adding that to every form element is total code bloat, AND if the user doesn't have/use javascript, your form won't even display. Totally violates every accessibility rule. I won't even get into the inline styles...
webwoman - Please remember why we should be here. This is not a forum for you to judge code. The user who posted this question wanted something to look at, if you have something more elegant or more to offer for the knowledge of the user then please post it rather then commenting on everything else. if i thought this was a question about sylesheets, elegant coding, accessibility or anything else, then my answer and the code related would be different - but here are 2 posts totally unrelated to the question at hand.
appologies to pam polk and any users who seek solutions and answers and find this rubbish.
rdmjbr,
For someone who has never answer a question in this TA, you seem to have an awful lot to say about the style of ranked experts. The number 4 overall ranking of webwoman is the result of providing correct solutions and enhanced support that does not just answer with robotic responses but deals all contributing factors.
Please refrain from lecturing the top-experts who have built this TA with value-added support in the future.
Cd&
whatever...is this a soap opera or popularity contest :) this has nothing to do with the question and has everything to do with ego...please refrain from bringing your ego in the future and these EE.com threads will be filled with EXCHANGES from EXPERTS and not EGOS from EXPERTS...more appologies for the rubbish
>>>my only intention is to serve the user who posted the question
Then why did you post:
>>>This is not a forum for you to judge code.
That is a primary function of this TA. Anyone can encourage bad practice by failing to assume some professional responsibility and posting whatever gets by. Good experts do more than provide answers. They also teach. If you have a problem with promoting standards and best practice; you will find lots to complain about; and plenty of other threads to mess up. I suggest you have two ears and one mouth for a reason. Perhaps you should try the approach of trying to learn a little something before you preach about how you think things should work.
Cd&
...the saga continues
>>>This is not a forum for you to judge code.
wow. at least i posted some code to be disected....besides everything that was being judged would not assist the user to the bottom line of the problem. that may not ALWAYS be true...but maybe it was here :)
>>That is a primary function of this TA.
perhaps....but it may also be up to the user, the question they ask and the flow of the thread after they get some feedback and decide what they "really" want.
remember these posts from the person asking this question???
>>I guess what I am looking for is a working example that I could look behind the scenes, piece by piece, to understand this better. A simple insert from a form inserting into a table would be a good start.
>>I think I would pick a lot up by seeing a sample
i have no problem at all promoting standards and best practice and this is why i still say please post some elegant code that will offer something for this thread rather then this drama.
i appologized for hurting anyone's feelings...what more do you want besides to feed or eat ego treats because half of these posts are now complete rubbish (including this one).
Hi everyone(this is Pam)
I appreciate everyone who responded-thank you. You all have a lot more knowledge than I do on this issue. Let me start by saying my background is ms access databases but have only created applications that were not on the internet. I also have a lot of web development experience but none with asp. So I get some of what was presented to me but not all of it when it is in the area of asp/IIE and so on.
I have worked for several companies and have "split" the db by having the tables/backend on their network and the front end/forms on up to 17 computers. Maybe it was luck but we did not have any concurrent issues. That was successful. But keep in mind this was not done on the internet.
Now I want to do the same concept but instead of a company's internal network - this would go on their www server. I have not yet asked them exactly what they have but I know they done something similar in the past with an access database. I am going to ask that very soon.
It was just posed to me by someone at the county to look at it another way of doing it - this person has "heard" of this being done "somewhere" else and all I wanted to do was to get some input from some access experts-that is why I came here.
--
--
The database is complete and has the necessary constraints at the table level as well as form functionality for entry (selection from combo boxes, fields being populated from a previous combo box selections, fields filled in from combo box selections, and so on).
Instead of data updates being emailed to one person and that one person entering them the thought would be to allow people to do the below:
1. go to the county web site(the access db would be on the county web site)
2. click on a link/enter un/pw to enter the restricted site
3. select the option they needed to do their updating (minutes or council members)
4. once in that "html/asp" page would enter(I am including the table definitions):
select school(combo box)
enter date of meeting(date field in minutes table)
checkbox if visitors(y/n field in minutes table)
notes if applicable(memo field)
select topic of discussion from principal (combo box in minutes table)
select topic of discussion from council(combo box in minutes table)
4. would click submit update
5. would exit the page
All secretary's have to enter their minutes data by the end of the month. Can't say about how many concurrent users.
If entry was done at the school the browser issue is settled as all new dell pc's have IE 6 on them. If it was done at their leisure - well some could log in with aol, some people may still use netscape.
--
--
OR instead of the above, that person who suggested what they heard worked:
the access db back end would be put on the county's network(not on the internet, all school personell can access the network as a lot of application sw is accessed by many different school personnell at different schools. All are connected to the network) and the front ends would be put on one pc in each school with the database linker pointing the path the the network, in this case the H:
--
--
So that is where I am at. I would like to learn how to do asp if this is the way to go. That is why I was asking for an example - I could even email my database and maybe ask that someone could do a very quick asp page to update a table? I sometimes learn best by an example so I have been visiting the links that were emailed to me and starting to familiarize myself with all of this.
--
--
Well thank you everyone for your help. I think you all have a lot of good points and I appreciate the time it took to try to help me with this.
I am just amazed.. all of you with all of your knowledge.. I hope you are making big bucks. There are a lot of companies that would love your expertise.
well it is hot here in Atlanta so I am going to sign off now.
Pam
your logic seems on the right track.
they may not be the most elegant codes...but they are thoroughly tested for IE5+ and highly documented. email rdmjrb@hotmail.com if you like but please keep the filesize small. i can send common login screen and simple database commands (insert/update/select), populate dropdowns, etc. then you can just begin to emulate your screens and come back here and ask more questions :)
i would also recommend getting an environment ready...
Have you found a solution? Did our comments help at all?
Please see http://www.experts-exchang
Business Accounts
Answer for Membership
by: Bit_TwiddlerPosted on 2003-06-21 at 11:38:13ID: 8773216
The answer to your question is fairly inlvoved and would take a fair bit to explain the steps in detail.
Below is some info that may get you started in the right direction.
Various links to asp tuorials and the like.
http://asp-help.com/
http://www.asppipeline.com
http://www.learnasp.com/le
http://www.w3schools.com/a
http://www.aspbootcamp.com
http://www.optweb.net/eban
http://www.asp101.com
Some prebuilt apps to aid database access via the web or intranet.
Generic ASP Database Editor for Access Tables
http://www.4guysfromrolla.
Generic DB
http://www.ofifc.org/Eli/a
Online Database Editor
http://www.planet-source-c