How Can Users Without Access Do Data Entry

[Heather]

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend database on the
network. The data would be a couple of records containing maybe a half dozen
fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable option
considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

[John Ortt]

You could link excel spreadsheets or tab separated text files

They are not very secure and your "users" would have to know what they were
doing but it's possible.....

Hope that helps,

John
"Heather" <ha******@csedu cationalsystems .org> wrote in message
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net...

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend database on the network. The data would be a couple of records containing maybe a half dozen fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable option considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

[Lyle Fairfield]

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net:

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend
database on the network. The data would be a couple of records
containing maybe a half dozen fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable
option considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

I'd use an HTA-ADO application.
<http://msdn.microsoft.com/library/de...n-us/dnie50/ht
ml/ie5hta.asp>

But, I'm guessing that not many others would.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Juggernath]

"Heather" <ha******@csedu cationalsystems .org> wrote in message
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net...

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend database on the network. The data would be a couple of records containing maybe a half dozen fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable option considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

Why don't you install IIS on the comp where Access is installed, and then
create a small ASP script to insert into database via HTML form?
The only thing needed is IIS, network and IP number of server.

[Tom van Stiphout]

On Tue, 02 Dec 2003 12:49:24 GMT, "Heather"
<ha******@csedu cationalsystems .org> wrote:

No. In order for that to work they would need Access on their
machines.

You could build an Access application, and then distribute it to them
with the runtime version of Access.

Or you could write a web application.

-Tom.

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend database on the
network. The data would be a couple of records containing maybe a half dozen
fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable option
considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

[Heather]

Lyle,

Thank you for the response!

I read the article at the link you provided - I'd like to experiment with this.
Could you give me a brief outline on how to set it up; I can work out the code.
I presume I would need a HTML form for data entry. How do I create that? Then
how do I get the data to the backend table - I presume that is the ADO part.

Thanks for any help you can give me!

Heather
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.4...

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net:

I need suggestions on possible ways to implement the following:

10 users on a network need to infrequently add data to a backend
database on the network. The data would be a couple of records
containing maybe a half dozen fields. The users do not have Access.

Would adding a form to the backend database for these users be a viable
option considering they would need to open the form over the network?

Thanks for all anticipated help!

Heather

I'd use an HTA-ADO application.
<http://msdn.microsoft.com/library/de...n-us/dnie50/ht
ml/ie5hta.asp>

But, I'm guessing that not many others would.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Lyle Fairfield]

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:_b******** *********@newsr ead1.news.atl.e arthlink.net:

Lyle,

Thank you for the response!

I read the article at the link you provided - I'd like to experiment
with this. Could you give me a brief outline on how to set it up; I can
work out the code. I presume I would need a HTML form for data entry.
How do I create that? Then how do I get the data to the backend table -
I presume that is the ADO part.

Thanks for any help you can give me!

Heather
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.4...

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net:

> I need suggestions on possible ways to implement the following:
>
> 10 users on a network need to infrequently add data to a backend
> database on the network. The data would be a couple of records
> containing maybe a half dozen fields. The users do not have Access.
>
> Would adding a form to the backend database for these users be a
> viable option considering they would need to open the form over the
> network?
>
> Thanks for all anticipated help!
>
> Heather
I'd use an HTA-ADO application.
<http://msdn.microsoft.com/library/de...y/en-us/dnie50
/ht ml/ie5hta.asp>

But, I'm guessing that not many others would.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

This is a small hta app. It backs up an SQL db on its server, zips the
backup and downoads it to the user's machine. It does not require that ASP
be installed. While I generally do not use in-line styles, I have done so
here to achieve a one file utility. It requires Internet Explorer.

