MS Access 2003问题 [英] MS Access 2003 problem
问题描述
大家好！
我对MS Access 2003权限有以下问题。
我有两个用户。一个是管理员，第二个是具有完整
权限的用户，可以输入修改和读取数据。
我有一个表和一个查询基于在这张桌子上。
这个查询很适合这两个用户。
现在，请耐心等待。
当我在此表上对列名称进行排序时，第二个用户在运行期间将收到
以下错误：
你不喜欢没有使用< kwerenda>的必要权限对象。
你的系统管理员或创建这个对象的人
建立
相应的权限你好
这个查询总是对第一个用户（管理员）有效，而且他没有
的问题。
你能帮帮我吗？因为我不知道它发生了什么，并且我已经试图解决这个问题3天而且没有结果。
谢谢你你的帮助
任何帮助appíciated
来自波兰的Marcin
***通过开发者发送索引 http://www.developersdex.com ***
" Marcin Zmyslowski" <毫安***** @ kapy.bydg.pl>在消息中写道
新闻：oj ************* @ news.uswest.net ...
当我对此表中的列名称进行排序，第二个用户在运行期间将收到以下错误：
您没有必要的权限来使用< kwerenda>对象。
有你的系统管理员或创建这个对象的人
为你建立适当的权限
这个查询总能正常工作第一个用户（管理员），他没有问题。
你们都使用相同的mdb文件吗？你有没有把数据库分成前面和后面的b
？为了让多用户环境正常运行，您必须这样做，并且每个用户必须拥有自己的前端副本。
搜索帮助拆分数据库更多信息。
问候，
基思。
www.keithwilby.com
Keith W写道：
" Marcin Zmyslowski <毫安***** @ kapy.bydg.pl>在消息中写道
新闻：oj ************* @ news.uswest.net ...
当我对列名称进行排序时在此表上，第二个用户在运行期间将收到以下错误：
您没有必要的权限来使用< kwerenda>对象。
有你的系统管理员或创建这个对象的人
为你建立适当的权限
这个查询总能正常工作第一个用户（管理员），他没有问题。
你们都使用相同的mdb文件吗？你有没有将数据库拆分为前端和后端？为了让多用户环境正常运行，您必须这样做，每个用户必须拥有自己的前端副本。
这是不正确的信息。
搜索拆分数据库的帮助更多信息。
问候，
基思。
www.keithwilby.com
" salad" < oi*@vinegar.com>在消息中写道
新闻：BM *************** @ newsread3.news.pas.earthlin k.net ...Keith W写道：
你们都使用相同的mdb文件吗？你有没有将数据库分成前端和后端？为了使多用户环境正常运行，您必须这样做，并且每个用户必须拥有自己的前端副本。
这是不正确的信息。
怎么样？
Hello all!
I have the following problem with MS Access 2003 permissions.
I have two users. One is admin and the second one is user who has full
permissions to enter modify and read data.
I have one table and one queries which is based on this table.
This query is good working for these two users.
Now, please be patient.
When I sort the column Name on this table the second user will get the
following error during running it:
You don''t have the necessary permissions to use the <kwerenda> object.
Have
your system administrator or the person who created this object
establish the
appropriate permissions for you
This query always works OK for the first user (admin) and he has no
problem with it.
Could you help me? Because I don`t know what it is going on and I have
been trying to fix this problem for 3 days and without result.
Thank you for your help
Any help apprieciated
Marcin from Poland
*** Sent via Developersdex http://www.developersdex.com ***
"Marcin Zmyslowski" <ma*****@kapy.bydg.pl> wrote in message
news:oj*************@news.uswest.net...
When I sort the column Name on this table the second user will get the
following error during running it:
You don''t have the necessary permissions to use the <kwerenda> object.
Have
your system administrator or the person who created this object
establish the
appropriate permissions for you
This query always works OK for the first user (admin) and he has no
problem with it.
Are you both using the same mdb file? Have you split the db into front and
back ends? For the multi-user environment to function correctly you must do
this and each user must have their own copy of the front end.
Search the help for "split database" for more info.
Regards,
Keith.
www.keithwilby.com
Keith W wrote:
"Marcin Zmyslowski" <ma*****@kapy.bydg.pl> wrote in message
news:oj*************@news.uswest.net...When I sort the column Name on this table the second user will get the
following error during running it:
You don''t have the necessary permissions to use the <kwerenda> object.
Have
your system administrator or the person who created this object
establish the
appropriate permissions for you
This query always works OK for the first user (admin) and he has no
problem with it.
Are you both using the same mdb file? Have you split the db into front and
back ends? For the multi-user environment to function correctly you must do
this and each user must have their own copy of the front end.
This is incorrect information.
Search the help for "split database" for more info.
Regards,
Keith.
www.keithwilby.com
"salad" <oi*@vinegar.com> wrote in message
news:BM***************@newsread3.news.pas.earthlin k.net...Keith W wrote:
Are you both using the same mdb file? Have you split the db into front
and back ends? For the multi-user environment to function correctly you
must do this and each user must have their own copy of the front end.
This is incorrect information.
How so?
这篇关于MS Access 2003问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
