Help work related. No one can access database in workgroup.

[JoanOC]

For some unknown reason no one can access the cases.mdb database that
contains all the files/records in the law firm.
Error Message: can't find cases.mdb
I have the main database. The other 5 staff members access access thru a
workgroup setup.
It all worked fine until recently. The only thing I can think of that
changed was that I opened up the .mdw file just to look at it.
Please help. The attorneys are unable to enter status notes or access the
data they need that is in cases.mdb.
On the point of hysterics.

 

[strive4peace]

Hi Joan,

have you checked to see where Cases.mdb actually is on the drive? Have
your drive mappings changed?

I am assuming you are linking to this database...

close all forms

from the database window, open a table you know to be in that database.
If you cannot open it, perhaps the cases.mdb file has been moved...

try locating it and moving it back or re-link it

Tools, Database Utilities, Linked Table Manager...



Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[JoanOC]

The cases.mdb is in the correct place.
Thru the workgroup I can open up where cases.mdb is on my p/c from the other
p/cs, but still get the message that cases.mdb can't be found even though I
can see it.
The way I connected everyone was by mapping from their p/c to mine.
I look at the tools,database utilities, linke table manager: it reads no
links.
I tried to use this to link but changed my mind and can't cancel out of the
table manager. Help

 

[Gina Whipp]

Just my 2 cents worth...

Are you saying the database is not split? Not really a good idea,
especially when there are multiple users, leads to corruption issues.

You say you can open the database but others can't. Do they have 'full
permissions' the folder on your drive?

Not sure what you mean "I tried to use this to link but changed my mind and
can't cancel out of the table manager.". Did you point it to a back-end?
What back-end if there are no links and no back-end?

 

[JoanOC]

The workgroup is a pier-to-pier setup.
My p/c is the main p/c that the others in the workgroup access.
Access fine on my p/c.
Probem is that the others in the office suddenly can't access Access.
The cases database is in My MyDocuments and is shared with them.
They can access everthing in my MyDocuments except Access [and another.mdb
file]. They are able to access a sample .mdb file that is located elswhere
on my p/c.
Everything was working fine for years. The only thing that I did recently
was to open the .mdw file just to look at it. I could have done something to
it that is causing the problem.
Can I unistall Access and reinstall Access to clean up whatever is the
problem?

 

[John W. Vinson]

They can access everthing in my MyDocuments except Access [and another.mdb
file]. They are able to access a sample .mdb file that is located elswhere
on my p/c.

You say the database is shared... but is the My Documents folder shared? The
users must have COMPLETE read, write, create and delete privileges on the
folder (in order to create and delete the .LDB locking file).

I'd really suggest creating a new folder (near but not in the drive's root
directory, for good performance) with appropriate permissions, rather than
using My Documents. It sounds like this is a shared file, not one of Your
Documents...

John W. Vinson [MVP]

 

[Joan Wild]

Is there a ldb file (or files) in your My Documents folder? If there is,
delete it (them).

Are you able to open Cases.mdb on your computer?

How are you opening the mdb - via a double-click in Windows Explorer, or via
a desktop shortcut?

--
Joan Wild
Microsoft Access MVP

The workgroup is a pier-to-pier setup.
My p/c is the main p/c that the others in the workgroup access.
Access fine on my p/c.
Probem is that the others in the office suddenly can't access Access.
The cases database is in My MyDocuments and is shared with them.
They can access everthing in my MyDocuments except Access [and another.mdb
file]. They are able to access a sample .mdb file that is located
elswhere
on my p/c.
Everything was working fine for years. The only thing that I did recently
was to open the .mdw file just to look at it. I could have done something
to
it that is causing the problem.
Can I unistall Access and reinstall Access to clean up whatever is the
problem?



--
Joan

Just my 2 cents worth...

Are you saying the database is not split? Not really a good idea,
especially when there are multiple users, leads to corruption issues.

You say you can open the database but others can't. Do they have 'full
permissions' the folder on your drive?

Not sure what you mean "I tried to use this to link but changed my mind
and
can't cancel out of the table manager.". Did you point it to a back-end?
What back-end if there are no links and no back-end?


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

 

[JoanOC]

MyDocuments folder is shared and has been for years and worked ok.
The users have been able to read, write and delete for years.
Exception: when I am entering new data into Access they get "access denied"
message until I save what I am entering - sometimes I need to close the form
- but again, this is a new problem.
I will double check the properties.
The locking file appears after I open Access and disappears when I exit out.
I will double check this also to see if it appears when I close the form but
do not exit Access.
I will also create a new folder in MyDocuments that's path is in
c:\Documents and Setting\Administrator\MyDocuments.
Question: Should the box be checked or unchecked re record locking when
editing?

--
Joan

They can access everthing in my MyDocuments except Access [and another.mdb
file]. They are able to access a sample .mdb file that is located elswhere
on my p/c.

You say the database is shared... but is the My Documents folder shared? The
users must have COMPLETE read, write, create and delete privileges on the
folder (in order to create and delete the .LDB locking file).

