Remote data base with ms access

[Balaji_DP]

hi,

i want to insert a data in to a remote data base using ms access. i have a ftp server.

can you help me how to do this.?

[Balaji_DP]

can anyone help me on this topic?

[Balaji_DP]

data base i used ms access data base,

to insert the data using database toolkit.

like a local machine we can create a data base using ms access and using database toolkit we can able to insert the data. so, using the same method from local machine ,example i have a server ip in that  a database like http://192.168.1.22/database.mdb,

how to insert the data on above server address? 

[Rajmohan]

Hi Balaji,,,i need help ,,now i have done MS ACCESS in local pc using OLE DB or ODBC...but i cant interface remote PC MS ACCESS..pls if you know can u tell me how can access it...thanks

---

[NarayananK]

When you say "Remote" I believe the MS Acess database file is present on a computer connected through Ethernet Network. If this is the case, then configure the ODBC to point to the Database File present on the Remote Computer.

Then you could run the same queries use for INSERT INTO Database.

Do refer to the Database Connectivity Toolkit User Manual.

[Rajmohan]

Thanks for replay.....that things...i dont have idea..in local pc i know how to create dsn but for remote pc i dont have idea???...in odbc  how can create DSN for remote pc(its connected on Ethernet)...that steps ,i need to know? ...pls

[NarayananK]

Refer Attached PNG

Click on the "Network" button while selecting the http://192.168.1.22/database.mdb, file.

[Rajmohan]

Thanks to replay me,,,,if this way i have to connect means,that MSACCES should be shared with network....so user can easily (directly see or edit ) the Ms access database.....is it correct?...i did it like that before...but i am expecting to do it without share folder or share file....

[NarayananK]

If security is the concern, then would suggest use appropriate user name and password for your Data Source Configuration. Refer Attached screen click on the "Advance" button to set the user name and password later to be used with the Database Open Connection VI.

Not any other method which i have come across, I leave it to the board to suggest if available.

[Rajmohan]

Thanks for all suggedtion.....i actually didt get what i expect...but you are very supportive to my query.....