Search results

  1. D

    All records in table disappeared

    In our case, its less about keeping unauthorized people out, and more about preventing unauthorized people from adding new, and more importantly, altering existing data accidentally or on purpose.
  2. D

    All records in table disappeared

    I had that thought, so I went through all of the other user forms, and the particular combination that allowed this to happen doesn't exist anywhere else.
  3. D

    All records in table disappeared

    Good points I hadn't considered. Thank you for taking the time to reply. And we've already violated one of the usability rules, as we currently have 12 active users.
  4. D

    All records in table disappeared

    I've done some Googling, but I haven't been able to find an explanation of why using a combo box is a greater security risk versus using a textbox for the user name on a login form. Can anyone educate me, or point me to a resource that explains this concept?
  5. D

    All records in table disappeared

    So, I think I may have figured it out. The Login form Data Properties had "Allow Deletions" set to Yes. By setting it to No, it appears to prevent this from happening.
  6. D

    All records in table disappeared

    The plot thickens. A supervisor just came up to me and said, one of my people said something weird happened Monday morning (Oh boy here we go). He was logging in, and while he was typing his password in the password field in the login form, he realized he'd made a mistake, so he pressed Ctrl A...
  7. D

    All records in table disappeared

    The only user that has the nav pane, full ribbon, right click or other menus is me. The BE itself is not secured via password, and its the only thing I can think of. Though to say most of our workforce isn't the most tech savvy is being kind, so someone would have first, been able to locate the...
  8. D

    All records in table disappeared

    There is no way to delete a user in the front end. If a user has sufficient privileges, ( via a hidden test at login) they have the ability to mark a user as inactive, and an inactive user can no longer login. This user does not have that privilege.
  9. D

    All records in table disappeared

    I have a split database with about 15 users, each with their own front end. The back end is housed on a NAS on our company LAN. There is also a Datto backup device that backs up the NAS regularly throughout the day. The front end has a login form that pulls from a user table. The login form...
  10. D

    Sending SMS to phones.

    https://www.makeuseof.com/tag/email-to-sms/
  11. D

    Excel to Access Data Connection Multiple Users Question

    I was able to find something. If you use the "From Other Sources" option in Excel's "Get External Data" tool, you can choose "From Microsoft Query". Once you've connected to the desired tables, you basically roll your own query from inside Excel, including pulling from multiple related tables...
  12. D

    Excel to Access Data Connection Multiple Users Question

    Yes the second thing.
  13. D

    Excel to Access Data Connection Multiple Users Question

    I have a split database, and each user has their own FE. A couple of folks in the office would like to pull data from it. Both setups call for pulling from a query I made for them that reside in the BE. I setup their Excel workbook connections for them, and everything works until someone is...
  14. D

    Struggling with an Inventory Tacking DB

    Mark, Yes, we do have to maintain information on all batches manufactured, but that is beyond the scope of this project. As I mentioned before, I built an Access application that manages QA and Technical Services documents, that is a small part of that, and why some batch information is pulled...
  15. D

    Struggling with an Inventory Tacking DB

    Pat, Yes, with a few exceptions, we are on demand. We have a few part numbers that aren't that we manufacture a batch of, and essentially manage the shipping and inventory for our customer. These part numbers are manufactured in large batches like all of our products, but are shipped/sold in...
  16. D

    Struggling with an Inventory Tacking DB

    Plog, Thank you for taking the time to do that. There are a bunch of redundant tables/relationships in there as I was trying different things. I apologize. I should have cleaned it up first, and it's still a mess even after cleanup. The whole thing is going on the scrap heap. Mark, That's a...
  17. D

    Struggling with an Inventory Tacking DB

    How about the whole thing? This is the latest iteration. I think Im getting close, but...
  18. D

    Struggling with an Inventory Tacking DB

    Short description, the thing will hinge on two things, Batches (that we manufacture) and Purchase Orders (that we receive from customers). The fields that really matter are these Batch Table ProductID Quantity Manufactured Ready Status Date of Manufacture Purchase Request Table...
  19. D

    Password Protecting Backend of Split Database

    Thank you for pointing me to the folder permissions facet of all this. I finally got a chance to take a look. My sandbox application was stored on a shared volume attached to a Netgear rounter, using the ReadyShare application that comes with these routers. For some reason I don't understand...
  20. D

    Password Protecting Backend of Split Database

    Its just my helper (a cooperative co-worker) and myself. No one else.
Top Bottom