MS Access Client - Server Connection

Question

User-1153713893 posted

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?

 

Thanking You

Answer 1

User-2054572093 posted

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) :

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

Hope it helps !

Answer 2

User-1153713893 posted

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.

Thanking You

Answer 3

User-2054572093 posted

 Please try :

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.1.129\C$\queries\pmr.mdb;User Id=admin;Password="

without "server", and let me know the issue.

Answer 4

User-1199946673 posted

Access is not really designed for this. It's very hard to get this working, due to all kinds of permission problems, firewalls etc...

http://databases.aspfaq.com/database/why-can-t-i-access-a-database-or-text-file-on-another-server.html
http://forums.asp.net/t/1381295.aspx

Answer 5

User-1153713893 posted

 

Thanking You

but I got Internet Server. I search the solution