Results 1 to 3 of 3
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    use tablrs from secure access db in non secure fe

    Ok. I can do this with ado code.
    But...Is there an easier way to link a table from a user security access database.
    The FE is access but is not part of the secure mdw.
    And i only want to reference 2 tables.
    It appears to not be possible with a standard link.
    I have not tried yet but can i set the recordset of a form to the ado recordset.
    I seem to remember doing this once with an adp file but this is an mdb.
    Not a big issue.
    I have a solution, but wondered if i had missed something simple.
    Last edited by AndrewKKWalker; 2012-02-12 at 21:42.
    Andrew

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    That was tables not tablrs.
    I hate typing on this phone.
    I must wear my glasses!
    Last edited by AndrewKKWalker; 2012-02-12 at 21:43.
    Andrew

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    If (and that is a big IF) it is really secured to the point where you cannot open the database without being connected to the correct .mdw file, then I don't know of a way to link to a table, or to do it in code either with ADO or with DAO. I'm curious what your solution is?
    Wendell

Posting Permissions

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