Hi everyone
My question is how to retrieve and update records in a remote Access
db sitting on a remote web host using a VB application. While I can do
this with SQL Server I could do with some general pointers on the
technique(s) used to do the same with Access. Do you have to get the
recordset via an asp page using the appropriate SQL string and if so
can updated records be returned back to the remote db via the same
means. Any comments to steer me in the right direction much
appreciated.
Dave

A Jet engine (often named Access) is no data base server, it is a database 
file (it has for instance no IP address).

It is possible to access a Jet engine over Internet using a webservice .

Assuming it is for VB6 then this can be a possibility.

This is a link to the version 3 SOAP SDK, be aware that support has ended in 
2005

http://www.microsoft.com/downloads/details.aspx?familyid=c943c0dd-ceec-4088-9753-86f052ec8450&displaylang=en

Be aware it is for sure no easy job doing this direct with SOAP

Success

Cor

"KiwiKid" <dcward@xtra.co.nz> wrote in message 
news:36c4ad88-518b-412f-8024-55dfdf034609@n19g2000prf.googlegroups.com...
> Hi everyone
> My question is how to retrieve and update records in a remote Access
> db sitting on a remote web host using a VB application. While I can do
> this with SQL Server I could do with some general pointers on the
> technique(s) used to do the same with Access. Do you have to get the
> recordset via an asp page using the appropriate SQL string and if so
> can updated records be returned back to the remote db via the same
> means. Any comments to steer me in the right direction much
> appreciated.
> Dave
> 

On Aug 20, 4:57=A0am, "Cor" <Notmyfirstn...@planet.nl> wrote:
> A Jet engine (often named Access) is no data base server, it is a databas=
e
> file (it has for instance no IP address).
>
> It is possible to access a Jet engine over Internet using a webservice .
>
> Assuming it is for VB6 then this can be a possibility.
>
> This is a link to the version 3 SOAP SDK, be aware that support has ended=
 in
> 2005
>
> http://www.microsoft.com/downloads/details.aspx?familyid=3Dc943c0dd-cee..=
..
>
> Be aware it is for sure no easy job doing this direct with SOAP
>
> Success
>
> Cor
>
> "KiwiKid" <dcw...@xtra.co.nz> wrote in message
>
> news:36c4ad88-518b-412f-8024-55dfdf034609@n19g2000prf.googlegroups.com...
>
>
>
> > Hi everyone
> > My question is how to retrieve and update records in a remote Access
> > db sitting on a remote web host using a VB application. While I can do
> > this with SQL Server I could do with some general pointers on the
> > technique(s) used to do the same with Access. Do you have to get the
> > recordset via an asp page using the appropriate SQL string and if so
> > can updated records be returned back to the remote db via the same
> > means. Any comments to steer me in the right direction much
> > appreciated.
> > Dave- Hide quoted text -
>
> - Show quoted text -

Thanks. Looks very complicated.
Dave

"KiwiKid" <dcward@xtra.co.nz> schrieb im Newsbeitrag
news:36c4ad88-518b-412f-8024-55dfdf034609@n19g2000prf.googlegroups.com...

