Sql server update via asp with access db on remote machine

[Eddy Princen]

Hello, can anyone give me some hints about updating a sql server database
with MsAccess database info on a remote desktop machine,

the idea is to write an access application to gather some data and then
update the sql server via asp-scripts on a webserver with sql behind it.
I've already worked with asp and sql-server but the trick now is to get a
connection via asp to the access database on the desktop machine ?

Does anyone have ideas or direct me to some websites concerning this issue ?

Thanks in advance

Princen Eddy
Cierob International Tech Support

[Bob Barrows]

Eddy Princen wrote:

> Hello, can anyone give me some hints about updating a sql server
> database with MsAccess database info on a remote desktop machine,
>
> the idea is to write an access application to gather some data and
> then update the sql server via asp-scripts on a webserver with sql
> behind it. I've already worked with asp and sql-server but the trick
> now is to get a connection via asp to the access database on the
> desktop machine ?
>
> Does anyone have ideas or direct me to some websites concerning this
> issue ?
>
> Thanks in advance
>
> Princen Eddy
> Cierob International Tech Support

Why bother with the asp application? Just link the SQL Server tables into
your Access database and have your Access application update them directly.
There will be fewer security details to worry about, especially if this is
an intranet application. Follow up with an Access newsgroup for details.

If you must use an asp application for this, then start here:
[url]http://www.aspfaq.com/show.asp?id=2168[/url]
and
[url]http://www.aspfaq.com/show.asp?id=2126[/url]

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[eddy princen]

thanks Bob I'll let you know if it works.
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> schreef in bericht
news:eoXxoi0sDHA.1740@TK2MSFTNGP12.phx.gbl...

> Eddy Princen wrote:

> > Hello, can anyone give me some hints about updating a sql server
> > database with MsAccess database info on a remote desktop machine,
> >
> > the idea is to write an access application to gather some data and
> > then update the sql server via asp-scripts on a webserver with sql
> > behind it. I've already worked with asp and sql-server but the trick
> > now is to get a connection via asp to the access database on the
> > desktop machine ?
> >
> > Does anyone have ideas or direct me to some websites concerning this
> > issue ?
> >
> > Thanks in advance
> >
> > Princen Eddy
> > Cierob International Tech Support

>
> Why bother with the asp application? Just link the SQL Server tables into
> your Access database and have your Access application update them

directly.

> There will be fewer security details to worry about, especially if this is
> an intranet application. Follow up with an Access newsgroup for details.
>
> If you must use an asp application for this, then start here:
> [url]http://www.aspfaq.com/show.asp?id=2168[/url]
> and
> [url]http://www.aspfaq.com/show.asp?id=2126[/url]
>
> HTH,
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>