How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)

[Bombus]

Hello.

I have two different types of MS Access databases (A.mdb). One is on a server, and several databases at clients (B.mdb).

Now I want to develop some code that can extract data from the server (A.mdb) table directly to a client (B.mdb) table through internet just by pressing buttons.

I also want the clients (B.mdb) to update the server (A.mdb) table.

I have no experience with this, but I wonder if it is possible to use winhttp or winsock to do this?

Well, I have to start someplace.

I hope to be able to communicate directly between A.mdb and B.mdb just by entering right values and by pressing command buttons in B.mdb.

Any good suggestions what to use and were to start?

Bombus

[PEB]

And it's without using VPN? Just using WEB protocols?

Maybe it's question of connection settings when you link the tables, or using ODBC...

When you use ODBC and on the Server you have a database like PostgesQL or MySQL you can set the server and the ports!

But I've reelly never done it!

Please tell us more about this connection when you've done it!

Thanks! :)

[Bombus]

Hello.

It is not Virtual Private Network, just ordinary WEB. As I said, I have no experience with this ahead, only using ASP script on server. That works fine for a WEB browser. But I want to update my tables from the client MS Access database. In some way I want to run a query (or??) against A.mdb and use the result to update the right table in B.mdb.

I want to start the query (or?) form B.mdb, and receive the result back to B.mdb from A.mdb and update the table in B.mdb.

It ought to be easy, but I have not succeeded to find the right way to do it so far.

Bombus

[Bombus]

I can´t see how I can connect a remote MS Access database on the WEB by using ODBC and IP. Any good suggestions for how to do that? If possible, do somebody know how to do it? May be I need a database server???

How can I solve this. I suppose it should be possible to find some smart trick?

[PEB]

By ODBC ... I've tried only with POstgesQl and MySQL databases not with Ms Access

But maybe in the net you can do search : WEB ODBC driver for MS Access

http://www.microsoft.c om/technet/prodtechnol/office/office2000/maintain/operate/viacc.mspx
http://rmijdbc.objectw eb.org/Access/access.html
http://www.webwizguide .com/asp/faq/ODBC_drivers.as p
http://www.lansa.com/support/tips/e0005.htm
http://www.thescripts. com/forum/thread425985.ht ml
http://www.adobe.com/devnet/security/security_zone/asb99-09.html
http://www.macnn.com/articles/06/01/09/odbc.driver.for .ms.access/

Hope that will give you some directions!

[PEB]

http://www.samspublish ing.com/articles/article.asp?p=2 3327&rl=1

[Bombus]

Thanks a lot for the help.

I have found some samples and descriptions that I will try. Somebody said it was hard or even impossible with MS Access, but works find with MySQL. But I am not sure since I found some god information on Microsoft telling how to do it. I will try to test this on my own MS Access databases now, and hopefully it will work:-)

[PEB]

Please tell us if it works! :) This is a good experience! :)

[Bombus]

Hello.

I haven't succeeded yet. But I'm working with it when times allow. So still I do not have any good news.

However I have a close related question.

1) From my server on the web, I have an ASP script, creating records. Is it possible to import this records table directly by the URL without manually saving them to a file first.

2) I have a MS Access 2003 Form with a Microsoft Web Browser window where I display "this file": the output from the ASP script. Is there any way my application could read the "file" displayed in the (Active-x) WEB Browser and be used as input to SQL insert statement?

Any smart idea?

Bombus

[PEB]

Hi,

Good courage!

Access can read files but not from the Web only on local machine I suppose....

When you open Access from the server you can manipulate your data as you want!

:)

[Bombus]

I suppose you are right. However I found this:

ADO URL Connections
ADO 2.5+ allows you to open up a Recordset based on XML returned from an ASP file over HTTP. This feature doesn't use RDS at all.

ADO Recordset
To get records from a remote database

oRs.Open "http://myServer/AuthorsGetBySta te.asp?state=CA ",, _
adOpenStatic, adLockBatchOpti mistic

But no success so far.

The situation is that We have a lot of customers that need updates from the Access mdb file on the server. We had hoped they could download the updates from the server themselves. One of my colegues said we could use WINHTTP, but we don’t know how to do it. Yet :-))

But I have succeeded in showing the file in a Microsoft Web Browser. So if there exist a way to copy the Access browser window to a file I'll manage!

I will come back later.

[PEB]

Is your server has a Static IP? Here I've tried in the local network to connect using the static adresses of the machine and it's works!

But in the Internet you can't share a space from your server as it is here!

It doesn't matter just as an idea!

:)

[Bombus]

Hello PEB.

I just want to inform you I have solved part of my problem by using ASP and WINHTTP. I just had to mark Microsoft WINHTTP 5.1 under reference. Than I could use WINHTTP to run the ASP on my server. Then I got all the information I needed to do the update in the Client Access :-) It worked just perfect!

Most info I needed I found on http://msdn.microsoft. com/library/default.asp?url =/library/en-us/winhttp/http/winhttprequest. asp

So I'm happy with this solution!

Bombus

[PEB]

Super! It's great!

Thank you to communicate it with the forum and me! :)

Have a nice day!

:)

[dak]

Hi Bombus,
Its really great to see u work on the data extract from server to client, similar think i am trying it out. But i am trying in java, using dwr and the database is mysql. i will be using that in google gears for creating my web application offline mode...... can u please help..

thanks
dak.

Thanks a lot for the help.

I have found some samples and descriptions that I will try. Somebody said it was hard or even impossible with MS Access, but works find with MySQL. But I am not sure since I found some god information on Microsoft telling how to do it. I will try to test this on my own MS Access databases now, and hopefully it will work:-)