> My question is how to retrieve and update records in
> a remote Access db sitting on a remote web host
> using a VB application.
Do you have control over the Remote-Host -
what OS does it run?
Where is it hosted (if it's reachable over public internet) -
InHouse - or some Hoster?

Olaf

On Thu, 19 Aug 2010 08:52:58 -0700 (PDT), KiwiKid <dcward@xtra.co.nz> wrote:

� Hi everyone
� My question is how to retrieve and update records in a remote Access
� db sitting on a remote web host using a VB application. While I can do
� this with SQL Server I could do with some general pointers on the
� technique(s) used to do the same with Access. Do you have to get the
� recordset via an asp page using the appropriate SQL string and if so
� can updated records be returned back to the remote db via the same
� means. Any comments to steer me in the right direction much
� appreciated.
� Dave

The technology for this sort of implementation was called RDS and you would use the MSRemote
Provider:

http://support.microsoft.com/kb/240838

Another solution would be to create an intermediate data access mechanism such as a web service.


Paul
~~~~
Microsoft MVP (Visual Basic)

KiwiKid wrote:
> Hi everyone
> My question is how to retrieve and update records in a remote Access
> db sitting on a remote web host using a VB application. While I can do
> this with SQL Server I could do with some general pointers on the
> technique(s) used to do the same with Access. Do you have to get the
> recordset via an asp page using the appropriate SQL string and if so
> can updated records be returned back to the remote db via the same
> means. Any comments to steer me in the right direction much
> appreciated.
> Dave

It is certainly possible.

Here's one way:
http://www.carlprothman.net/Default.aspx?tabid=92

You'll have to modify the connection string to suit Jet/Access.

HTH

"KiwiKid" <dcward@xtra.co.nz> wrote in message 
news:36c4ad88-518b-412f-8024-55dfdf034609@n19g2000prf.googlegroups.com...

> My question is how to retrieve and update records in a remote Access
> db sitting on a remote web host using a VB application. While I can do
> this with SQL Server I could do with some general pointers on the
> technique(s) used to do the same with Access. Do you have to get the
> recordset via an asp page using the appropriate SQL string and if so
> can updated records be returned back to the remote db via the same
> means. Any comments to steer me in the right direction much
> appreciated.

I think this is the best pointer I can give you: This is a TERRIBLE idea. 
For dealing with a database over the Web, you should really use a true 
RDBMS. MS SQL Server, Oracle, MySQL, whatever. Just not Access. And I'm not 
an Access basher; I love Access. But it's not the right tool for this job. 

"Jeff Johnson" <i.get@enough.spam> wrote in message 
news:i4mf9n$p1h$1@news.eternal-september.org...
> I think this is the best pointer I can give you: This is a TERRIBLE idea. 
> For dealing with a database over the Web, you should really use a true 
> RDBMS. MS SQL Server, Oracle, MySQL, whatever. Just not Access. And I'm 
> not an Access basher; I love Access. But it's not the right tool for this 
> job.

Jeff Johnson is correct, see this article:

What are the limitations of MS Access?
http://databases.aspfaq.com/database/what-are-the-limitations-of-ms-access.html

Jeff,

With a SOAP web service it is not hard to do. However, using SOAP from the 
SDK is almost a kind of (a word I don't put in a newsgroup, I hope you 
understand it).

You also use Nxt, and with that creating and consuming a web service is a 
piece of cake. That is why Paul and I standard answer in forums for this 
question Web service.

In fact is a web service of course nothing more than an asp(x) web 
application without a web page, and I assume that you have used Access also 
once in asp or/and aspx.

In my idea are most given answers here in fact based on web services which 
were before SOAP standards clumsy.

But I agree since SQL Express is freeware and support disconnected endless 
connections (the max data use is 4Gb) is it a little bit out of sense to use 
Jet if you start new with a database (beside that we don't know how long it 
really will be supported. Maybe Paul can shine his light on that one, I am 
also curious about that)

But suppose you have a large  Jet (Access) database in a classic ASP 
application, then it is not easy to switch the database if you want to get 
information at remote places, if you want to include the information in an 
existing windows forms desktop solution.

In my idea can than all given answers here be a solution.

Cor


"Jeff Johnson" <i.get@enough.spam> wrote in message 
news:i4mf9n$p1h$1@news.eternal-september.org...
> "KiwiKid" <dcward@xtra.co.nz> wrote in message 
> news:36c4ad88-518b-412f-8024-55dfdf034609@n19g2000prf.googlegroups.com...
>
>> My question is how to retrieve and update records in a remote Access
>> db sitting on a remote web host using a VB application. While I can do
>> this with SQL Server I could do with some general pointers on the
>> technique(s) used to do the same with Access. Do you have to get the
>> recordset via an asp page using the appropriate SQL string and if so
>> can updated records be returned back to the remote db via the same
>> means. Any comments to steer me in the right direction much
>> appreciated.
>
> I think this is the best pointer I can give you: This is a TERRIBLE idea. 
> For dealing with a database over the Web, you should really use a true 
> RDBMS. MS SQL Server, Oracle, MySQL, whatever. Just not Access. And I'm 
> not an Access basher; I love Access. But it's not the right tool for this 
> job.
>
> 

On Sat, 21 Aug 2010 13:02:16 +0200, "Cor" <Notmyfirstname@planet.nl> wrote:

� But I agree since SQL Express is freeware and support disconnected endless 
� connections (the max data use is 4Gb) is it a little bit out of sense to use 
� Jet if you start new with a database (beside that we don't know how long it 
� really will be supported. Maybe Paul can shine his light on that one, I am 
� also curious about that)

Jet is dead, but Access lives on with ACE. Still, I wouldn't recommend using the obsolete RDS
technology. Access is fine for small implementations via a web service but you want to limit
concurrent usage.
 

Paul
~~~~
Microsoft MVP (Visual Basic)