Re: Password problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: test (no_at_email.here)
Date: 05/06/04 

Date: Thu, 6 May 2004 13:31:36 +0930

Joe, I'm a little confused by your new description of what you are doing.
Could you please amend the following step-by-step description to ensure it
is correct, and answer the questions "in line" where they occur. Then we can
take it from there. I need the information in this specific, step-by-step
format. A general narrative description is too easy to misunderstand.

Is this correct:

Unsecured database #1 executes code which:
   1. opens Secured database #2;
   2. runs some forms (in database #2) which:
          3. import some data from database #1, then
          4. try to update some data in database #1.

Step 4 fails with an error saying that the user does not have sufficient
permissions to perform that update. Correct?

When you start db #1, does it ask for a username/password? If so:
- what username do you enter?
- does that user have permission to perform, >in db #1<, the update which
step 4 tries to perform "remotely"?

When db #1 starts db #2, I gather it asks for a username/passwiord. What
username do you enter?

Cheers,
TC

"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:899801c4328c$dd4f52b0$a301280a@phx.gbl...
> Database #1 is not secured and after data has been
> imported into this database I want to open database #2
> which is secured, this in turn would pull some data from a
> table linked to database #1 and produce a report which
> combines data from both tables. I accept that the approach
> is not ideal but this is the way the databases have
> evolved and it would be a big job to re-write both
> databases.
>
> The current user of database #1 has a user account on
> database #2 with the required permissions to carry out the
> tasks.
>
> The logon screen does appear but this obviously does not
> have a reference to the settings normally retrieved when
> started from the desktop icon. I.e.
>
> "C:\Program Files\Microsoft Office\2000
> \Office\MSACCESS.EXE" "C:\Documents and Settings\Joe\My
> Documents\Van Run05.mdb" /WRKGRP "C:\Documents and
> Settings\Joe\My Documents\Secured1.mdw"
>
> Your further advice would be appreciated.
> Joe
>
> >-----Original Message-----
> >So, >secured< database #1 executes code which:
> > 1. opens >unsecured< database #2;
> > 2. runs some forms (in database #2) which:
> > 3. import some data from database #1, then
> > 4. try to update some data in database #1.
> >Step 4 fails with an error saying that the user does not
> have sufficient
> >permissions to perform the update.
> >
> >Is all that correct?
> >
> >Does the current user of database #1 have permission to
> perform the update
> >in question?
> >
> >When the code opens database #2, does Access prompt for a
> username/password?
> >
> >TC
> >
> >
> >"Joe" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:7e8001c431cf$8ef049c0$a401280a@phx.gbl...
> >> Hi TC
> >> As you suggest database security is perhaps the
> >> underlining problem, which is preventing the queries
> >> running. The open database, which after importing data
> >> attempts to update the second, is not secured, other
> than
> >> the fact that it opens at the switchboard and the
> database
> >> window is hidden. The database, which I want to update,
> >> has had the security wizard applied and has two users
> >> accounts both of whom have the necessary permissions to
> >> carry out the required tasks. I have tried making a copy
> >> of the first database and creating accounts the same as
> in
> >> the second and running the security wizard, which was
> >> unsuccessful.
> >> Where should I go from here?
> >> Thanks Joe
> >>
> >> >-----Original Message-----
> >> >Joe, you won't get any good answer to this question
> until
> >> you post more
> >> >information on how the security has been established
> for
> >> both databases. How
> >> >many workgroup files are you using? What users are
> >> defined in each file?
> >> >Which file was used to create which database?, and so
> on.
> >> >
> >> >Access security is a very complex topic. RWOP queries
> >> >might< be the answer,
> >> >but there is waaaaaaay more to those than
> simply "setting
> >> the queries run
> >> >permissions to owner's".
> >> >
> >> >HTH,
> >> >TC
> >> >
> >> >
> >> >"Joe" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:75d201c430f1$b94adfc0$a501280a@phx.gbl...
> >> >> I posted the following question on April 19th:
> >> >>
> >> >> I use the following code to open another Access
> database
> >> >> and open a form, which has code, attached to the open
> >> >> event. The code uses an update query to pull
> information
> >> >> from the first database, and then runs a report that
> is
> >> >> dependant on that update. My problem is that access
> >> >> complains that the user does not have the necessary
> >> >> permissions to run the update queries, is it
> possible to
> >> >> pass user and password details to the second database
> >> >> logon form from the first database code. I have tried
> >> >> setting permissions to allow the updates in the
> second
> >> >> tables security settings, without success.
> >> >>
> >> >> Dim objAcc As New Access.
> >> >> Set objAcc = GetObject("C:\Documents and
> >> >> Settings\Joe\My Documents\Van
> >> >> Run05.mdb", "access.application")
> >> >> objAcc.UserControl = True
> >> >> objAcc.DoCmd.OpenForm "frmfuelweek"
> >> >> DoCmd.OpenForm "frminstruct", acNormal, "", "", ,
> >> >> acNormal
> >> >>
> >> >> I have been away on holiday and on my return Bill
> Taylor
> >> >> had suggested setting the queries run permissions to
> >> >> owner's instead of user's. Unfortunately this does
> not
> >> >> work. I have tried running the two queries on the
> second
> >> >> database directly from the first but the database
> still
> >> >> complains that the user has no read permissions on
> the
> >> >> underlying table.
> >> >> Any help with this problem much appreciated.
> >
> >
> >.
> >

Relevant Pages

  • Re: Password problem
    ... looked at the permissions as you requested and they appear ... all permissions suggesting that joe be allowed read write ... I still wonder about the reference to the database mdw ...
    (microsoft.public.access.formscoding)
  • Re: Unified Login with TSWEB
    ... connection without ever presenting the user with a USERNAME/PASSWORD ... The wrapper web page would query a database to ensure that ...
    (microsoft.public.windowsxp.security_admin)
  • Re: restricted access
    ... when your system "gets" the PDF ... database 'files' table (the file name, the real location on the server, ... you could go with .htaccess entirely. ... And asking people to enter a username/password more ...
    (alt.php)
  • All databases including new ones require password!
    ... I have been practicing Access 2000 with the Northwind database and ... attempting to set security. ... not using it I came back to make a new database and found I could not open ... username/password say security is not set. ...
    (microsoft.public.access.security)
  • Re: You do not have necessary permissions error...
    ... Crystal asking for a username/password. ... Joan Wild ... Microsoft Access MVP ... is the error i get when i try to access my database. ...
    (microsoft.public.access.security)