Re: got Error 3045, sounds like a problem with workgroup file

Assuming those really are the filenames, you should give the mdw a different
name than the mdb. They each need to create their own ldb file, and
obviously can't if they're both named the same.

Also you need to give users create and delete permission on the folder.


--
Joan Wild
Microsoft Access MVP

Frank wrote:
> We have an Access database Sch.mdb in a folder in the shared network
> driver S. Each user of the database had been given the right to read,
> write into that folder.
>
> This morning one user reported that he was unable to open the
> database, the error message was "Unable to lock file". I tried to
> open the database in the shared driver S, and got the error message
> "Could not use 'Admin'; file already in use" ( Error 3045).
>
> Even it sounds like the error came from the lock file Sch.ldb, the
> error should came from the workgroup file Sch.mdw. Here is my
> observation:
>
> 1. At the moment when I got the call from the user I did not see the
> lock file Sch.ldb in the S driver. It might indicate that no user was
> using that database when error message appeared.
>
> 2. I tried to open a copy of the database in my local driver C. Still
> I got the same error message "Could not use 'Admin'; file already
> in use". Then I tried to use a workgroup file Sch.mdw in my local
> driver C by rejoining the workgroup. After that I was able to open the
> database in the shared S driver. In other words I can use the database
> in the shared S driver and use my local workgroup file. A lock file
> Sch.ldb was created in the shred S driver after I opened the database.
> I tried once again to use the workgroup file Sch.mdw in the shared S
> driver, I got the same error message.
>
> That trouble happened once before. I do not know where the error comes
> from, and how I can resolve that problem. I would be very grateful if
> someone can help me.


.

Relevant Pages

  • Re: Insert Database Results - Get Error
    ... The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ... > FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • RE: Update Access DB using Frontpage 2000 returns error
    ... > Second is there an issue with using an Autonumber field as a parameter. ... > Here is the Error message it gives me. ... > against a database using the connection string ... > language depending on how the driver is configured. ...
    (microsoft.public.frontpage.programming)
  • HELP! Having trouble with Workspace
    ... I am trying to put together a module and open a workspace on a database that ... This is the lin that I'm having ... workgroup file, just the default. ... This is the error message I'm getting; ...
    (comp.databases.ms-access)
  • Re: Database Connection Problem
    ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... Unable to connect to a database from the web server using the ... > The following error message comes from the database driver software; ...
    (microsoft.public.frontpage.client)
  • Re: got Error 3045, sounds like a problem with workgroup file
    ... I checked user's privileges in the folder where the shared database ... > Also you need to give users create and delete permission on the folder. ... >> open the database in the shared driver S, ... >> using that database when error message appeared. ...
    (microsoft.public.access.security)