Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Unanswered: Copy mdb without user restriction

    Hi all!

    Normally all mdb files are User-Restricted here. But I need to send a mdb file via email to a person outside. So he has no Username/Password.

    Can I save the mdb so that no user/pwd is needed to open it?
    Do I need Administrator-Account or s.t. like that?

    Thanks in advance,

    Maz

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    If you have a password on the DB then he would need it. You said, "he has no Username/Password."; does that mean to use your PC- as in log on. I suspect that is the case, and assume you have already tried to email it & have failed. In which case, your company has some firewall settings stopping you. If true, see your company IT help desk.

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    My company won't let me even send a 30kb DB through our intranet...good luck sending to the outside
    Ryan
    My Blog

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    With all due respect, if you don't have access to the unpassworded version of the database, you probably shouldn't be sending it around to people who don't possess valid usernames and passwords.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    One thing to remember: If you have the password you can open a new DB and import the objects from the password protected DB ... It's another thing if you should do so tho ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Jul 2004
    Posts
    1
    Thanks for the hints,

    but it's allowed for me to send this db file with email. It's data is made for the people outside.
    The mdb file is recieved without problems. It's not a firewall problem.

    But we already found a way to solve the problem:

    Import it in ACCESS 2000 (it was a ACCESS 97 db) and change the System.mdw / System.mda to get the user restriction out of the db.

    Bye,

    SuperMaz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •