|
Home > Archive > MS Access Multiuser > May 2005 > Denied access to file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Denied access to file
|
|
|
| I have an Access file located on a Windows Server 2003 computer. The
file is accessed via local network in this office and via terminal
services from satellite offices.
This database has been in use for over 2 months with no problems. This
morning I logged on once w/out incident. I started getting reports of
people not being able to log on. So, I logged off and tried to log back
on. I get the following error "You do not have the necessary permissions
to use the "L:\database\lpe.mdb"object. Have your system administrator or
the person who created this object establish the appropriate permissions
for you." Now, I can't access the file either. I even rebooted the
server to see if this "fixed it", but it did not.
I have the .mdb and the .mdw files in the same folder. I have it set up
to where you have use a shortcut I created to access the mdb file. This
is the shortcut: "C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" L:\\database\LPE.mdb /wrkgrp "L://database/LPEwid.mdw".
The error above is the same error I've seen when you try to open the
lpe.mdb file directly.
Is this a sign of corruption? I looked at this site:
http://www.granite.ab.ca/access/corruptmdbs.htm, but didn't see the error
above listed.
Any suggestions on what to look for or how to recover?
Thanks,
Doug
| |
| Immanuel Sibero 2005-05-16, 11:24 am |
|
Doug,
> is the shortcut: "C:\Program Files\Microsoft Office\Office10
> \MSACCESS.EXE" L:\\database\LPE.mdb /wrkgrp "L://database/LPEwid.mdw".
First, the basics. I'm not sure if this is a typo on your part, but the
shortcut should be
"C:\Program Files\Microsoft Office\Office10\MSAC
CESS.EXE"
L:\database\LPE.mdb /wrkgrp "L:\database\LPEwid.mdw".
Watch the backslashes.
Second, make sure you use the split FE/BE setup.
HTH,
Immanuel Sibero
"Doug" < dmillsapsNOSPAM@satx
.rr.com> wrote in message
news:Xns96586C384E5A
8dmillsapsatsatxrrco
m@207.115.63.158...
> I have an Access file located on a Windows Server 2003 computer. The
> file is accessed via local network in this office and via terminal
> services from satellite offices.
>
> This database has been in use for over 2 months with no problems. This
> morning I logged on once w/out incident. I started getting reports of
> people not being able to log on. So, I logged off and tried to log back
> on. I get the following error "You do not have the necessary permissions
> to use the "L:\database\lpe.mdb"object. Have your system administrator or
> the person who created this object establish the appropriate permissions
> for you." Now, I can't access the file either. I even rebooted the
> server to see if this "fixed it", but it did not.
>
> I have the .mdb and the .mdw files in the same folder. I have it set up
> to where you have use a shortcut I created to access the mdb file. This
> is the shortcut: "C:\Program Files\Microsoft Office\Office10
> \MSACCESS.EXE" L:\\database\LPE.mdb /wrkgrp "L://database/LPEwid.mdw".
>
> The error above is the same error I've seen when you try to open the
> lpe.mdb file directly.
>
> Is this a sign of corruption? I looked at this site:
> http://www.granite.ab.ca/access/corruptmdbs.htm, but didn't see the error
> above listed.
>
> Any suggestions on what to look for or how to recover?
>
> Thanks,
> Doug
| |
|
| Thanks Immanuel. I meant to note that the lpe.mdb has not been split
yet.
This shortcut is a direct copy and paste from the shortcut I've been
using for awhile:
"C:\Program Files\Microsoft Office\Office10\MSAC
CESS.EXE" L:\\Database
\LPE.mdb /wrkgrp "L://Database/LPEwid.mdw"
I went ahead and revised the shortcut to your recommendation and still
see the same error. FWIW, I do see a LPEwid.ldb file temporarily showing
up in the \database\ folder.
"Immanuel Sibero" <goahead@getlost.com> wrote in
news:#LaQ8DjWFHA.3184@TK2MSFTNGP15.phx.gbl:
>
> Doug,
>
>
> First, the basics. I'm not sure if this is a typo on your part, but
> the shortcut should be
>
> "C:\Program Files\Microsoft Office\Office10\MSAC
CESS.EXE"
> L:\database\LPE.mdb /wrkgrp "L:\database\LPEwid.mdw".
>
> Watch the backslashes.
>
> Second, make sure you use the split FE/BE setup.
>
> HTH,
> Immanuel Sibero
>
>
| |
| Immanuel Sibero 2005-05-16, 1:24 pm |
|
Doug,
Make sure all users have full access to the folder where the mdb and mdw
files reside (i.e. in your case the Database folder off of your L: drive)
You can test this by creating a document in Word or Wordpad, save the
document, make changes and resave the document, and then delete it from that
folder. All users should be able to do all of the above.
HTH,
Immanuel Sibero
"Doug" < dmillsapsNOSPAM@satx
.rr.com> wrote in message
news:Xns965872ACA1AB
2dmillsapsatsatxrrco
m@207.115.63.158...[color=darkred]
> Thanks Immanuel. I meant to note that the lpe.mdb has not been split
> yet.
>
> This shortcut is a direct copy and paste from the shortcut I've been
> using for awhile:
> "C:\Program Files\Microsoft Office\Office10\MSAC
CESS.EXE" L:\\Database
> \LPE.mdb /wrkgrp "L://Database/LPEwid.mdw"
>
> I went ahead and revised the shortcut to your recommendation and still
> see the same error. FWIW, I do see a LPEwid.ldb file temporarily showing
> up in the \database\ folder.
>
>
> "Immanuel Sibero" <goahead@getlost.com> wrote in
> news:#LaQ8DjWFHA.3184@TK2MSFTNGP15.phx.gbl:
>
| |
|
| No changes have been made to Windows permissions. But since I have nothing
else to try, I tried your experiment. I am able to create and modify a txt
file in the same folder as the database.
"Immanuel Sibero" <goahead@getlost.com> wrote in
news:#Rmw#djWFHA.4036@TK2MSFTNGP10.phx.gbl:
>
> Doug,
>
> Make sure all users have full access to the folder where the mdb and
> mdw files reside (i.e. in your case the Database folder off of your L:
> drive) You can test this by creating a document in Word or Wordpad,
> save the document, make changes and resave the document, and then
> delete it from that folder. All users should be able to do all of the
> above.
>
>
> HTH,
> Immanuel Sibero
>
| |
| Alex White MCDBA MCSE 2005-05-16, 1:24 pm |
| Try going into the properties of the file, security, advanced, effective
permissions
The default security arrangement for Windows 2003 (read-only by default on
file-level and share-level) is the opposite from Windows 2000 (full control
by default on file-level and share-level).
Can the file be copied to another computer and does it work from there?
--
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Doug" < dmillsapsNOSPAM@satx
.rr.com> wrote in message
news:Xns96587F19D820
Ddmillsapsatsatxrrco
m@207.115.63.158...[color=darkred]
> No changes have been made to Windows permissions. But since I have
> nothing
> else to try, I tried your experiment. I am able to create and modify a
> txt
> file in the same folder as the database.
>
> "Immanuel Sibero" <goahead@getlost.com> wrote in
> news:#Rmw#djWFHA.4036@TK2MSFTNGP10.phx.gbl:
>
| |
| Tony Toews 2005-05-16, 8:24 pm |
| Doug < dmillsapsNOSPAM@satx
.rr.com> wrote:
>No changes have been made to Windows permissions.
How do you know?
> But since I have nothing
>else to try, I tried your experiment. I am able to create and modify a txt
>file in the same folder as the database.
You can but can the users?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| |
|
| Tony Toews <ttoews@telusplanet.net> wrote in
news:ccth81tmshhk5ou
5v8akrv7uiv7jnnc7s3@
4ax.com:
> Doug < dmillsapsNOSPAM@satx
.rr.com> wrote:
>
>
> How do you know?
We only have one IT admin person. He told me he didn't change anything.
Based on that, I assumed no changes were made. Now knowing what solved the
problem, I still believe this to be the case.
>
>
> You can but can the users?
>
> Tony
If I couldn't, then whether the users can or not is moot. Since I could
and was still encountering the same problem, I ruled out (right or wrong)
permissions from being an issue.
| |
| Tony Toews 2005-05-18, 3:24 am |
| Doug < dmillsapsNOSPAM@satx
.rr.com> wrote:
>
>We only have one IT admin person. He told me he didn't change anything.
>Based on that, I assumed no changes were made.
Reasonable enough. I'm always somewhat sceptical of IT departments as
1) they sometimes have clueless morons 2) one person didn't make any
changes but someone else could have.
>
>If I couldn't, then whether the users can or not is moot. Since I could
>and was still encountering the same problem, I ruled out (right or wrong)
>permissions from being an issue.
Fair enough. I had missed that part in this thread.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
|
|
|
|
|