05-26-2011 12:19 PM
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.?
05-27-2011 12:12 PM
can anyone help me on this topic?
05-27-2011 12:18 PM
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?
12-29-2011 05:31 AM
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
12-29-2011 06:06 AM
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.
12-29-2011 06:21 AM
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
12-29-2011 06:41 AM
Refer Attached PNG
Click on the "Network" button while selecting the http://192.168.1.22/database.mdb, file.
12-29-2011 10:26 PM - edited 12-29-2011 10:33 PM
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....
12-29-2011 10:44 PM
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.
12-29-2011 11:00 PM
Thanks for all suggedtion.....i actually didt get what i expect...but you are very supportive to my query.....