ACC97 on a Network environment

[amazo]

Dear all,

A new network has been installed on a customer and I get some troubles
to do specific things; I will explain:

The infraestructure is as follows:
.. Server: Windows Server 2003
.. Workstations: Office XP Pro

I have installed ACC97 on "each" workstation using a login with
administrator rights.

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

I would appreciate your comments.

Angel.

[Larry Linson]

When you talk about logging in, are you talking about logging in to Windows
itself (in which case, you almost certainly have a problem due to the rights
the user has on some disk/folder) or logging in to Access (in which case,
you may have a problem with the rights you granted to that user in the
pertinent Workgroup .MDW file).

As I have neither a Windows Server 2003 nor Win XP installed, perhaps
someone else will join in this discussion who has more knowledge on those
products.

Larry Linson
Microsoft Access MVP

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Dear all,

A new network has been installed on a customer and I get some troubles
to do specific things; I will explain:

The infraestructure is as follows:
. Server: Windows Server 2003
. Workstations: Office XP Pro

I have installed ACC97 on "each" workstation using a login with
administrator rights.

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

I would appreciate your comments.

Angel.

[amazo]

Rosco,

Thanks for your prompt answer. Users have those kind of rights, after
talking to some colleagues it seems that using some features, like
wizards, needs to access to registry with "administrator" privileges.

The problem is that on server domain, people are administrator or
users and people on charge to maintain the server don't accept to give
to a normal user administrator rights because then the security is wet
paper.

So, the dilemma is that administrator users can do everything and
normal users can't use certain Access features, like wizards.

Thanks and best regards.

Angel.

"Rosco" <Ro***@discussions.microsoft.com> wrote in message news:<70**********************************@microso ft.com>...

I should think that at a minimum, your users would need read/write/modify
rights to the folder on the server containing the db.

Rosco

[Tony Toews]

am***@pobladores.com (amazo) wrote:

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

Part of the problem is that regular users have read only access to
"Program Files" and "Windows". There may be registry permission
problems as well but I'm not sure about that.

I haven't investigated all of these issues though. Unfortunately I'm
also not aware of any web resources which cover this issue.

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

[amazo]

Hi Larry,

sorry, I didn't explain enough the term "log in"; I am not using the
Access Security Workgroup .MDW file, so I meant log in Windows Server
Domain.

Joan Wild, wrote down 2 KB's articles that I am going to investigate.

Thanks to everybody.

Angel.

"Larry Linson" <bo*****@localhost.not> wrote in message news:<ug9md.6065$GV5.254@trnddc04>...

When you talk about logging in, are you talking about logging in to Windows
itself (in which case, you almost certainly have a problem due to the rights
the user has on some disk/folder) or logging in to Access (in which case,
you may have a problem with the rights you granted to that user in the
pertinent Workgroup .MDW file).

As I have neither a Windows Server 2003 nor Win XP installed, perhaps
someone else will join in this discussion who has more knowledge on those
products.

Larry Linson
Microsoft Access MVP

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Dear all,

A new network has been installed on a customer and I get some troubles
to do specific things; I will explain:

The infraestructure is as follows:
. Server: Windows Server 2003
. Workstations: Office XP Pro

I have installed ACC97 on "each" workstation using a login with
administrator rights.

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

I would appreciate your comments.

Angel.

[caixiuwei]

??????
amazo <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Rosco,

Thanks for your prompt answer. Users have those kind of rights, after
talking to some colleagues it seems that using some features, like
wizards, needs to access to registry with "administrator" privileges.

The problem is that on server domain, people are administrator or
users and people on charge to maintain the server don't accept to give
to a normal user administrator rights because then the security is wet
paper.

So, the dilemma is that administrator users can do everything and
normal users can't use certain Access features, like wizards.

Thanks and best regards.

Angel.

"Rosco" <Ro***@discussions.microsoft.com> wrote in message

news:<70**********************************@microso ft.com>...

I should think that at a minimum, your users would need read/write/modify rights to the folder on the server containing the db.

Rosco

[Dave Pike]

I have had a similar problem in a Win2003/XP based envrionment before
(learned this the hard way). You need to make sure that permissions
are set appropriately on all the directories you are trying to use.
(i.e. Read, Write, especially modify!).

Also check the users permissions, otherwise you'll get very odd errors
and possibly the other problems you have experienced.

Dave

am***@pobladores.com (amazo) wrote in message news:<4c**************************@posting.google. com>...

Dear all,

A new network has been installed on a customer and I get some troubles
to do specific things; I will explain:

The infraestructure is as follows:
. Server: Windows Server 2003
. Workstations: Office XP Pro

I have installed ACC97 on "each" workstation using a login with
administrator rights.

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

I would appreciate your comments.

Angel.

[paii, Ron]

I have just run into this problem on XP. It looks like the same types of
problems with running Access97 on terminal server. You may want to look into
compatibility notes for terminal server and do the same on XP
workstations.You will need to allow administrator access to system folder
and some registry locations.

As of now I have the user setup with an administrator account on the XP
workstations until I find the time to experiment.

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Dear all,

A new network has been installed on a customer and I get some troubles
to do specific things; I will explain:

The infraestructure is as follows:
. Server: Windows Server 2003
. Workstations: Office XP Pro

I have installed ACC97 on "each" workstation using a login with
administrator rights.

When I log in as normal user (no administrator rights) I can not use
the wizards to create, for example, a table, a query, to import from
excel, etc.
I can create a table, query, etc. using only "design" mode but not
using the wizards.

Nevertheless when I log in with administrator rights I can do all of
those things with no problem.

The clue must be to confer "normal" users the enough rights to do that
but without having the administrator rights ... and I have no idea
where that should be done.

I would appreciate your comments.

Angel.