<html>
<head>
<title>
Some Title
</title>
<hta:applicatio n id="ohta"
applicationname ="fnd"
border="thick"
borderstyle="ri dge"
caption="yes"
icon=""
maximizebutton= "yes"
minimizebutton= "yes"
showintaskbar=" no"
singleinstance= "no"
sysmenu="yes"
version="1.0"
windowstate="ma ximize" />
<script language=javasc ript>
function executeSP(n,a){
var c=new ActiveXObject(' ADODB.Connectio n');
var m=new ActiveXObject(' ADODB.Command') ;
var e=new ActiveXObject(' ADODB.Error');
var s=new String();
connect(c);
c.Errors.Clear( );
initializeComma nd(m,c,n,a);
m.Execute();
while(m.State&4 );
if(c.Errors.Cou nt==0){
alert(n+' executed successfully.')
}
else{
for(e in c.Errors){
s+='\n'+e.Descr iption;
}
alert(s)
}
c.Close();
}
function connect(c){
var s=new String();
s+='Provider=sq loledb;';
s+='Data Source=255.0.25 5.0,9999;';
s+='Initial Catalog=BlahBla h;';
s+='User ID='+document.f orms[0].userID.value+' ;'
s+='Network Library=DBMSSOC N;';
s+='Password='+ document.forms[0].password.value +';'
c.ConnectionStr ing=s;
c.CursorLocatio n=3;
c.Open();
}
function initializeComma nd(m,c,n,a){
m.ActiveConnect ion=c;
m.CommandText=n ;
m.CommandType=4 ;
m.Prepared=true ;
if((typeof a=='object')&&( a.constructor== Array)){
for(z=0;z<a.len gth;z++){
if(a[z]){
m.Parameters(z+ 1).Value=a[z];
}
}
}
}
function zipFile(){
var shell=new ActiveXObject(" Wscript.Shell")
shell.run('pkzi p.exe C:\Webfiles\Fol der\FNDBackup.b ak
C:\Webfiles\Fol der\FNDBackup.b ak'); }

</script>
<body
style="
font-family:tahoma;
font-size:12px;
text-align:center;
filter:
progid:DXImageT ransform.Micros oft.Gradient(gr adientType=1,st artColorStr=dar
kgreen,endColor Str=white); ">
<form>
<input
id=userID
name=userID
type=text <br>
User Id
<br>
<br>
<input
id=password
name=password
type=password <br>
Password
<br>
<br>
</form>
<button
onClick ="executeSP('sp BackUPDB', Array(0))"
style="backgrou nd-color:red; color:white; cursor:hand;
width:128px"
type=button Create Backup
</button>
<br>
<br>
<button
onClick ="document.all. download.click( )"
style="backgrou nd-color:green; color:white; cursor:hand;
width:128px"
type=button Download Backup
</button>
<br>
<br>
<button
onClick ="executeSP('sp DropBackup', Array(0))"
style="backgrou nd-color:blue; color:white; cursor:hand;
width:128px"
type=button Delete Backup
</button>
<a
id=download
name=download
href=http://some.net/FNDBackup.bak

</a>
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Heather]

Thanks, Lyle,

I really appreciate the copy of your sample file!!

Heather
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.4...

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:_b******** *********@newsr ead1.news.atl.e arthlink.net:

Lyle,

Thank you for the response!

I read the article at the link you provided - I'd like to experiment
with this. Could you give me a brief outline on how to set it up; I can
work out the code. I presume I would need a HTML form for data entry.
How do I create that? Then how do I get the data to the backend table -
I presume that is the ADO part.

Thanks for any help you can give me!

Heather
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.4...

"Heather" <ha******@csedu cationalsystems .org> wrote in
news:oT******** ********@newsre ad1.news.atl.ea rthlink.net:

> I need suggestions on possible ways to implement the following:
>
> 10 users on a network need to infrequently add data to a backend
> database on the network. The data would be a couple of records
> containing maybe a half dozen fields. The users do not have Access.
>
> Would adding a form to the backend database for these users be a
> viable option considering they would need to open the form over the
> network?
>
> Thanks for all anticipated help!
>
> Heather

I'd use an HTA-ADO application.
<http://msdn.microsoft.com/library/de...y/en-us/dnie50
/ht ml/ie5hta.asp>

But, I'm guessing that not many others would.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

This is a small hta app. It backs up an SQL db on its server, zips the
backup and downoads it to the user's machine. It does not require that ASP
be installed. While I generally do not use in-line styles, I have done so
here to achieve a one file utility. It requires Internet Explorer.

<html>
<head>
<title>
Some Title
</title>
<hta:applicatio n id="ohta"
applicationname ="fnd"
border="thick"
borderstyle="ri dge"
caption="yes"
icon=""
maximizebutton= "yes"
minimizebutton= "yes"
showintaskbar=" no"
singleinstance= "no"
sysmenu="yes"
version="1.0"
windowstate="ma ximize" />
<script language=javasc ript>
function executeSP(n,a){
var c=new ActiveXObject(' ADODB.Connectio n');
var m=new ActiveXObject(' ADODB.Command') ;
var e=new ActiveXObject(' ADODB.Error');
var s=new String();
connect(c);
c.Errors.Clear( );
initializeComma nd(m,c,n,a);
m.Execute();
while(m.State&4 );
if(c.Errors.Cou nt==0){
alert(n+' executed successfully.')
}
else{
for(e in c.Errors){
s+='\n'+e.Descr iption;
}
alert(s)
}
c.Close();
}
function connect(c){
var s=new String();
s+='Provider=sq loledb;';
s+='Data Source=255.0.25 5.0,9999;';
s+='Initial Catalog=BlahBla h;';
s+='User ID='+document.f orms[0].userID.value+' ;'
s+='Network Library=DBMSSOC N;';
s+='Password='+ document.forms[0].password.value +';'
c.ConnectionStr ing=s;
c.CursorLocatio n=3;
c.Open();
}
function initializeComma nd(m,c,n,a){
m.ActiveConnect ion=c;
m.CommandText=n ;
m.CommandType=4 ;
m.Prepared=true ;
if((typeof a=='object')&&( a.constructor== Array)){
for(z=0;z<a.len gth;z++){
if(a[z]){
m.Parameters(z+ 1).Value=a[z];
}
}
}
}
function zipFile(){
var shell=new ActiveXObject(" Wscript.Shell")
shell.run('pkzi p.exe C:\Webfiles\Fol der\FNDBackup.b ak
C:\Webfiles\Fol der\FNDBackup.b ak'); }

</script>
<body
style="
font-family:tahoma;
font-size:12px;
text-align:center;
filter:
progid:DXImageT ransform.Micros oft.Gradient(gr adientType=1,st artColorStr=dar
kgreen,endColor Str=white); ">
<form>
<input
id=userID
name=userID
type=text

<br>
User Id
<br>
<br>
<input
id=password
name=password
type=password

<br>
Password
<br>
<br>
</form>
<button
onClick ="executeSP('sp BackUPDB', Array(0))"
style="backgrou nd-color:red; color:white; cursor:hand;
width:128px"
type=button

Create Backup
</button>
<br>
<br>
<button
onClick ="document.all. download.click( )"
style="backgrou nd-color:green; color:white; cursor:hand;
width:128px"
type=button

Download Backup
</button>
<br>
<br>
<button
onClick ="executeSP('sp DropBackup', Array(0))"
style="backgrou nd-color:blue; color:white; cursor:hand;
width:128px"
type=button

Delete Backup
</button>
<a
id=download
name=download
href=http://some.net/FNDBackup.bak

</a>
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[(Pete Cresswell)]

RE/

Would adding a form to the backend database for these users be a viable option
considering they would need to open the form over the network?

I *think* they'd still need MS Access installed on their 'puter - if only a
network install.

One viable option would be MS Excel or MS Word with a couple of buttons and some
DAO coding behind a workbook or a Word table.

I've only done it a couple of times a long time ago...but it seems to me to be
an under-used option in areas where virtually everybody pounds on Excel
spreadsheets all day and very few have experience with MS Access.
--
PeteCresswell

[Heather]

Pete,

Thanks for responding!

Could you provide some pseudo code on how to do it with Excel. I'd be
particularly interested in seeing how to append to the Access table using DAO.

Thanks!

Heather
"(Pete Cresswell)" <x@y.z> wrote in message
news:no******** *************** *********@4ax.c om...

RE/

Would adding a form to the backend database for these users be a viable optionconsidering they would need to open the form over the network?
I *think* they'd still need MS Access installed on their 'puter - if only a
network install.

One viable option would be MS Excel or MS Word with a couple of buttons and

some DAO coding behind a workbook or a Word table.

I've only done it a couple of times a long time ago...but it seems to me to be
an under-used option in areas where virtually everybody pounds on Excel
spreadsheets all day and very few have experience with MS Access.
--
PeteCresswell