Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Problem with Access 2007


    I am converting databases from Access 2003 to Access 2007. I have two databases, one with code, reports, etc. the other with data. The one with data has been password protected. How do you send the password to the data database from the code in a form in the program database so that you can access linked data tables in the data database. Thanks for any help. I feel pretty silly but I have wasted several hours looking and cannot find any help. I miss the user level security.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    User Level Security continues in A07 if you remain in the .mdb format.

    If you are going to .accdb; what you might consider doing is opening a new .accdb db and then importing the tables. Not 100% sure, but I would give it a try.

    Hope this helps.

  3. #3
    DaveT is offline Access Developer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Location
    Texas
    Posts
    69
    You can link to a backend, data file from code in the front-end using the connect (string) property such as:

    tdf.Connect = "MS Access;DATABASE=C:\aProjects\aDEV\DevDemoDat.accdb ;TABLE=DemoTable;Pwd=daLLas"

    If the table was linked before, you use tdf.RefreshLink; if you need to add the table to the front end entirely, use dbs.TableDefs.Append tdf.

    I've left out most of the code. If you're familiar with linking through VBA, you can fill in the blanks, otherwise I can provide more detail.

    The objects used in the snippet above are:

    Dim dbs As DAO.Database
    Dim tdf As DAO.TableDef

    I use this to link/re-link tables in an Access 2007 accdb data file that is password protected.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2007 to Access 2010 Problem
    By evalmedi in forum Access
    Replies: 1
    Last Post: 10-24-2010, 02:56 PM
  2. Dlookup Problem in Access 2007
    By doquan0 in forum Programming
    Replies: 1
    Last Post: 08-27-2010, 05:41 AM
  3. Problem with label in Access 2007
    By Madraykin in forum Forms
    Replies: 4
    Last Post: 02-04-2010, 10:41 AM
  4. Access 2007 Users and Permissions Problem
    By botts121 in forum Security
    Replies: 3
    Last Post: 07-06-2009, 10:23 AM
  5. Problem using the combo box Access 2007
    By PATATE in forum Access
    Replies: 11
    Last Post: 05-23-2009, 06:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums