Lat/Lon to MP and Adress back to Access

Hallo

I have an Access-Table with latitude and longitude and want to get back the Postcode, the City and the Streetname form MapPoint to use ist in my project. Can anyone help me with a simple VB-Code?

thanks

Ralf

Now I found the Article#50. I built the source code into my Progamm and it works well. However the
speed is very slow, if no direct hit is landed. Does anyone know a
possibility of increasing the speed? Thanks for each assistance.
Ralf

Hello ,

i have a similiar problem.
i have an ACCESS (mdb) table with info and I want to write the longitude and latitude of each place into this table using VB.

i can already calculate the Long/Lat but how do i write it back into the table?

please help,

Hi,

I have written a program which gets the Latitude, Longitude from a
given address. It also corrects bad choice from MP. You can download it from the MP-magazine.

http://www.mp2kmag.com/articles.asp?ArticleID=98

Rainer

Rainer,

10x for your help

schönen Tag noch :!: ,

Ran

Rainer , I write to you again.

Is it possible only to get the code part in which you communicate with the Access DB?

I am not interested in the whole Geocoding story at the moment.
I just want to see how can i export the LONG/LAT info to my Access table from every pushpin!

10x

Hi Ran,

dim db as database, rs as recordset
set db=currentdb
set rs=db.openrecordset("DeineTabelle")

rs.edit
rs!DeinFeld=Lat
rs!DeinFeld=Lon
usw.
rs.update

ready

In my application I take the lat/lon from a given access-table and write back the address - so I run a do until rs.eof Schleife.

If you need more help then post again.

Ralf

Ralf,

fisrt thanks, but maybe I should mention that I work with VB6 and that my mdb file should stay in background (i don't need it to be open, in fact i need it to stay closed).

1. so how do I open it in background?
2. The rs.edit is showed as an error (there is no such atribute as edit in my list)

is it possible that your code was for .NET or maybe I passed something...

thanks again,
Ran