locked
MS Access Client - Server Connection RRS feed

  • 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

    Tuesday, April 28, 2009 6:28 AM

Answers

All replies

  • 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 !

    Tuesday, April 28, 2009 9:34 AM
  • 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

    Wednesday, April 29, 2009 12:37 AM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 29, 2009 2:36 AM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 29, 2009 3:50 AM
  • User-1153713893 posted

     

    Thanking You

    but I got Internet Server. I search the solution

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 30, 2009 12:37 AM