MS Access 2003 problem - Microsoft Access / VBA

Marcin Zmyslowski

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 ***

Nov 23 '05 #1

Subscribe Reply

3078

1
2
3
>
Last »

Keith W

"Marcin Zmyslowski" <ma*****@kapy.b ydg.pl> wrote in message
news:oj******** *****@news.uswe st.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

Nov 23 '05 #2

salad

Keith W wrote:

"Marcin Zmyslowski" <ma*****@kapy.b ydg.pl> wrote in message
news:oj******** *****@news.uswe st.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

Nov 24 '05 #3

Keith W

"salad" <oi*@vinegar.co m> wrote in message
news:BM******** *******@newsrea d3.news.pas.ear thlink.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?

Nov 25 '05 #4

Dean

Sorting a table is actually modifing the indexes to that table. That
is why Admin has no problem. The user should modify a query.

Nov 25 '05 #5

salad

Keith W wrote:

"salad" <oi*@vinegar.co m> wrote in message
news:BM******** *******@newsrea d3.news.pas.ear thlink.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.
You state "For the multi-user environment to function correctly you
must do this and each user must have their own copy of the front end."

I don't have to "must do" it. That is completely incorrect and
certainly not true.

If you can find a cite from MS that dispels my statements I'd like to
see it. I'll then go and tell my users that my apps don't work.

For the original poster, I'd check the security settings again. Perhaps
open the query in design mode, right click in the tables section, click
properties, and change the permissions from User to Owner.

How so?

Nov 25 '05 #6

Some Bloke

salad wrote:

Keith W wrote:
"salad" <oi*@vinegar.co m> wrote in message
news:BM******** *******@newsrea d3.news.pas.ear thlink.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.

You state "For the multi-user environment to function correctly you
must do this and each user must have their own copy of the front end."

I don't have to "must do" it. That is completely incorrect and
certainly not true.

If you can find a cite from MS that dispels my statements I'd like to
see it. I'll then go and tell my users that my apps don't work.

It's generally accepted that to provide discrete front ends to users
will minimise the possibility of corruption. You can get away with not
doing so but why bother when it's no trouble at all to provide each user
with their own copy? The pros and cons have been discussed at length on
here but I would always err on the side of caution.

Nov 26 '05 #7

salad

Some Bloke wrote:

salad wrote:
Keith W wrote:
"salad" <oi*@vinegar.co m> wrote in message
news:BM******** *******@newsrea d3.news.pas.ear thlink.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.
You state "For the multi-user environment to function correctly you
must do this and each user must have their own copy of the front end."

I don't have to "must do" it. That is completely incorrect and
certainly not true.

If you can find a cite from MS that dispels my statements I'd like to
see it. I'll then go and tell my users that my apps don't work.

It's generally accepted that

has nothing in common with "must do". I doubt splitting databases has
anything at all to do with the OPs question and permissions problems.

to provide discrete front ends to users will minimise the possibility of corruption. You can get away
"Get away with"? That's backing off from "must do". But you imply it.
Which is false.

with not doing so but why bother when it's no trouble at all to provide each user
with their own copy?
Irrelevent to topic at hand, but what is your distribution process for
updates?

The pros and cons have been discussed at length on here but I would always err on the side of caution.

Caution of what?

And show me a cite where MS said you "must do" a database split for
multiple users.

Nov 26 '05 #8

Some Bloke

salad wrote:

Some Bloke wrote:
salad wrote:
Keith W wrote:

"salad" <oi*@vinegar.co m> wrote in message
news:BM******** *******@newsrea d3.news.pas.ear thlink.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.

You state "For the multi-user environment to function correctly you
must do this and each user must have their own copy of the front end."

I don't have to "must do" it. That is completely incorrect and
certainly not true.

If you can find a cite from MS that dispels my statements I'd like to
see it. I'll then go and tell my users that my apps don't work.

It's generally accepted that

has nothing in common with "must do". I doubt splitting databases has
anything at all to do with the OPs question and permissions problems.

to provide discrete front ends to users
will minimise the possibility of corruption. You can get away

"Get away with"? That's backing off from "must do". But you imply it.
Which is false.

with not
doing so but why bother when it's no trouble at all to provide each
user with their own copy?

Irrelevent to topic at hand, but what is your distribution process for
updates?

The pros and cons have been discussed at length on
here but I would always err on the side of caution.

Caution of what?

And show me a cite where MS said you "must do" a database split for
multiple users.

Sorry Salad, I really can't be bothered with your pettiness.

Nov 27 '05 #9

Arno R

Hi Keith,
Please contact me.

Arno R

Nov 27 '05 #10

Similar topics

3750

annoying delay during refresh of aspx web page with ODBC Access query on IIS Windows 2003

by: Wolfgang Kaml | last post by:

Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,

ASP / Active Server Pages

2682

Access XP weirdness ...

by: JustMe | last post by:

I don't know if this has anything to do with AccessXP running on Terminal Services with Access97/2000 also installed, but here is one example of a query that does not work any longer: SELECT DLookUp("MajorCategory","AutoTypes","='1'") AS MajorCategory, PreOwned.PaintColor FROM PreOwned; When I try to run the above query I get the following error:

Microsoft Access / VBA

5736

Access 2003 Default File Format

by: Wayne Aprato | last post by:

I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the same as it was in Access 2002? I am running Access 2002 at the moment. Is there any reason for testing purposes etc, for me to purchase Access 2003 if I am going to recompile the Access 97 mdb files into Access 2000 format mde files which...

Microsoft Access / VBA

3454

Problems Opening Access 2003 mde Files In Access 2002

by: Wayne Aprato | last post by:

I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." Interestingly I can open the mdb files of the same 2003 databases in Access 2002 without problems. To my understanding the file formats of 2002 and 2003 are the same and this problem shouldn't exist. And why is it only the mde files that are giving the...

Microsoft Access / VBA

4738

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance

Microsoft Access / VBA

4192

Bug in Access 2003 ? Error after 380 CreateObject("MAPI.Session")

by: Ottar | last post by:

I've made a program sorting incomming mail in public folder. The function runs every minute by using the form.timer event. In Access XP it runs for weeks, no problem. Access 2003 runs the same code for 6 hours and stops. I've found the problem to be the Set MySession = CreateObject("MAPI.Session")

Microsoft Access / VBA

4513

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!

Microsoft Access / VBA

2529

Framework 1.1 / Access Unspecified Error

by: RM | last post by:

Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ASP=/TestDotNet/AdoNet.aspx System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open()...

ASP.NET

2431

Converting from Access 2000 to Access 2003, execute for a sql insert, update not working

by: Christine.Misseri | last post by:

Hi all, I'm sure someone knows about this problem. I have an Access database designed in Access 2000, connected to an ORACLE 8i back end. On the ORACLE side I have stored procedures, triggers and views that kick off at different times. My Access 2000 database works well. Problem: I converted the database to Access 2003 am using ORACLE again as my back end (they have updated the drivers in Oracle to 9i). I an trying

Microsoft Access / VBA

2488

Cannot compact on server using Access 2003

by: Bruce | last post by:

I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the server using Access 2003. Access 2000 seems to compact them just fine however. If I copy the database to my local workstation Access 2003 will compact it just fine. On the server however, when I use Access 2003, it creates a compacted copy of the original database and names it dbn.mdb (where...

Microsoft Access / VBA

8242

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8681

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8341

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7170

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4084

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4183

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2611

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1793

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1488

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General