Table Security in Access 2013

Discussion in 'Access' started by Jeff1470, Nov 1, 2017.

  1. Jeff1470

    Jeff1470

    Joined:
    Nov 1, 2017
    Messages:
    1
    Likes Received:
    0
    Hi

    I haven't managed to get DJ Steel's DSN Code to work (it's on Google), but before I spend my time trying to get it to work.
    I just need to confirm something.
    If the tables in access use DSN Less connections, they will connect without asking for the main password (That's a fact)
    What I need to know is that if someone imports the table into a new database, will they still be able to access the tables?

    Right now, I did test with our current database that is connecting to MySQL via ODBC. But if I import the tables, I can still connect without needing password. That's because I saved the password for linking tables as I do not want our users knowing the main password to get into the tables.

    What is the best route to take on this as this is the only thing I need to do to complete my project for work?

    Much appreciated.
    Jeff
     
    Jeff1470, Nov 1, 2017
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. pledbetter
    Replies:
    3
    Views:
    1,242
    Avon4026
    Jan 31, 2013
  2. phdman
    Replies:
    0
    Views:
    649
    phdman
    Oct 31, 2012
  3. Maxis37
    Replies:
    0
    Views:
    1,768
    Maxis37
    Jul 11, 2013
  4. Timothy Housman
    Replies:
    1
    Views:
    614
    SoftwareMatters
    May 16, 2014
  5. Susan Gottfried
    Replies:
    0
    Views:
    249
    Susan Gottfried
    Mar 3, 2016
  6. student4life
    Replies:
    0
    Views:
    511
    student4life
    Oct 7, 2016
  7. TexSki
    Replies:
    0
    Views:
    171
    TexSki
    Jun 29, 2017
  8. Md. Shohrab Hossain
    Replies:
    0
    Views:
    203
    Md. Shohrab Hossain
    Jul 21, 2017
Loading...