Re: Access DB Issues - Again
- From: "Andrew Morton" <akm@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 May 2006 09:35:41 +0100
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
.
- References:
- Access DB Issues - Again
- From: Bob Palank
- Access DB Issues - Again
- Prev by Date: Re: Error: Statement is not valid in a namespace
- Next by Date: Re: Rank Dataset Contents
- Previous by thread: Re: Access DB Issues - Again
- Next by thread: Re: Access DB Issues - Again
- Index(es):