Hello

I want to ask how to connect a vb.net window client application to a remote
MS Access databae which is located on a server?
How to set the connection string in order to do so?

Thank you

Chase,

You will have to create a shared folder and set that on every individual
computer (and give those using that rights in that shared folder)

An Jet Database is not a database server it is more a databasefile.

I hope this helps,

Cor

wind wrote:

> Hello
>
> I want to ask how to connect a vb.net window client application to a
> remote MS Access databae which is located on a server?
> How to set the connection string in order to do so?

MS Access doesn't have a 'server' service, it's just a driver which
accesses a file. So if you want to access an .mdb file on a server, you
have to share that .mdb file using a shared folder, map that folder to
a drive letter (or use \\servername\folder\mydatabase.mdb) and then use
that drive + foldername to specify where the .mdb file is located.

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

On Fri, 23 Dec 2005 11:41:29 +0800, "wind" <chase@wind> wrote:

¤ Hello
¤
¤ I want to ask how to connect a vb.net window client application to a remote
¤ MS Access databae which is located on a server?
¤ How to set the connection string in order to do so?

It's no different when accessing a file on a network share. Just use the UNC naming convention for
the path to the file as Frans mentioned.

Also keep in mind that all users accessing the database will require full permissions to the folder
where the database file is located.


Paul
~~~~
Microsoft MVP (Visual Basic)

Thanks all

But I have a problem, that is, after I mapped the drive to local pc and
access it, every time I read a record, it will automatically download the
whole .mdb file once. And every time I save a record, it will automatically
upload the whole .mdb file once. This is a big big problem. So I don't know
how to do.


"Paul Clement" <(E-Mail Removed)>
???????:(E-Mail Removed)...
> On Fri, 23 Dec 2005 11:41:29 +0800, "wind" <chase@wind> wrote:
>
> ¤ Hello
> ¤
> ¤ I want to ask how to connect a vb.net window client application to a
> remote
> ¤ MS Access databae which is located on a server?
> ¤ How to set the connection string in order to do so?
>
> It's no different when accessing a file on a network share. Just use the
> UNC naming convention for
> the path to the file as Frans mentioned.
>
> Also keep in mind that all users accessing the database will require full
> permissions to the folder
> where the database file is located.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Wind

You say up and download, do you mean that you want to do from a webpage
(aspx). That you can forget if it is outside your domain.

Cor

Cor

no. i mean from a window client application. After i mapped the local drive
to a remote server, i can set the connect string as "Data
Source=\\folder\xxx.mdb". But it doesn't like i map to a local area network,
it need to upload and download the whole file when i read and save a record
everytime.
Someone said I can only setup a VPN in order to prevent this problem, is it
correct?
And will it be the problem that the server is only a FTP server?

Thanks
Wind


"Cor Ligthert [MVP]" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:%(E-Mail Removed)...
> Wind
>
> You say up and download, do you mean that you want to do from a webpage
> (aspx). That you can forget if it is outside your domain.
>
> Cor
>

wind wrote:

> Cor
>
> no. i mean from a window client application. After i mapped the local
> drive to a remote server, i can set the connect string as "Data
> Source=\\folder\xxx.mdb". But it doesn't like i map to a local area
> network, it need to upload and download the whole file when i read
> and save a record everytime.
> Someone said I can only setup a VPN in order to prevent this problem,
> is it correct?
> And will it be the problem that the server is only a FTP server?

The driver for access, the code that actually does the 'db logic' is
running on the client pc. The data is in a file, and it reads the
'file' to be able to perform the db operations. If you don't want that,
the only option you have is to create a service on the server which
performs the db actions and sends the results to the client. This is
easily done using remoting or by creating a webservice.

FB

>
> Thanks
> Wind
>
>
> "Cor Ligthert [MVP]" <(E-Mail Removed)>
> ¼¶¼g©ó¶l¥ó·s»D:%(E-Mail Removed)...
> > Wind
> >
> > You say up and download, do you mean that you want to do from a
> > webpage (aspx). That you can forget if it is outside your domain.


--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

Wind,

I agree with Frans where I would because it simplicity go for the
webservice.

Your alternative is the SQL Server Express, be aware that it is limited in
use and that it his hard to maintenance as databaseserver withouth the SQL
full tools. (I saw that there is an upcomming tool for that on this page)

http://msdn.microsoft.com/sql/express/

I hope this helps,

Cor

But I have finished coding... If i use remoting or webservice as FB mention,
do i need to do much changes? I have no idea what they are.

Thanks
Wind


"Cor Ligthert [MVP]" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:(E-Mail Removed)...
> Wind,
>
> I agree with Frans where I would because it simplicity go for the
> webservice.
>
> Your alternative is the SQL Server Express, be aware that it is limited in
> use and that it his hard to maintenance as databaseserver withouth the SQL
> full tools. (I saw that there is an upcomming tool for that on this page)
>
> http://msdn.microsoft.com/sql/express/
>
> I hope this helps,
>
> Cor
>