Results 1 to 6 of 6
  1. #1
    Paul1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    50

    Question Opening database opens a second database - no linked tables

    I would appreciate if someone could explain why when I open an Access database a second database in the same folder is opened (the record locking file is created). There are no linked Access tables in the first database. There are however linked ODBC tables from a different source.
    Many thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,010
    EVERY db ,accdb (or .mdb) opens a lock file (.ldb ) to control record locking.
    Ignore it.

  3. #3
    Paul1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    50
    Thanks but when I open database 1 then database 2 opens a lock file. There is no connection between database 1 and database 2. There are no linked tables.
    I am trying to understand this behaviour?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,010
    if the db is open, a lock file opens to control record locking.

  5. #5
    Paul1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    50
    Thanks again but database 2 is not open and only opens when I open database 1. No one else is using database 2 and there is connection between the two databases. I would appreciate if someone could explain this odd behaviour.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,684
    If there are no linked tables, then there must be code somewhere that opens the 2nd database.

    You could post your dB for analysis........
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Linked tables on Mysql Database
    By sdel_nevo in forum Programming
    Replies: 5
    Last Post: 04-27-2016, 02:12 PM
  2. Replies: 4
    Last Post: 02-11-2014, 02:40 PM
  3. No (+) for parent-child tables in linked database
    By Seamus59 in forum Import/Export Data
    Replies: 3
    Last Post: 11-18-2013, 11:39 AM
  4. Opening tables for important database
    By SemiAuto40 in forum Programming
    Replies: 5
    Last Post: 04-19-2012, 10:30 AM
  5. Split Database having Linked Tables
    By ranjitdv in forum Access
    Replies: 2
    Last Post: 07-20-2011, 12:46 PM

Posting Permissions

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