Accessing .mdb data from a remote computer on a non asp application

Hi,

I have developed a small application that is using a MSAccess DB.
the problem is that it was developed on a machine where the
application and the DB are both located.
now it needs to be change that the application will be able to run on
any other machine (using \\ syntax on the run command- not a problem)
using the DB located on a static-different machine.

for this purpose I need to create a Remote Connection from my
application to the machine that holdes the DB.

I have searched for code example over the net and the only solution I
have fount which fits to my application is changing the connection
string from:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\\Cutomers.mdb";
to:
Provider=MS Remote;Remote Server=noa-second;Remote
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Cutomers.mdb;"
("noa-second" is the machine where the MDB file is located)

when I use the second one (with the remote) I get the error: "business
object cannot be created"

adding http:// to the Remote Server sends error "count not connect to
server" what make sense because it is not an asp application (it is a
windows form one).

trying to leave the original connectionstring and change the Source to
\\noa-second\c$...(or c:) doesn't hellp also and shows the error "not
a valid file name" and after looking in the error details I saw that c:
\ have been added to the start of the link I wrote.

Please Help me...

.

Relevant Pages

  • Re: SMTP Errors in Event log
    ... It could however also be networking problems on the remote side. ... > 1) Message delivery to the host 'XXX.XXX.XXX.XXX' failed while delivering ... > the remote domain 'XXXXXXX.com' for the following reason: The connection ... > the remote domain 'XXXX.com' for the following reason: The remote server ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • Re: Detecting Disconnect on TCP Socket
    ... > really depends on how remote end behaves. ... If remote server is slow - you ... system has Shutdown the connection. ... The first callback won't be even be made for 5 ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Will killing tty stop remote jobs started by that session?
    ... That rsync is between two remote servers...not my PC. ... behind a 1Mbps connection), so IF my closing my PC's connection to the ... remote server does stop the job, I REALLY don't want to have wasted ...
    (comp.os.linux.misc)
  • Re: Access DB Issues - Again
    ... One can use VB.Net Express 2005 to write a client resident application ... access an .mdb file living on a remote server. ... No Microsoft Access code elements need to reside on the remote server ... you can write the connection strings yourself. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access DB Issues - Again
    ... Please define "remote" in this context. ... application to access an .mdb file living on a remote server. ... Can you access the remote DB file using Access on the client machine? ...
    (microsoft.public.dotnet.languages.vb)