I'd really suggest creating a new folder (near but not in the drive's root
directory, for good performance) with appropriate permissions, rather than
using My Documents. It sounds like this is a shared file, not one of Your
Documents...

John W. Vinson [MVP]

 

[Gina Whipp]

Make sure you are not opening the database in 'Exclusive Mode'. To confirm
that go to... Tools|Options|Advanced (tab) and make sure 'Default Open
Mode' is set for Shared. As for the check box mine is checked for Edited
Record.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

MyDocuments folder is shared and has been for years and worked ok.
The users have been able to read, write and delete for years.
Exception: when I am entering new data into Access they get "access
denied"
message until I save what I am entering - sometimes I need to close the
form
- but again, this is a new problem.
I will double check the properties.
The locking file appears after I open Access and disappears when I exit
out.
I will double check this also to see if it appears when I close the form
but
do not exit Access.
I will also create a new folder in MyDocuments that's path is in
c:\Documents and Setting\Administrator\MyDocuments.
Question: Should the box be checked or unchecked re record locking when
editing?

--
Joan

They can access everthing in my MyDocuments except Access [and
another.mdb
file]. They are able to access a sample .mdb file that is located
elswhere
on my p/c.

You say the database is shared... but is the My Documents folder shared?
The
users must have COMPLETE read, write, create and delete privileges on the
folder (in order to create and delete the .LDB locking file).

I'd really suggest creating a new folder (near but not in the drive's
root
directory, for good performance) with appropriate permissions, rather
than
using My Documents. It sounds like this is a shared file, not one of Your
Documents...

John W. Vinson [MVP]

 

[John W. Vinson]

MyDocuments folder is shared and has been for years and worked ok.
The users have been able to read, write and delete for years.
Exception: when I am entering new data into Access they get "access denied"
message until I save what I am entering - sometimes I need to close the form
- but again, this is a new problem.
I will double check the properties.
The locking file appears after I open Access and disappears when I exit out.
I will double check this also to see if it appears when I close the form but
do not exit Access.
I will also create a new folder in MyDocuments that's path is in
c:\Documents and Setting\Administrator\MyDocuments.
Question: Should the box be checked or unchecked re record locking when
editing?

The .ldb file should be created when you - *or any other user* - open the
database, and disappear when the last user to have the database open closes
it. It is not affected by having a form open or closed.

Are you opening the form *IN DESIGN MODE* or just for data editing? With the
way Access handles code-bearing objects such as Forms, only one user can have
the database open in design mode. That's one of many reasons to split the
database - and I'd really, really recommend doing so!!

John W. Vinson [MVP]

 

[JoanOC]

I am opening the form for data entry. [If I am in design mode I ask everyone
to sign off.]
I never heard of spilt the database. I will need to research this unless
you are able to explain it.
Question: In Users and Group Permissions - when I click to open it I
receive the following error message before it opens: "Record Not Found"
Should my setting be on the form Switcboard? If so, then the open/run is
grayed out. Could this be the problem?

 

[JoanOC]

Correction to my last reply: In Users and Group Permission
All the boxes on the left are checked including Open/Run. Form. Switchboard

 

[JoanOC]

Default Openm Mode is set for shared.
I just checked the Edited Record box.
Question: Should the Open databases using record level locking be checked or
unchecked?
--
Joan

Make sure you are not opening the database in 'Exclusive Mode'. To confirm
that go to... Tools|Options|Advanced (tab) and make sure 'Default Open
Mode' is set for Shared. As for the check box mine is checked for Edited
Record.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

MyDocuments folder is shared and has been for years and worked ok.
The users have been able to read, write and delete for years.
Exception: when I am entering new data into Access they get "access
denied"
message until I save what I am entering - sometimes I need to close the
form
- but again, this is a new problem.
I will double check the properties.
The locking file appears after I open Access and disappears when I exit
out.
I will double check this also to see if it appears when I close the form
but
do not exit Access.
I will also create a new folder in MyDocuments that's path is in
c:\Documents and Setting\Administrator\MyDocuments.
Question: Should the box be checked or unchecked re record locking when
editing?

--
Joan

On Thu, 5 Apr 2007 14:46:01 -0700, JoanOC
<[email protected]>
wrote:

They can access everthing in my MyDocuments except Access [and
another.mdb
file]. They are able to access a sample .mdb file that is located
elswhere
on my p/c.

You say the database is shared... but is the My Documents folder shared?
The
users must have COMPLETE read, write, create and delete privileges on the
folder (in order to create and delete the .LDB locking file).

I'd really suggest creating a new folder (near but not in the drive's
root
directory, for good performance) with appropriate permissions, rather
than
using My Documents. It sounds like this is a shared file, not one of Your
Documents...

John W. Vinson [MVP]

 

[Gina Whipp]

Mine is checked

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Default Openm Mode is set for shared.
I just checked the Edited Record box.
Question: Should the Open databases using record level locking be checked
or
unchecked?
--
Joan

