RE: Permissions causing error on export?

The Access security permissions might limit a user if they con't have
permissions on the query. I assume they can run the query fine within Access?

You might also check the Windows permissions the person has on the
destination.
--
Joan Wild
Microsoft Access MVP


"Pendragon" wrote:

Originally put this into the Importing/Exporting thread, but have thought now
perhaps this thread is more appropriate. Sorry for the duplicate post -
don't know how to delete the other one (if I can at all).

*****

Office 03/WinXP Pro

Trying to code a very simple DoCmd.TransferText on a query. I get the error
"External Table in Unexpected Format". In searching Microsoft, I found a
reference to this error regarding Direct Mail Manager and problems with
passwords and protected documents.

Do MDW security settings affect VBA programming in using export/import
methods? I do know that the user experiencing this error has limitations in
her security settings.

Thanks for your help.

.

Relevant Pages

  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)
  • Re: Search for accounts based on advanced security permissions
    ... to query the security attributes and to change permissions and security ... Search for accounts based on advanced security permissions ... don't think there is any easy way to query for all users. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Determining query rights.
    ... Is there any way to determine the security settings for a W2K domain? ... > domain using the effective rights tool. ... > Read permissions are required, as per membership of the Pre-W2K compatible ... >> I've been asked to check that a particular account in AD can query AD ...
    (microsoft.public.windows.server.active_directory)
  • Re: Permissions section is missing
    ... you can set manage security settings in the Portal only ... Each area can have unique permissions, ... within that particular area will automatically inherit the area's security. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How to apply security to a column in a table?
    ... You need to implement user-level security. ... You can deny all permissions to the tables, and instead use 'run with owner ... permissions' queries. ... the underlying tables based on the query owner's permissions on the tables. ...
    (microsoft.public.access.security)
Loading