apeterson

apeterson

  • NA
  • 12
  • 0

Question about Access database

Dec 28 2004 1:34 PM
Hi all, I had a question, maybe you guys can shed some light on this for me. I'm working on a web app that I have used an access database to store files and the name of the client that uploads the file to the database. I then use their login info to run a sql query using the clientName field to make sure only the files they should see are being displayed. This is all working fine, however let's say the Admin comes in and wants to upload a file for more than one user to see. I can figure out a way that would work, making the admin's file be stored more than once, or a way that would work if all users should see it, but I for some reason can't figure out how I might do this so that the admin can upload the file and the info would be there for me to run a sql query on and display the file list correctly for the different users. Any help would be much appreciated, Thanks Drew