Access DB Issues - Again

[Bob Palank]

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.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors)==>Could not find
installable ISAM does not make sense to me.

TIA for any help.

Bob

[aaron.kempf]

mdb is crap upsize it to sql server

duh grow some balls and learn SQL Server; mdb is for jr high kids to
learn databases

[james]

"Bob Palank" <bo*@stlcc.or g> wrote in message
news:QO******** ********@fe02.l ga...

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.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors)==>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 ConnectionStrin gs 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

[Stimphy]

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.
TRUE
2. No Microsoft Access code elements need to reside on the remote
server
except the *.mdb file.
TRUE
3. On the remote server, permissions need be set so that anyone can
have
read access to that Access database.
TRUE to an extent, you could manage the users through the access
database too.
4. The remote server needs to host the .Net Framework 2.0
FALSE each client needs its own framework installed.
Unless its a web application,.
Are all of these assumptions true ?
What am I missing ?

[Cor Ligthert [MVP]]

Bob,

Why don't you use whatever wizard to try.

If it is working for you than the only thing you have to check what is
different with you and the users.

Just as idea

Cor

"Bob Palank" <bo*@stlcc.or g> schreef in bericht
news:QO******** ********@fe02.l ga...

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.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors)==>Could not find
installable ISAM does not make sense to me.

TIA for any help.

Bob

[Andrew Morton]

Bob Palank wrote:

Remote server hosts a .mdb file but the client cannot access the DB
through VB.Net Express 2005.
(I presume you have previous postings on this subject, but I can't see them,
so sorry if you've gone over some of these points before.)

Please define "remote" in this context. Do you mean it's on the same LAN but
in a different room, or...?
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.
AFAIK, it needs access as if it was a file on the local computer - as in
File And Printer Sharing For Windows Networks. Think security holes.
2. No Microsoft Access code elements need to reside on the remote
server except the *.mdb file.
Seems reasonable, except I have a suspicion that when it's accessed there
may be other temporary files written.
3. On the remote server, permissions need be set so that anyone can
have read access to that Access database.
Full access. To the folder, not just the file.
4. The remote server needs to host the .Net Framework 2.0
What are you suggesting that has to do with accessing a file?
Are all of these assumptions true ?
What am I missing ?

Can you access the remote DB file using Access on the client machine? If
not, write an app to reside on the remote machine to provide the interface
to the DB.

Andrew

[Paul Clement]

On Mon, 22 May 2006 15:04:01 -0500, "Bob Palank" <bo*@stlcc.or g> 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.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors)==>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)

[aaron.kempf]

i would try user='Admin' password = blank in the connection string.

but more importantly-- sql server express ships with visual basic
express.
why aren't you using it?

mdb is obsolete kid

[Bob Palank]

Thanks to all for the ongoing help.
Microsoft Access (.mdb) seems like an excellent database to be used on a server when the file
size is very small and the number of read only hits per day is less than 100. The server cost is
minimal as opposed to the expense of hosting a SQL Server DB.
Another alternative might be SQL Server 2005 Express DataBase.
But first I'd like to get things working with Microsoft Access.

Below is the Connection String from app.config that I'm using along with the error message that results.

=============== =============== =============== =============== =

<add name="CRUD.My.M ySettings.PubsC onnectionString "
connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;
Data Source=some.ser ver.org\ISstude nt\Pubs.mdb;
JetOLEDB:Databa se;
User ID=;
Password=;"
/>
</connectionStrin gs>
=============== =============== =============== =============== =
Me.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors) has attached to it an
OleDBException was unhandled ===>> Could not find installable ISAM.
=============== =============== =============== =============== ===

Of course, changing the file source to c:\Pubs.mdb works as expected.
This connection string is shown below.
=============== =============== =============== =============== ===========
<connectionStri ngs>
<add name="CRUD.My.M ySettings.PubsC onnectionString "
connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;
Data Source=C:\Pubs. mdb"
/>
</connectionStrin gs>
=============== =============== =============== =============== ============
TIA for all assistance
Bob

[Paul Clement]

On Wed, 24 May 2006 09:30:07 -0500, "Bob Palank" <bo*@stlcc.or g> wrote:

¤ Thanks to all for the ongoing help.
¤ Microsoft Access (.mdb) seems like an excellent database to be used on a server when the file
¤ size is very small and the number of read only hits per day is less than 100. The server cost is
¤ minimal as opposed to the expense of hosting a SQL Server DB.
¤ Another alternative might be SQL Server 2005 Express DataBase.
¤ But first I'd like to get things working with Microsoft Access.
¤
¤ Below is the Connection String from app.config that I'm using along with the error message that results.
¤
¤ =============== =============== =============== =============== =
¤
¤ <add name="CRUD.My.M ySettings.PubsC onnectionString "
¤ connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;
¤ Data Source=some.ser ver.org\ISstude nt\Pubs.mdb;
¤ JetOLEDB:Databa se;
¤ User ID=;
¤ Password=;"
¤ />
¤ </connectionStrin gs>
¤ =============== =============== =============== =============== =
¤ Me.AuthorsTable Adapter.Fill(Me .PubsDataSet.au thors) has attached to it an
¤ OleDBException was unhandled ===>> Could not find installable ISAM.
¤ =============== =============== =============== =============== ===
¤
¤ Of course, changing the file source to c:\Pubs.mdb works as expected.
¤ This connection string is shown below.
¤ =============== =============== =============== =============== ===========
¤ <connectionStri ngs>
¤ <add name="CRUD.My.M ySettings.PubsC onnectionString "
¤ connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;
¤ Data Source=C:\Pubs. mdb"
¤ />
¤ </connectionStrin gs>
¤ =============== =============== =============== =============== ============

It sounds like your network data source path is invalid. You either have to use a mapped drive
letter or a UNC path. Below is an example which uses a UNC path:

"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\\sharen ame\folder\Data base\MyAccessDB .mdb;"

In addition, I'm not sure what " JetOLEDB:Databa se" in your connection string is. This isn't a valid
parameter.
Paul
~~~~
Microsoft MVP (Visual Basic)