Re: TransferSpread*** to .ADP dbo table

I strongly believe that you have a collection of database expressions
and an application that pastes them together into sentences and
paragraphs randomly. When you post here you use the application to
create a verbose conglomeration of nonsense. I believe this because
nothing else makes sense in explaining why you persist with your
posts, (this one included) which are generally 90% WRONG!
Access is NOT a RDBMS, regardless of the preface of this newsgroup;
There were several versions of SQL-Server prior to SQL Server 2000; if
competitive means they were purchased and used extensively then they
were competitive;
I believe MS never dreamed that Access (actually JET) would challenge
DBs like Oracle.
Access could interface with SQL-Server through ODBC long before ADPs
existed.
To suggest that MS created .NET because of deficiencies found in ADPs
is just NUTS!
Access/VBA is not Object Oriented. So how can you say that MS is is
basically modeling its (OOP) technology after Access?
and so on ....
You continually suggest using .NET without providing any suggestion at
all as to how, or any specific procedures or code at all. You might
just as well suggest yoga, meditation or masturbation; any of these
would be just as relevant.
It's true that .Net does stuff for you. That is it's failing. I don't
want it to do stuff for me. I want to do stuff myself within the
bounds of my situation. If I'm successful my solutions will be lean
and sparse. I have yet to see anything from .NET that didn't deserve
the nickname JUMBO and could not be adequately covered with the
lifetime work of Omar the Tent Maker.
BTW, did you ever look at an ASPX - Gridview page with a source editor
that showed you what's ACTUALLY there, as opposed to the code that
creates it. It IS ASP, except that it's poorly formed, inefficient,
verbose, silly ASP that runs interactively on the server. The Gridview
is a giant hoax! (See below)

This (the script was created by just dragging and dropping the table
onto the page in VS Studio):
------------------------
<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="Schools.aspx.vb" Inherits="Schools" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml";>
<head runat="server">
<title>ESO - Schools</title>
</head>
<body style="margin:5%">
<h3>
Schools
</h3>
<form id="form1" runat="server">
<asp:GridView AlternatingRowStyle-BackColor= "#f0f0f0"
AutoGenerateDeleteButton=true AutoGenerateEditButton=true
ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID"
ReadOnly="True" Visible=false
SortExpression="ID" />
<asp:BoundField DataField="Name" HeaderText="Name"
SortExpression="Name" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:SQL2005_51315_ffdbaConnectionString1 %>"
DeleteCommand="DELETE FROM [Schools] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [Schools] ([Name]) VALUES (@Name)"
ProviderName="<%$
ConnectionStrings:SQL2005_51315_ffdbaConnectionString1.ProviderName
%>"
SelectCommand="SELECT [ID], [Name] FROM [Schools]"
UpdateCommand="UPDATE [Schools] SET [Name] = @Name WHERE [ID]
= @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
------------------------

becomes this:
------------------------


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml";>
<head><title>
ESO - Schools
</title></head>
<body style="margin:5%">
<h3>
Schools
</h3>
<form name="form1" method="post" action="schools.aspx" id="form1">
<div>
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" /

<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT"
value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="fKFDp0zB1iQS4Zb9nkP8s1OF+F0i1qdp8peWb6UmTIBlby6j+d6jlciRYFHqJ
+hLmWJfOF+suILmFysmygKZ/bwEZzRoAvfqKXSZQQc0am2X6rahJVKJiMsj57FXM94nxDr/
WIiQpiiQacFrBXbkfdz/
iHYfdgsf4ybHkQMu0anLJ9WaNKZc2v9QG2x7XFwbMYWxUfZ9EpOWWExLUMACx2et2L/
LvQIjYM7WfbPGSN0hVg1nfRo2KPRCHScr1OUp8Hd9Jb9vlD2gkEurCy6emmD4pj8uRvwkA51IP
+CrCoi9c76sKxdvj1zwcuN6Bq3OXKxUyso6WyVZBIEo9rVO409PgtVJPJbs71/
lGi0jSVOZ69WzJuAOopLPx8IkgMCciymNspehGZGuuwkCYVWjufEL6/
bzcv5H0RrYBvta8Fdov9yrpTZ9d9wb6Okr7ohIGHtOdR3QONC9DhxuS8P9kkNYCgcTTMuC1b3TyatsvRwXuJrBcJ2YhGPKukOuNyszv3V9A0WpAm
+DPKZr0p8YDcgyOriBpysRrHgb2xt136sslzBG4uJ85hM8hmpeL/sQmVMF9QdF4oIc9or/
pg+zgDhgw91DXmTsBq1Wk1HYk4P1b/0GU8zNX9ghNQ0Hy
+6BJV6wKQkfPtNeQbUUNhEfcrfZaxB9F3TP34iRRDNNPrpFFbcmzBH0tvJDTd9Dq4PHkyen2rzo9BtP3qgkkQLr/
X6xmS2rTjlN+Fy8bQIUaFenUG3ZYAWMJEB8OveVS9D6tVIbRbUJl6n59w5XGCjD/
sKj8QLcuJ5DJ3UD+2q/QAo0N5N0tN
+GB4cnAQkrQTqkg4zEwis9lspy9HCvkHkDW8EKjOOVFqzSmSjtJDHN1V57MMTfCWK/
fZ2jJ36hiGXsoDgV5JXnXXaLzUJDVg886ZnRjTLHFRoBJuDgBCcZX/
pmgY0MKeZAxPIbTe0o3uWAOZEiVtqhRDlXUSjnasstfqxI3G52X+t/
+hc8ia3rdTREHD6iL1jdynj71UAMwpzrbKFRvb8k0yyPtd+hf3Z8XIAVr915I/
u5EER95ellvOaPWILhmJn3u7OFEgqZMtq3+Kl57T8CqIRoeZqwS1hYFNI01pRO6RgA8wjlousSsBYzXJebq/
m+TyhG0GxvSXxq2cTz3DbNygHeEEjV4ZgxNpwtjb3G9+4cRvS5e1gq/
7hBf7gIC7kj2THcUf6L1wBmLaQhnbr+G2W25jGf24DzLhz7DI94CyuChhC4xXpCSWnxp
+Ng8uvqIuvNxJUJCDsRcoubkxt6ar1P0GcYijaxCagkalIz3HN9zkhk1eandtDDl/
MPmi39TDV0elHtOwcnvLSsqnhPCxj9UqNo3BgnHV7vu8M13zNTLlhIyeIB8+AHyVmWYySbuAFuiHwyRY3/
A9Vf/
xTbUBm8XixEH7nXJBA5tqOAWGmabbZM3L8vFkKxFU8e2GEzMsPdsDLsnLfspKkO02VHlKa3SAgyNm0pQqLATR/
OZLPHEvrpaYnK1zsM7XIS3VraNVLPADWXjKzhPTw1Q5V6IW5IRL776RHXb+LKLFoMo
+bD3xPEMUHDrCeMaA58aE9zWtZo7zMMUa69yxR1kfsqJ4BVVJkC48AIb1tm
+5CGhoD3Z0Gp2xqDCcAex8nu3sGocDW43Dd0UDtgFRxfOZHoyik
+nElGGz4WIMhxSDkLwnOKYd3qjWrJNXPt4k65krDVe7C8bD0/cEVmscPkp/
E6MTVbc1mgPrSwCthaWcg2NblXWEAfzcj7G3W6Tq6/NGLiVHcvZBGSbSsG5Q2Fs
+2pV8NbIBntEeyN5fAkeWgxAnOdGrLj8+mQ2ZZN9jN+m43SBsL/
hjOXy4JByxKBsg2CuQtByWj0Sjw2wOlB
+JxWG2L3SJOfdaUAohPa6vEPazsNImP8aURGkU9I+/
HgmWx2JLlMUKors3bnIx4I1QI2gTv8C46pRoRh1+UkhfMYQBq0JM1C3w3pZXqLksgr/
jM2axrD+k6HuG3qc/5RNfm4llXsaX7DS2WaabK8zBlovhS7ouqvYt26w1i/
FWqF7AGpQuAkLweXmqczXIiS2j
+JQ7ciOa3wg2igl647jqGHwBPU7whE4KlMy7bphowh2aHkYf42guAG/
nsANRRgGl4mHzujk1dRzXmZlv8n8tSfM5yxPgHJj4JS6QJFKDCzTBitkHOJKTzsuTQCJNEB6dAT
+VPO/NeeZZ748N4ug4Z1dYTCNg4RciUBDa3bCLGfbC8ps/eD2uRfrjylHpfo8b/
UgB1DyXs2kb6p0aGXobVsY9WOoiO2YNdYGmgWAm8JxJiSBdb4eJ1Wgy5JLtGbSgk9XSNyy9ZTrYKw
+JqVGe0YOJ70DC55aV87qsRLsX9wu1SSYo/tZ/
wFjIlO5ij5Uf8b9HalNYhjezudYmbxPsZbdAugrOAgDrO/dYFfxDYlf53LptcqJ
+WJkmB6GY90u8AxlLaRzu23NXBWiSLsBgRwc5rII6CnxlLTL3/
Bi89iLNUGsjCatacW1w0xl2kMzzmOzlgWBmAk0NxPbK3tzXrsqAOSBkNvM4DpxhJjVIE4fSCvIww0LpRTffPvCwlS9PIeWSG1xb6NNgbs5k91SF9Blo
+gX+qaiax+N9Fk1LJ3Jq6hy87vLZN3nDYZeY/bMVXbNwOicPVe
+LGX9iLnqWCjHRvpevBun4EEutzSTKIHd567avVaoUYUz
+Ge7uFRTv47UyBpJDf5qA0gZ4KIq+Ekx6HJdkWdLDX1MuQIdAe6DSJbuOrRG
+qYPg1jTyg0rw4rQ57IU5xMTgB3X8pkfpZT6gw4qdQBUgilfu7XJsXlvOkszXP1ZcZYwiQcfEmzKWRa5DxjfWCvmlY7effkF2wJJ/
j27GAvmuntbsbKiMbmiZgOwBEyAp0DZX3Z+2wn
+FU89ZCqzPFsoLY6zyXTNs2HszvoH2ycO0cOb+LDdF+Q+uoyQBpn70srFDlWO8/
XCmGPvsAqrajYcIpkGidOebhN4I2I1JOPmVkSdAfsz9JIWpiOQ+Xsqmx
+uh4rHMp5XnA3Fe7V0sWePWm1S3ttzmZ8m
+AcivYb6PVEYhIhoLTW2rXoKhE1YOH0cdLz6m/GeQhxGDe9FF1yHArUvKJswFiy4eQLQ/
XluMh7l/BM
+NmKpKpcUeaycc4oXJdmkxrbisjxvWq7UPlNVHQsgQRb8ANSWDI5tkuXB1BSBsDGh8G7YxgZG9+ikNJtTYcLyu
+WD2VDjNoVEkFktYUYQcqgeRMFu7ADGfeLTTrw6nqdnahJE/
Kja0zkckw1WJdqiqy8GQfia/kN1asT/SoGkXBhXhJJbN1Ue61X21nkqXlscMBqJ6r2bfqc
+jkJwR3KQ0EKUKTE3NwMHeO7y3OGqe
+t87Y1Ka4TfotdbSPQevJFxUBraJpgzKMdw4Y43dKXS97miYsHOV38WjqfUJmKewBfU/
vvw6RvV6DQS+E6gMV4sh3cCe2LiO0cqaTQDPm1ZKlrTYELRymsJPh+eyeOux6q
+3ZqDWJnbyRGN/vNcsB7LbEKjYpgP4kGQ0lRDZ9qU/e6U2sgPraeU1mPck27E+1n94lrbB/
x0NDQD1Sbin/6oXE5KEphscMWAycK6F0BNmYFk0Y8ZeUBOCGchfH9Dzn67h2Hk6I
+Z8QCPRwlnuvfdQ6itR7amHs61PT443UPtifu+dAFR1oiZKcMf6/T8oXJZ9UxzTgMbJB/
l4Okfl3vIuGY0cVOiiYH0U9t2HFbxgaa6eMeE3JYhM9kDF9glAi64DxLgmFTilKHFp5IF9tlxUMOKY7dhLdY7IrgUgUHCQHXvNmn3WvPwVYvDzIyH
+yxHStzKJEYbmx+UUBIX0iEZRQYgt1ToCY9pLKIO
+QxDt6Xhds33U3/5WcxiIVye8j49wMcJEERqy
+A1l3zQxL1L9LkLGa9NbKy5jYNNZrDrejwUXpr4RVJMKKdIbrknuI=" />
</div>

<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>


<div>
<table cellspacing="0" rules="all" border="1" id="GridView1"
style="border-collapse:collapse;">
<tr>
<th scope="col">&nbsp;</th><th scope="col">Name</th>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$0')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$0')">Delete</a></td><td>Aldershot</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$1')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$1')">Delete</a></td><td>Alexander's</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$2')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$2')">Delete</a></td><td>Brant Hills</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$3')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$3')">Delete</a></td><td>Brantwood</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$4')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$4')">Delete</a></td><td>Brookdale</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$5')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$5')">Delete</a></td><td>Brookville</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$6')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$6')">Delete</a></td><td>Bruce T Lindley</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$7')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$7')">Delete</a></td><td>Bruce Trail</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$8')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$8')">Delete</a></td><td>Burlington Central</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$9')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$9')">Delete</a></td><td>C H Norton</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$10')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$10')">Delete</a></td><td>Captain R Wilson</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$11')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$11')">Delete</a></td><td>Centennial</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$12')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$12')">Delete</a></td><td>Central</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$13')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$13')">Delete</a></td><td>Charles R Beaudoin</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$14')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$14')">Delete</a></td><td>Chisholm</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$15')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$15')">Delete</a></td><td>Chris Hadfield</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$16')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$16')">Delete</a></td><td>Clarksdale</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$17')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$17')">Delete</a></td><td>Dr Charles Best</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$18')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$18')">Delete</a></td><td>E J James</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$19')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$19')">Delete</a></td><td>E W Foster</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$20')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$20')">Delete</a></td><td>Eastview</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$21')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$21')">Delete</a></td><td>Emily Carr</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$22')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$22')">Delete</a></td><td>Ethel Gardiner</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$23')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$23')">Delete</a></td><td>Falgarwood</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$24')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$24')">Delete</a></td><td>Florence Meares</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$25')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$25')">Delete</a></td><td>Forest Trail</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$26')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$26')">Delete</a></td><td>Frontenac</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$27')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$27')">Delete</a></td><td>George Kennedy</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$28')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$28')">Delete</a></td><td>Gladys Speers</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$29')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$29')">Delete</a></td><td>Glen Williams</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$30')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$30')">Delete</a></td><td>Glenview</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$31')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$31')">Delete</a></td><td>Harrison</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$32')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$32')">Delete</a></td><td>Hawthorne Village</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$33')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$33')">Delete</a></td><td>Heritage Glen</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$34')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$34')">Delete</a></td><td>J M Denyes</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$35')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$35')">Delete</a></td><td>John T Tuck</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$36')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$36')">Delete</a></td><td>Joseph Gibbons</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$37')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$37')">Delete</a></td><td>Joshua Creek</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$38')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$38')">Delete</a></td><td>Kilbride</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$39')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$39')">Delete</a></td><td>King's Road</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$40')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$40')">Delete</a></td><td>Lakeshore</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$41')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$41')">Delete</a></td><td>Limehouse</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$42')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$42')">Delete</a></td><td>Linbrook</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$43')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$43')">Delete</a></td><td>Lorne Skuce</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$44')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$44')">Delete</a></td><td>Maple Grove</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$45')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$45')">Delete</a></td><td>Maplehurst</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$46')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$46')">Delete</a></td><td>Martin Street</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$47')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$47')">Delete</a></td><td>Mckenzie-Smith Bennett</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$48')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$48')">Delete</a></td><td>Mohawk Gardens</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$49')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$49')">Delete</a></td><td>Montclair</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$50')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$50')">Delete</a></td><td>Munn's</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$51')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$51')">Delete</a></td><td>New Central</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$52')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$52')">Delete</a></td><td>Oakwood</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$53')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$53')">Delete</a></td><td>Orchard Park</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$54')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$54')">Delete</a></td><td>Park</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$55')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$55')">Delete</a></td><td>Paul A Fisher</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$56')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$56')">Delete</a></td><td>Pauline Johnson</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$57')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$57')">Delete</a></td><td>Pilgrim Wood</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$58')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$58')">Delete</a></td><td>Pine Grove</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$59')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$59')">Delete</a></td><td>Pineland</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$60')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$60')">Delete</a></td><td>Pineview</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$61')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$61')">Delete</a></td><td>Post's Corners</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$62')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$62')">Delete</a></td><td>River Oaks</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$63')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$63')">Delete</a></td><td>Robert Baldwin</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$64')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$64')">Delete</a></td><td>Robert Little</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$65')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$65')">Delete</a></td><td>Rolling Meadows</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$66')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$66')">Delete</a></td><td>Ryerson</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$67')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$67')">Delete</a></td><td>Sam Sherratt</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$68')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$68')">Delete</a></td><td>Sheridan</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$69')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$69')">Delete</a></td><td>Silver Creek</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$70')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$70')">Delete</a></td><td>Sir E Macmillan</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$71')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$71')">Delete</a></td><td>Stewarttown</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$72')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$72')">Delete</a></td><td>Sunningdale</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$73')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$73')">Delete</a></td><td>Tecumseh</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$74')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$74')">Delete</a></td><td>Tom Thomson</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$75')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$75')">Delete</a></td><td>W H Morden</td>
</tr><tr>
<td><a href="javascript:__doPostBack('GridView1','Edit$76')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$76')">Delete</a></td><td>W I ***</td>
</tr><tr style="background-color:#F0F0F0;">
<td><a href="javascript:__doPostBack('GridView1','Edit$77')">Edit</
a>&nbsp;<a href="javascript:__doPostBack('GridView1','Delete
$77')">Delete</a></td><td>West Oak</td>
</tr>
</table>
</div>


<div>

<input type="hidden" name="__VIEWSTATEENCRYPTED"
id="__VIEWSTATEENCRYPTED" value="" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION"
value="ID4jDY5eVBCfwT1QvSv3vAeqOoxa+ZhawZKPYDLJ2thTaInhY/
EoQfK5Sb2uTZJIsMvp+NohOEByXZDfavCEM2h2G9x2harFF7pVA7Uzxbii1j21ghbNUm/
19/FA6NqKwoWPXgYpKHvGW3E1CrrkKoBN9yGzD/bi/itqBjVd9LxJ62A/
VaKshVy0Ve3AGnKiFBU1bxpCXfXOEooy78zGO6rtimmeBdllVFtGKZElT51DAgTsVqo96vFWLkGWATe8YTt8J52PgpNoEVc3rsuUUEV08hfiLn5AXi5KdffAnYPfw4U4vHiW3T1O1BDfXHvxctyAdHXhHRAPk06UuSiAmv26oBvklnJDsUR4IpfBBPe7r23gBjndKfgpuYhq1JboYCG
+J2+wEIIeq/LBtEq2v7Wv95cyBxWYcM6pYyL9GrkjHL6du1vRzfcZ1ip/TcNwLh
+rDrXx0L7j0qQSMW0TdDQObqrNd9WgE7WqZ7D0jtxo7H3Yjfrpwj5DpHw/
vxT2zGDLSralHIu81/qsj191pllUm8AMGQTDPqpwkKl/
xxVvq1k3nhFT7yI92MwP72J6XqKC8wIojO20YOwukr9kVx0GvuDE1vYGDYnQwLUMCTPTYKZoApKz5wQv8Ev55xYIIBr7s1apLhJjpWA4Y82nyJsImIdjGF
+g/lgBpP6Drvn4tmzXKTjkDcWWiRS5Q+3jL7YyjT3Tib
+zhFjLvq0+IFb4Q2NGqwZLnbDRb4XQpBGl4QU49GW4QZ2COVcAm9gUDOtpH40nnnQidYi94f
+IQA5kA2oz0bakKlway8xnmLd0OYo/f/e8BEGAKORxllSVDHpM
+ePfUj3SG9mjxpnANEMcAjNjWcVImpK/
kdOl4rtH08NOycr5DR15dAKMqs9GH3cbYe4OVqK9GjjlnKwo883zqzsd5Ev
+E6dDI7DvBjR2UP12qfyjKR3fNlCCvpJMO3F4uWDtnTCDuqyNeFxIxvJc/OZQbKuu/
gbkaDw2sbWMoW6ecjSSBKo2tAICxpTggBZdsPiBBI8iiYM4oivQ7wq/fEig0hhJQwQ5te/
fiIs/RwJU29XOdY01eG5OSEz2z1d6tdJdOaYRzYOps
+jttEpquHKOPOKmF7ey837JNepDkmte5YzGQLwiMnytpmOLJeOIR7RetKZ7epMrXKK4T0IfjARLS6o18esKNR
+ylQUBSylz67A93/wdF1s+ye6MoEipw2jOkAhdEE5udf8Vzii1hoP1TsQI+LPzDj3C
+DQ=" />
</div></form>
</body>
</html>
----------------



