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

Show quoteHide quote

Show quote Hide quote Thanks. Looks very complicated.
Dave

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 <dcw***@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:
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

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


Show quoteHide quote

¤ 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)

Can we use Shell to write file properties
VB6 support and beyond
How to manage a large dictionary of words?
Re: How to get the File Properties
Latest VB6 Cumulative Update?
GDI+ and resizing a PictureBox
KBasic
Callback function
Best Approach (psuedocode) for summing structure element values
Flash 10 Control Problem with VB6