Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cannot open two Access database togather

Discussion in 'Information Technology' started by naveen via AccessMonster.com, Jul 28, 2006.

  1. naveen via AccessMonster.com

    Guest

    Hi!! Everyone

    I am not able to to open two access 2002 files (database at the same time). I
    can work with one of them but if i will try to pen another access file
    (database) it doesn't gets opened. It will be great if some one can help me.

    Thanks
    naveen

    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     
  2. Loading...

    Similar Threads Forum Date
    Cannot Find A Thread ? Try "Search by Tag." Announcements Jan 21, 2013
    I cannot Keep My Hair No Longer Sikh Youth Aug 8, 2012
    India Govt cannot change purpose of acquired land: SC Breaking News Oct 6, 2011
    USA TSA: Body Scanners Cannot See Through Turbans Breaking News Jan 14, 2011
    India India cannot help but be complex Breaking News Oct 2, 2010

  3. ChrisM

    ChrisM
    Expand Collapse
    Guest

    "naveen via AccessMonster.com" <u16003@uwe> wrote in message
    news:62bc7172f4ced@uwe...
    > Hi!! Everyone
    >
    > I am not able to to open two access 2002 files (database at the same
    > time). I
    > can work with one of them but if i will try to pen another access file
    > (database) it doesn't gets opened. It will be great if some one can help
    > me.
    >
    > Thanks
    > naveen
    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1


    Hi Naveen,

    Not sure if I understand your question, but I'll answer what I THINK you're
    saying:
    If you're trying to open multiple databases in a single instance of Access,
    (like you open multiple documents in Word), then that is not possible.
    However, you can start 2 (or more) instances of Access, and open a single
    database in each one.

    Hope this helps,

    ChrisM.
     
  4. naveen via AccessMonster.com

    Guest

    Thanks chris

    I have understood the problem now. i wanted to open two instances of access.
    I think its a MSaccess bug.
    I tried opening the database through a blank access file(start -> access) and
    it did let me open the two instances of access.(one database in each)
    anyways thanks for your advise
    naveen
    ChrisM wrote:
    >> Hi!! Everyone
    >>

    >[quoted text clipped - 6 lines]
    >> Thanks
    >> naveen

    >
    >Hi Naveen,
    >
    >Not sure if I understand your question, but I'll answer what I THINK you're
    >saying:
    >If you're trying to open multiple databases in a single instance of Access,
    >(like you open multiple documents in Word), then that is not possible.
    >However, you can start 2 (or more) instances of Access, and open a single
    >database in each one.
    >
    >Hope this helps,
    >
    >ChrisM.


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "naveen via AccessMonster.com" wrote

    > I have understood the problem now. i
    > wanted to open two instances of access.
    > I think its a MSaccess bug.


    No, it is "working as designed" and has been documented to work that way
    ever since Access 1.0 was first released in 1992.

    Larry Linson
    Microsoft Access MVP
     
  6. naveen via AccessMonster.com

    Guest

    HI!! Larry
    Till a week ago i used to open the two access instances by simply double
    clicking on the file itself one after another. But now if i open a access
    database and try opening another one by double clicking on the second one (on
    my windows explorer) it doesn't lets me do so. So what may be the reason? Is
    it my access setting problem or something else? Please let me know.

    Thanks
    naveen

    Larry Linson wrote:
    > > I have understood the problem now. i
    > > wanted to open two instances of access.
    > > I think its a MSaccess bug.

    >
    >No, it is "working as designed" and has been documented to work that way
    >ever since Access 1.0 was first released in 1992.
    >
    > Larry Linson
    > Microsoft Access MVP


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     
  7. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "naveen via AccessMonster.com" wrote

    > Till a week ago i used to open the two
    > access instances by simply double
    > clicking on the file itself one after another.


    I mis-read your earlier post. Yes, that will be running two copies of
    Microsoft Access, each with a different database, and it should work.

    > But now if i open a access database and
    > try opening another one by double clicking
    > on the second one (on my windows explorer)
    > it doesn't lets me do so. So what may be
    > the reason? Is it my access setting problem
    > or something else? Please let me know.


    If there are no Access databases open, can you open the first one by double
    clicking the MDB file, or do you have to open Access and then select the DB?
    If not, then you may need to reset your Windows file associations. Open a
    Windows Explorer window, on the menu Tools | Folder Options and make sure
    that file types .MDB, .MDE, .MDW, .ADP, and .ADE are associated with
    Microsoft Access. If the first Access DB opens by double-clicking, then this
    is a problem I have never encountered.

    Can you open a second MDB by opening Access itself and then selecting that
    MDB?

    Larry Linson
    Microsoft Access MVP
     

Share This Page