Welcome to SPN

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

Sign Up Now!

Migration from 97 to 2003 - users accessing same db on both NT & X

Discussion in 'Information Technology' started by Ed H, Nov 17, 2005.

  1. Ed H

    Ed H
    Expand Collapse
    Guest

    I thought I read somewhere that you could choose not to convert the access db
    which would be okay other than you would not be able to take advantage of
    functionality 2003 brings in.

    Dilema is we are in the process of upgrading from NT (Office 97) to
    XP(Office 2003) and we will have people from both worlds that want to access
    (pardon the pun) the same data. I thought I read it was possible to create a
    2003 front end that went after a 97 format DB. When I choose to not convert
    the database, it says it is read only and I can not save my VB changes.

    Any thoughts
     
  2. Loading...

    Similar Threads Forum Date
    Reincarnation / Transmigration: Revisited & Re-explored Intellectual Articles Apr 9, 2015
    Canada Racist Anti-immigration flyers single out Sikh community in Brampton Breaking News Apr 25, 2014
    Canada MP pleads with immigration minister not to deport elderly sikh woman Breaking News Dec 12, 2012
    Canada Canada Immigration Reform: Jason Kenney Seeks Young, Educated, Skilled And Fluent Newcomers Breaking News Oct 31, 2011
    Opinion Distress pushing migration in India Punjab, Punjabi, Punjabiyat Oct 1, 2011

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "Ed H" <EdH@discussions.microsoft.com> wrote in message
    news:40732EC0-84D4-4747-8524-93757B053A75@microsoft.com...
    >I thought I read somewhere that you could choose not to convert the access db
    > which would be okay other than you would not be able to take advantage of
    > functionality 2003 brings in.
    >
    > Dilema is we are in the process of upgrading from NT (Office 97) to
    > XP(Office 2003) and we will have people from both worlds that want to access
    > (pardon the pun) the same data. I thought I read it was possible to create a
    > 2003 front end that went after a 97 format DB. When I choose to not convert
    > the database, it says it is read only and I can not save my VB changes.
    >
    > Any thoughts


    You leave the common back end in 97 but make converted front ends in the new
    version. If you want to make design changes to the front end using 2003 you do
    have to convert a copy of it before you can do so.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    That's true of all versions of Access, you can read and write the data from
    earlier version(s), but you cannot change the definitions in an earlier
    version.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Ed H" <EdH@discussions.microsoft.com> wrote in message
    news:40732EC0-84D4-4747-8524-93757B053A75@microsoft.com...
    > I thought I read somewhere that you could choose not to convert the access

    db
    > which would be okay other than you would not be able to take advantage of
    > functionality 2003 brings in.
    >
    > Dilema is we are in the process of upgrading from NT (Office 97) to
    > XP(Office 2003) and we will have people from both worlds that want to

    access
    > (pardon the pun) the same data. I thought I read it was possible to

    create a
    > 2003 front end that went after a 97 format DB. When I choose to not

    convert
    > the database, it says it is read only and I can not save my VB changes.
    >
    > Any thoughts
     
  5. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    "Ed H" <EdH@discussions.microsoft.com> wrote in message
    news:40732EC0-84D4-4747-8524-93757B053A75@microsoft.com...

    > Dilema is we are in the process of upgrading from NT (Office 97) to
    > XP(Office 2003) and we will have people from both worlds that want to
    > access
    > (pardon the pun) the same data. I thought I read it was possible to
    > create a
    > 2003 front end that went after a 97 format DB. When I choose to not
    > convert
    > the database, it says it is read only and I can not save my VB changes.


    Don't try and convert the data part, just leave it as access 97. what you do
    is split the database (do this in a97).

    You then wind up with two parts, the data part (you leave in a97), and the
    application part. You simply convert the application part to a2003, and give
    that to a2003 users. You give a a97 application part to a97 users, and they
    both can happy use the same data.

    If you are new to splitting, then you can read the following :

    http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

    Even after you get eveyone on a2003, you need to split if you plan to use
    this data in multi-user mode anyway...

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  6. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Is your database application split into Front-End and Back-End?

    The Back-End can stay in A97 (JET 3.5) file format. You will need 2
    versions of the Front-End, one for Access 97 users and one for Access 2003
    users.

    If you use Access 2003, you can only modify the Front-End file in A2000 or
    A2002/A2003 file format. If necessary, you can convert a copy back to A97
    file format for A97 users.

    --
    HTH
    Van T. Dinh
    MVP (Access)




    "Ed H" <EdH@discussions.microsoft.com> wrote in message
    news:40732EC0-84D4-4747-8524-93757B053A75@microsoft.com...
    >I thought I read somewhere that you could choose not to convert the access
    >db
    > which would be okay other than you would not be able to take advantage of
    > functionality 2003 brings in.
    >
    > Dilema is we are in the process of upgrading from NT (Office 97) to
    > XP(Office 2003) and we will have people from both worlds that want to
    > access
    > (pardon the pun) the same data. I thought I read it was possible to
    > create a
    > 2003 front end that went after a 97 format DB. When I choose to not
    > convert
    > the database, it says it is read only and I can not save my VB changes.
    >
    > Any thoughts
     

Share This Page