Access Permissions not set

I recieve a large number of mdb files from a coleague which do not have any
permissions set for any usergroups or users. When I go to Tools Security
User and Group Permissions none of the boxes are ticked for any user/table.
Also in the Change Owner Tab all the tables have their current owner set to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these permissions by
default (as everyone elses' does) and how can I fix it? both My coleague and
myself are using Access 2003.

Thanks for any help!

You have to be more specific. How does your system fail? What are the error
messages and error numbers?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"OllyH" wrote in message
...
I recieve a large number of mdb files from a coleague which do not have any
permissions set for any usergroups or users. When I go to Tools Security

User and Group Permissions none of the boxes are ticked for any
user/table.
Also in the Change Owner Tab all the tables have their current owner set
to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these permissions
by
default (as everyone elses' does) and how can I fix it? both My coleague
and
myself are using Access 2003.

Thanks for any help!

On Wed, 1 Jul 2009 02:58:01 -0700, OllyH
wrote:

What do you mean with "causes my systems to fail"? An exact error
message would be nice, as well as when exactly this error occurs.

-Tom.
Microsoft Access MVP



I recieve a large number of mdb files from a coleague which do not have any
permissions set for any usergroups or users. When I go to Tools Security
User and Group Permissions none of the boxes are ticked for any user/table.
Also in the Change Owner Tab all the tables have their current owner set to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these permissions by
default (as everyone elses' does) and how can I fix it? both My coleague and
myself are using Access 2003.

Thanks for any help!

the message is:

Microsoft JET Database Engine error '80040e09'

Record(s) cannot be read; no read permission on 'pl011401METADATA'


pl011401METADATA is a table within an access database.

The system fails because the permissions are not set. I need to know how to
get my colleagues access to set the permissions as the defult permissions
which are usually used in access. Or I need to know why they are not being
set as default.





"Arvin Meyer MVP" wrote:

You have to be more specific. How does your system fail? What are the error
messages and error numbers?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"OllyH" wrote in message
...
I recieve a large number of mdb files from a coleague which do not have any
permissions set for any usergroups or users. When I go to Tools Security

User and Group Permissions none of the boxes are ticked for any
user/table.
Also in the Change Owner Tab all the tables have their current owner set
to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these permissions
by
default (as everyone elses' does) and how can I fix it? both My coleague
and
myself are using Access 2003.

Thanks for any help!

On Wed, 1 Jul 2009 02:58:01 -0700, OllyH
wrote:

I recieve a large number of mdb files from a coleague which do not have any
permissions set for any usergroups or users. When I go to Tools Security
User and Group Permissions none of the boxes are ticked for any user/table.
Also in the Change Owner Tab all the tables have their current owner set to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these permissions by
default (as everyone elses' does) and how can I fix it? both My coleague and
myself are using Access 2003.

Thanks for any help!

The problem would appear to be that you're joined to a workgroup file that
removes permissions from the default ADMIN user. This is appropriate for a
secured database.

If your colleague didn't apply security to the database, then the Admin user
should have full rights to everything. You just need to use Tools...
Security... Workgroup Administrator to Join an unmodified, default copy of
SYSTEM.MDW. This will give you an Admin user ID and your colleague's databases
should work.
--

John W. Vinson [MVP]

=?Utf-8?B?T2xseUg=?= wrote in
:

the message is:

Microsoft JET Database Engine error '80040e09'

Record(s) cannot be read; no read permission on 'pl011401METADATA'

pl011401METADATA is a table within an access database.

That's not a Jet error number.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

If you can open the database, but not do anything, the database has a
different workgroup which you must join. That will have a different .mdw
file, normally located in C:\Windows\System32\ folder, but it can be
anywhere. You may, or may not, be prompted for a username and password. You
could also be missing permissions on the folder where the databases are
stored.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"OllyH" wrote in message
...
the message is:

Microsoft JET Database Engine error '80040e09'

Record(s) cannot be read; no read permission on 'pl011401METADATA'


pl011401METADATA is a table within an access database.

The system fails because the permissions are not set. I need to know how
to
get my colleagues access to set the permissions as the defult permissions
which are usually used in access. Or I need to know why they are not being
set as default.





"Arvin Meyer MVP" wrote:

You have to be more specific. How does your system fail? What are the
error
messages and error numbers?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"OllyH" wrote in message
...
I recieve a large number of mdb files from a coleague which do not have
any
permissions set for any usergroups or users. When I go to Tools
Security

User and Group Permissions none of the boxes are ticked for any
user/table.
Also in the Change Owner Tab all the tables have their current owner
set
to
unknown. This causes my systems to fail.

Is there a reason why my coleagues Access does not set these
permissions
by
default (as everyone elses' does) and how can I fix it? both My
coleague
and
myself are using Access 2003.

Thanks for any help!