Re: Access DB Issues - Again


"Bob Palank" <bob@xxxxxxxxx> wrote in message
news:QOocg.1024$9M5.381@xxxxxxxxxxx
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.
2. No Microsoft Access code elements need to reside on the remote server
except the *.mdb file.
3. On the remote server, permissions need be set so that anyone can have
read access to that Access database.
4. The remote server needs to host the .Net Framework 2.0
Are all of these assumptions true ?
What am I missing ?

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.

TIA for any help.

Bob



Sure you can. That error can mean a lot of things. Post your code for
connecting to the remote server. That is where some problems occur. If you
haven't checked it out yet, here is a link to ConnectionStrings that can
help too:

http://www.connectionstrings.com/

Click on the Access name and then the type of connection and that will get
you started. As I understand it, the Wizards in Visual Basic 2005 Express
Edition, will not connect to a remote server, just the local server on your
machine. But, you can write the connection strings yourself. There is a lot
of good info on using Access remotely. But, in spite of the silly response
you got from another poster, ( actually a childish response) it really would
be better to use SQL Server for a networked database. But, if that is more
than you need, and you don't anticipate heavy usage of your database, then
Access can do the job.
james


.

Relevant Pages

  • Re: Word looks for another server on the network
    ... and opens an empty document. ... Since the target machine is powered down, the connection cannot be made. ... MacOS eventually gives up and puts up an alert box that says: ... down the remote server numerous times, ...
    (microsoft.public.mac.office.word)
  • Accessing .mdb data from a remote computer on a non asp application
    ... have fount which fits to my application is changing the connection ... ("noa-second" is the machine where the MDB file is located) ... when I use the second one (with the remote) I get the error: ... adding http:// to the Remote Server sends error "count not connect to ...
    (comp.databases.ms-access)
  • Re: 550 5.7.1 Error
    ... The allow computers that successfully authenticate box is already checked. ... >> cause the connection to fail. ... >> I have also tried telnetting to the remote server, and when I do I get ... >> ie not in any of the scanned blocklists, ...
    (microsoft.public.exchange.admin)
  • Re: How does authentication work?
    ... The problem is that when the remote server times out the connection and ... The problem is in the connection ever timing out in the first place. ... re-map one of the drives it would tell us it was not able to as the drive ... drives were mapped with the domain account and the credentials not cached ...
    (microsoft.public.windows.server.general)
  • Re: Using an IP from remote server on home computer
    ... > connection. ... > ports (does not require root access on remote server). ... > tried ssh port forwarding with a Windows ssh client like Putty. ...
    (comp.os.linux.networking)