Re: connect remote Access database

On Fri, 23 Dec 2005 23:00:37 +0800, "wind" <chase@wind> wrote:

¤ 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.
¤

First, I don't believe it's necessary to map a drive letter to the path, unless it's for
establishing credentials with the remote resource.

Second, the .mdb does not need to be downloaded. You can access it directly over the network from
the client. You need to make certain that you have full permissions to the folder resource.


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: padding text field with blank in MS Access vs OLEDB Jet 4.0 -the solution
    ... Seems like MDB files can support both fixed len char fields as well as ... ONLY specify TEXT which is a varchar. ... ¤ text are NOT padded with blanks. ... programatically created MDB file in access and, just as before, add "HI" ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access DB Issues - Again
    ... ¤ VB.Net Express 2005. ... One can use VB.Net Express 2005 to write a client resident application to ... access an .mdb file living on a remote server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: connect remote Access database
    ... My server is a Linux server with user name and password. ... > ¤ Thanks all ... upload the whole .mdb file once. ... > establishing credentials with the remote resource. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: connect remote Access database
    ... upload the whole .mdb file once. ... > ¤ Hello ... MS Access databae which is located on a server? ... > where the database file is located. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO connection with MDW file
    ... ¤ I need to open a MDB file for my report program. ... However, there is one MDW ... Everytime I tried to connect MDB file, ... Could you post the exact error message? ...
    (microsoft.public.vb.database.ado)
Loading