Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CathyLynnHughes

    Determine What Users are Logged into Database

    I created a shared Database on one drive. The Default Format is Access 2000. When the database crashes, every user must log off so that the database can be repaired. I need some kind of code that I can use from an independent database to determine who is still logged into the database that...
  2. CathyLynnHughes

    Prevent Unauthorized User from Accessing Database

    Dear Ed2020 I have already removed the rights from the "Admin" user in the "Users" view in the permissions window. As I stated before, I have also removed the Admins Group Permissions. This has all been done in the System.MDW where I have the security set-up. Do I also have to do this in the...
  3. CathyLynnHughes

    Prevent Unauthorized User from Accessing Database

    Dear ED2020, My provisioners get into the database through a desktop shortcut that combines the System.mdw and the database ("C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "P:\Portout Database\PortOut Database .mdb" /wrkgrp "P:\Portout Database\System.mdw"). This works fine...
  4. CathyLynnHughes

    Prevent Unauthorized User from Accessing Database

    The password for the database works great to prevent unauthorized access to the database, but I have a different problem with authorized users. I mentioned that I initially go into an authorized user’s computer through Security/Workgroup Administrator and click join so that his database is...
  5. CathyLynnHughes

    Prevent Unauthorized User from Accessing Database

    Dear barny2006, The database password idea (tools, security, set database password) worked great. Thank you.
  6. CathyLynnHughes

    Prevent Unauthorized User from Accessing Database

    I have security set up on my Access Database (Tools/Security/User and Group Permissions/User and Group Accounts). I have removed all access for Users Group and created other groups that have access. My provisioners get into the database through a shortcut that combines the System.mdw and the...
  7. CathyLynnHughes

    Find Function of Edit Menu is Slow in Shared Database

    Dear PHV, The code that you suggested to find the ATN is wonderful. It worked. Thank you.
  8. CathyLynnHughes

    Find Function of Edit Menu is Slow in Shared Database

    Dear SeeThru, Using recordsetclone worked well for finding a record number (AutoNumber). This is the code I used: 'Declare variable for value of Record Number 'that user wants to find. Dim strResponse As String 'Assign value of Input Box to Record Number variable...
  9. CathyLynnHughes

    Find Function of Edit Menu is Slow in Shared Database

    I have a shared database with 25 users. It is not a split database. Users all access the same database using a shortcut. It runs fine most of the time. The only problem is when someone uses the Find feature on the Edit Menu. Depending on the number of users accessing the database at one...
  10. CathyLynnHughes

    Renamed Outlook E-mail Attachment Not Showing Up Correctly

    I’m having a problem with an Outlook attachment when I rename it using Visual Basic in Access 2003. The attachment name is supposed to change every time a new record is entered in Access and the action field is exited. The attachment name is supposed to change to the ATN (phone number) on the...
  11. CathyLynnHughes

    faq702-5263 by Jollygood? (Prevent Mouse Wheel)

    This is in response to a previous question about how to prevent users from leaving current record by scrolling the Mouse Wheel. Jollygood suggested a method in FAQ702-5263. I'm trying to apply it in Access 97. One problem that I'm having is the fact that there is no On Mouse Wheel in the Form...
  12. CathyLynnHughes

    Screen jumps up when I select a tab.

    Dear TheAceMan1, How do I adjust the form to fit the screen?
  13. CathyLynnHughes

    Screen jumps up when I select a tab.

    I am using Access 97. When I click on a tab, the screen scrolls up so that the tabs are no longer visible. On the tab control, I can see the top of my Bound Object form which contains an OLE Object. How can I prevent the screen from scrolling up when I click on a tab?

Part and Inventory Search

Back
Top