Recent content by Access9001

  1. A

    Backend folder vs. frontend database

    I think that may be exactly what I need... thank you both!
  2. A

    Backend folder vs. frontend database

    How would I do this in Windows?
  3. A

    Backend folder vs. frontend database

    What about something like MySQL?
  4. A

    Backend folder vs. frontend database

    Can it be combined with the DBF dumping process (pulling DBFs into SQL Server for new tables daily).
  5. A

    Backend folder vs. frontend database

    Currently we have a sort of central program that dumps .dbf files daily and we take these into Access and perform make-tables, etc, to create a variety of tables and queries for use. However, I don't think SQL Server will let me "pull in" and update/recreate the tables in the same way, right?
  6. A

    Backend folder vs. frontend database

    How would using SQL Server Express work? Would it need an entirely new machine to dedicate to running the actual server software/etc?
  7. A

    Backend folder vs. frontend database

    I already do that; my question is about the actual backend folder. Say I have G:\Backend\Backend.mdb and G:\Frontend\Frontend.mdb I don't want anyone even *wandering* into the Backend folder through pure navigation. I want to somehow close that folder off so people can't get into it and poke...
  8. A

    Backend folder vs. frontend database

    If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db? Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck...
  9. A

    Filter out rows iteratively?

    Alright, I will look into another way. Thank you.
  10. A

    Filter out rows iteratively?

    I want to be able to go down my rows and, with VBA, filter out any number of arbitrary rows. I'm not looking into hiding rows but rather filtering them so I can always turn them back on later with .ShowAllData.. Is this doable?
  11. A

    How do I change a field name in a query without breaking everything else that uses it

    I have a query with a field labeled OldName. I want to rename it to NewName. However, when I do this, other queries that either have joins/relationships/whatever you call them on OldName break because they can't find OldName after the renaming.
  12. A

    Summing values in a report where value > 0?

    I have a report where I currently sum values by doing =sum([VariableName]) but I'd like it to only include values for which they are >0... is this doable?
  13. A

    Automatically updating/relinking certain references?

    error : "Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSO.DLL' version 2.4.
  14. A

    Automatically updating/relinking certain references?

    I don't know what that is. In this case I am trying to remove Office library version 12.0 and adding Office library version 11.0 (mso.dll)
  15. A

    Automatically updating/relinking certain references?

    Same thing
See more
Back
Top Bottom