On May 8, 7:37 pm, Rich P <rpng...@xxxxxxx> wrote:
Think about like this:

The glory days of Access were during the 16 bit era.  Access was the
first Integrated Database Development Environment on the market designed
for win3.11 -- it was unbeatable and it was also an RDBMS.  With the
arrival of 32 bit systems Access was getting left in the dust by Server
DBs like Oracle.  Sql Server 2000 was the first Server DB that Microsoft
came up with which was competitive.  Then they came up with the ADP for
interfacing with this server DB, but as you know, the ADP had more
issues than it was solving.  So MS came up with .Net.  And you are
correct - that .Net is not the fixall.  But with Sql Server 2005/VS2005
- MS is basically modeling its technology after Access (again) in that
this is their first full OOP integrated development environment effort.
I believe Sql Server 2008 with VS2008 fixes some issues that have arisen
with the OOP integrated development environment effort.  This is
supposed to give the ease of programming/database programming the same
as Access except for OOP and a server DB instead of a File based DB.

Having been using .Net for over 6 years now, I find it much easier to do
stuff because I have way more functionality, and also the .Net framework
has encapsulated alot of the API's into managed code, thus alleviating a
bunch of spaghetti code.

I still use Access because a lot of the people who I support started out
their systems with Access but have stepped up to the Server environment,
and MS has obviously been focusing their Server/Enterprise efforts on
the OOP environment.  It is all about adapting.

I have read that Microsoft is outselling Oracle with their new OOP
paradigm which is modeled after the Access paradigm - the Integrated
development environment.  I tried out Java for a year or two around
2002-2003, but .Net can do everything Java can do just so much easier.

I keep reading posts of people who are trying to perform Enterprise
operations with Access and encountering all sort of problems.  That is
because Enterprise in the 16 bit system of the early 1990's is way
different than Enterprise in 2008 for 32 bit systems.

Access is still a great tool, just not the tool of choice for enterprise
ops (server based ops).

Rich

*** Sent via Developersdexhttp://www.developersdex.com***

.