Re: Access DB Issues - Again

On Mon, 22 May 2006 15:04:01 -0500, "Bob Palank" <bob@xxxxxxxxx> wrote:

¤ Remote server hosts a .mdb file but the client cannot access the DB through
¤ VB.Net Express 2005.
¤
¤ My Assumptions:
¤ 1. One can use VB.Net Express 2005 to write a client resident application to
¤ access an .mdb file living on a remote server.

Yes, assuming there is some sort of network path available.

¤ 2. No Microsoft Access code elements need to reside on the remote server
¤ except the *.mdb file.

Correct.

¤ 3. On the remote server, permissions need be set so that anyone can have
¤ read access to that Access database.

If the database is being modified then full access is required to the folder where the database
resides in order to create/update/delete the corresponding .LDB file.

¤ 4. The remote server needs to host the .Net Framework 2.0

False. Access is a file based database. The database engine runs on the client.

¤ If the assumptions are true, the local error message
¤
¤ Me.AuthorsTableAdapter.Fill(Me.PubsDataSet.authors)==>Could not find
¤ installable ISAM does not make sense to me.
¤

Either the Jet database engine components are not correctly installed on the client or your
connection string is invalid. You may want to post some code.


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: 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)
  • Re: Remote Server shell command
    ... which is part of the Windows scripting facilities and ... I have a new Access 2002 client app ... >data stored in a different .mdb file on a remote server. ...
    (microsoft.public.access.modulesdaovba)