VBA Code crashes in "Limited Account" but runs in "Administrator"

M

Maddox

My program stalls when I run it in Win XP Pro - "Limited Account" mode; but
runs fine when I am in "Administrator" mode. (Same results when I use the
runtime version or the full Access version.)

It catches on the following line:

rst_MasterCoil.Open "tbl_MasterCoil", Cnxn, adOpenForwardOnly,
adLockOptimistic

What is wrong? How can I fix it?
 
6

'69 Camaro

Hi, Maddox.
My program stalls when I run it in Win XP Pro - "Limited Account" mode; but
runs fine when I am in "Administrator" mode.
Click to expand...

Does the user logged in with the "Limited Account" have "Full Control"
Windows security permissions on the directory where the database file holding
the tbl_MasterCoil table is located? The user will have a hard time without
these permissions.

This user may need Windows security permissions in other directories as
well, but those directories are required for each MS Office user to have
Windows security permissions for. So unless your Windows system
administrator is overzealous, that shouldn't be the problem.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
M

Maddox

I understand your point, but that does not appear to be the problem.

When I use the "new" code, I only get an error when I am logged on as a
"Limited Account"; but I can switch to "administrator" on the same machine
and the program runs fine. Also, the original program has been running for
several months in "Limited Account" mode and has no problem reading and
writing to the mapped network drives. We are using the standard, Simple File
Sharing, and I believe that it is setup for "Level 5" because everyone is
reading and writing to the database.

When I run the modified program in runtime I receive the error "Cannot open
the file" and when I run it in full Access, the debugger goes to the line:

rst_MasterCoil.Open "tbl_MasterCoil", Cnxn, adOpenForwardOnly,
adLockOptimistic

I switched the adOpenForwardOnly to adOpenDynamic and now it works on my
laptop in "Limited Account" but still does not work at the workstation in
"Limited Account". (My laptop has full Access and the workstation only has
the runtime version)

Basically, I am trying to add new data through a user interface and append
it to the database. I thought that I could use "DoCmd.TransferDatabase
acLink,", "AddNew", and "Update". I will try switching to an append query,
but that does not seem like a direct path from the user interface screen to
the database.

Thanks Again,
 
M

Maddox

Problem solved - I appreciate your time and effort.

Not sure of the root cause, but I eliminated the DoCmd.Transferdatabase and
I just linked the table directly.
 
Top