Table Security in Access 2013

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

  1. Jeff1470


    Nov 1, 2017
    Likes Received:

    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.
    Jeff1470, Nov 1, 2017
    1. Advertisements

Ask a Question

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.