Problem with User Accounts in Access

[Guest]

I set up user accounts in order to keep certian users from accidentaly
deleting data. I was able to set it up quite easily, but when I tried to link
the data to a Word Doc using mail merge, it asks for a user name and
password. I entered the name of the admin account and it still will not work.
It says that the account does not have the permission to use the data. I
want to be able to link the current password protected database to a word
doc. I also tried changing the owner of the query to "Admin," but that still
didn't work.

 

[Joan Wild]

I take it you are doing the merge from within Word? If so, you'll need to
be joined by default
to your secure workgroup file.

I would also suggest you open Word, Tools, Options, General tab and ensure
that 'Confirm conversion on open' is checked.

Start the merge, and when you select the data source, choose your secure mdb
file. In the 'Confirm Data Source' dialog choose 'via DDE' and you'll be
prompted for the Access username/password to open the data source.

You could, instead, do the merge from within Access. Since you would have
already signed in to the Access database, you're already authenticated for
the Access security. Use Tools, Office Links, Merge it with Word and
proceed from there.

 

[Guest]

Thanks so much for your help. I have been starting the merge from access, but
when Word loads, it asks for a username and password for the database. I
entered both "admin" and my name (which is an administrator account), and it
stil won't work. I am currently linking the database to another front-end
without security to be able to complete the merge.

Thanks again.

 

[Joan Wild]

The Admin user shouldn't have any permissions in a properly secured mdb.
Are you certain you are providing your username and password correctly (they
are case-sensitive).

What specific object does it say you don't have permission for?

I haven't had a problem running a mail merge from within a secure mdb
(running as a limited user).

 

[Guest]

The screen says "You do not have the nessacery permissions to use the
\\FrontDesk\lclc2\LCLCDatabase\LyonLensDatabase2.mbd" object. Have your
system administrator or the person who created the object establish the
appropriate permissions for you."

I can't figure out what is wrong. I have installs the Desktop SQL server in
the past on this computer. Could that have anything to do with it?

 

[Joan Wild]

Sorry I don't have any other suggestions. The installation of SQL server is
not a problem.

The steps I outlined earlier have worked for me with a secure mdb.