Importing to Excel

[Matt Dawson]

Does anyone know how to Import data to Excel from Access when I have user
group security.

I want to import from a query/form and it says I do not have the
permissions. DOes anyone know a way round this

Many Thanks,

Matt

 

[Arvin Meyer [MVP]]

Does anyone know how to Import data to Excel from Access when I have user
group security.

I want to import from a query/form and it says I do not have the
permissions. DOes anyone know a way round this

Get the administrator to give you permissions. I hate to sound flippant, but
that's exactly what security is meant to do.

 

[Matt Dawson]

I am the administrator and it says I do not have permission.

It gives me the same message as when you try to run the front end without
the shortcut

 

[Arvin Meyer [MVP]]

You have not joined the correct workgroup. The shortcut is a pointer that
allows you to work from a different workgroup than the one you have joined.
If you check the properties of the shortcut, you will see the /wrkgrp switch
and where it is pointing. If you join that workgroup using the workgroup
administrator, you won't need the shortcut to open your database.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Matt Dawson]

The Workgroup file links me to the security file that was created when I
started the user groups. This is the first time I have created a user
workgroup so I am not 100% sure if it is correct. I have permissions on
everything with my user but it seems I am not the admin.

The workgroup file that appears when i click workgroup administrator says my
name but is located within Application data and not in the folder that is
targeted in the shortcut.

Matt

 

[Arvin Meyer [MVP]]

If you join the workgroup that is targeted in the shortcut, you will not
need to use the shortcut. Everything created with that new workgroup will be
subject to its user accounts. IOW, the shortcut will temporarily join you to
the same workgroup that you can also join.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com