Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am having no problem getting both the database with the linked table
USERS
and the database that actually holds the unlinked USERS table
on a network drive so I don't see permissions as a problem since the
web can access the files fine as long as it isn't trying to access
the linked tables in other database.

For instance:

If I change the link table USERS in the SALES database to a non-link
table the asp pages over the web work fine.

I can access the original USERS table in the ALLUSERS database
find over the web.

I run into problems with I try to access the linked USERS table
through the SALES database over the web. This link works fine
from a networked drive.

Everything works fine except when accessing the linked tables from
the database employing the link when using the web.

Thanks.

John Z.




Bob Barrows [MVP] wrote:
> johnzur@xxxxxxxxxxx wrote:
> > Here's the entire error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> > engine cannot open the file '\\15.40.4.241\NETDRIVE\incoming.mdb'. It
> > is already opened exclusively by another user, or you need permission
> > to view its data.
> >
> > I put in the IP address in the link because I access the database from
> > other machines and if I use a drive letter I get an error when
> > accessing
> > via a networked drive. The links work fine when using a network
> > drive.
>
> Just to add to what Ray said (which is completely correct): all users of an
> access databse must have read/write permissions for the folder containing
> the database file, not just the file. This is because they need to be able
> to create, modify and delete the database lock control file (dbname.ldb) in
> order to allow multiuser activity. Without the lock file, only one user will
> be able to connect to the database at a time.
>
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"

.

Relevant Pages

  • Re: problem with sort/filter settings being retained in word 2002
    ... with permissions, since the database is on a network. ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Beginning C# Q
    ... starting out with a network app0lication, you have an awful lot to swallow. ... Designing your database is therefore, not quite the first step, particularly ... Groups table, which defines which Groups users belong to, and a Permissions ... That is why an Interface is called an Interface. ...
    (microsoft.public.dotnet.framework)
  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Replication/Sychronization and security
    ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
    (microsoft.public.access.replication)