Last post Apr 30, 2009 12:37 AM by Mohanet
Apr 28, 2009 06:28 AM|Mohanet|LINK
I want, can we insert the data from client to server as sql server in ms access.
I need to access the server ms access file via client connection string.
Is it possible? if yes how?
Apr 28, 2009 09:34 AM|jpinquie|LINK
Yes you can... if your database file can be reached by the web server. Copy this following connection string on your server if you use standard security on your MS Access file (no password) :
Hope it helps !
Apr 29, 2009 12:37 AM|Mohanet|LINK
Sir, I can not clear or its dont work.
I need to upload the table from client to server ms access file as like as sql server database.
Is it possible. how? where is declare ip address of server. If give the like this
"Provider=Microsoft.Jet.OLEDB.4.0;Server=//192.168.1.129;Data Source=c:/queries/pmr.mdb;User Id=admin;Password="
It gives '\\192.168.1.129\c:\queries\pmr.mdb' is not a valid path error. or could not installable ISAM.
Please suggestion clearly.
Apr 29, 2009 02:36 AM|jpinquie|LINK
Please try :
without "server", and let me know the issue.
Apr 29, 2009 03:50 AM|hans_v|LINK
Access is not really designed for this. It's very hard to get this working, due to all kinds of permission problems, firewalls etc...
Apr 30, 2009 12:37 AM|Mohanet|LINK
but I got Internet Server. I search the solution