Make sure you are not opening the database in 'Exclusive Mode'. To
confirm
that go to... Tools|Options|Advanced (tab) and make sure 'Default Open
Mode' is set for Shared. As for the check box mine is checked for Edited
Record.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

MyDocuments folder is shared and has been for years and worked ok.
The users have been able to read, write and delete for years.
Exception: when I am entering new data into Access they get "access
denied"
message until I save what I am entering - sometimes I need to close the
form
- but again, this is a new problem.
I will double check the properties.
The locking file appears after I open Access and disappears when I exit
out.
I will double check this also to see if it appears when I close the
form
but
do not exit Access.
I will also create a new folder in MyDocuments that's path is in
c:\Documents and Setting\Administrator\MyDocuments.
Question: Should the box be checked or unchecked re record locking when
editing?

--
Joan


:

On Thu, 5 Apr 2007 14:46:01 -0700, JoanOC
<[email protected]>
wrote:

They can access everthing in my MyDocuments except Access [and
another.mdb
file]. They are able to access a sample .mdb file that is located
elswhere
on my p/c.

You say the database is shared... but is the My Documents folder
shared?
The
users must have COMPLETE read, write, create and delete privileges on
the
folder (in order to create and delete the .LDB locking file).

I'd really suggest creating a new folder (near but not in the drive's
root
directory, for good performance) with appropriate permissions, rather
than
using My Documents. It sounds like this is a shared file, not one of
Your
Documents...

John W. Vinson [MVP]

 

[John W. Vinson]

I never heard of spilt the database. I will need to research this unless
you are able to explain it.

http://www.granite.ab.ca/access/splitapp/index.htm

has a far better and more thorough explanation than I could provide.

Question: In Users and Group Permissions - when I click to open it I
receive the following error message before it opens: "Record Not Found"
Should my setting be on the form Switcboard? If so, then the open/run is
grayed out. Could this be the problem?

Why would you be (routinely) opening User and Group Permissions at all? It's
certainly NOT something you would want users doing, nor should it be necessary
from the switchboard. You'ld only set new permissions when you add a new user.

Do you mean the dialog from the Tools... Security menu? or are we talking
about something else?

John W. Vinson [MVP]

 

[Joan Wild]

You said earlier that you opened the mdw to look at it. It sounds as though
you mucked around with it a bit. I suggest you restore the mdw from a
backup.

--
Joan Wild
Microsoft Access MVP

I am opening the form for data entry. [If I am in design mode I ask
everyone
to sign off.]
I never heard of spilt the database. I will need to research this unless
you are able to explain it.
Question: In Users and Group Permissions - when I click to open it I
receive the following error message before it opens: "Record Not Found"
Should my setting be on the form Switcboard? If so, then the open/run is
grayed out. Could this be the problem?
--
Joan

The .ldb file should be created when you - *or any other user* - open the
database, and disappear when the last user to have the database open
closes
it. It is not affected by having a form open or closed.

Are you opening the form *IN DESIGN MODE* or just for data editing? With
the
way Access handles code-bearing objects such as Forms, only one user can
have
the database open in design mode. That's one of many reasons to split the
database - and I'd really, really recommend doing so!!

John W. Vinson [MVP]

 

[JoanOC]

Computer person came to the office and thinks that one of the computers has a
security setting that is causing the problem [other computers cannot access
my access]. Is there a way to find out rfrom my computer which of the 5
computers may be the problem?
There is one wireless notebook included in the workgroup.

 

[John W. Vinson]

Computer person came to the office and thinks that one of the computers has a
security setting that is causing the problem [other computers cannot access
my access]. Is there a way to find out rfrom my computer which of the 5
computers may be the problem?

The first thing to do would be to go to each computer, and use Network
Neighborhood to browse to the folder containing the backend database. View the
folder's Properties. Does each user have full read, write, create and delete
privileges?


John W. Vinson [MVP]

 

[JoanOC]

I did check all the computers except a wirless laptop that is not always in
the office when I am. I have a feeling that this may be where the problem
is, but unsure if it is security issue. Someone else set the laptop up. I
did notice that the path to my Access goes thru Microsoft Access then the
cases.mdb. Everyone else's path is to case.mdb in my My Documents. I only
mention this because I am unsure if this means anything.
--
Joan

Computer person came to the office and thinks that one of the computers has a
security setting that is causing the problem [other computers cannot access
my access]. Is there a way to find out rfrom my computer which of the 5
computers may be the problem?

The first thing to do would be to go to each computer, and use Network
Neighborhood to browse to the folder containing the backend database. View the
folder's Properties. Does each user have full read, write, create and delete
privileges?


John W. Vinson [MVP]

 

[John W. Vinson]

I
did notice that the path to my Access goes thru Microsoft Access then the
cases.mdb. Everyone else's path is to case.mdb in my My Documents. I only
mention this because I am unsure if this means anything.

"the path to ...?"

Where is this path? In the shortcut, or someplace else? Could you post the
actual content of the shortcut (xxx'ing any path names you're worried about
posting publicly, though that shouldn't really matter)?

John W. Vinson [MVP]