Creating an Office XP compatible database?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dkomo
    #1

    Creating an Office XP compatible database?

    I wrote a VB 6.0 program to create an Access database file and fill it
    with data. I used the following DAO statement:

    Set db_AllEquity = ws.CreateDataba se(Database_Nam e,
    dbLangGeneral,
    dbVersion30)

    On my older computer I can open the .mdb file with Office 97 Access
    with no problem

    Then I took the program over to my notebook, which runs under Windows
    XP Pro and has Office XP installed, recompiled the program, and
    recreated the .mdb file. Much to my surprise, Access in Office XP put
    out a message saying the it needs to run a conversion on the .mdb file
    to make it compatible with Access 2000 and Access 2002.

    Does anyone know what's going on here? I have all the latest system
    components installed on the notebook. According to the VB 6.0 online
    manual, the constant dbVersion30 specifies the Microsoft Jet database
    engine version 3.0 file format (compatible with version 3.5). This is
    the most recent version available to VB 6.0.

    What do I need to do to create an Access .mdb file compatible with the
    version of Office XP (2002) that I have?


    --dkomo@cris.com
    Tags: None
    • John Simpson
      #2
      Re: Creating an Office XP compatible database?

      This is a compatibility issue with vibe and Access. You need VB6 SP5 and/or
      the newest version of MAC.


      "dkomo" <dkomoNoSpam@cr is.com> wrote in message
      news:4069ED70.E 21EAC03@cris.co m...[color=blue]
      > I wrote a VB 6.0 program to create an Access database file and fill it
      > with data. I used the following DAO statement:
      >
      > Set db_AllEquity = ws.CreateDataba se(Database_Nam e,
      > dbLangGeneral,
      > dbVersion30)
      >
      > On my older computer I can open the .mdb file with Office 97 Access
      > with no problem
      >
      > Then I took the program over to my notebook, which runs under Windows
      > XP Pro and has Office XP installed, recompiled the program, and
      > recreated the .mdb file. Much to my surprise, Access in Office XP put
      > out a message saying the it needs to run a conversion on the .mdb file
      > to make it compatible with Access 2000 and Access 2002.
      >
      > Does anyone know what's going on here? I have all the latest system
      > components installed on the notebook. According to the VB 6.0 online
      > manual, the constant dbVersion30 specifies the Microsoft Jet database
      > engine version 3.0 file format (compatible with version 3.5). This is
      > the most recent version available to VB 6.0.
      >
      > What do I need to do to create an Access .mdb file compatible with the
      > version of Office XP (2002) that I have?
      >
      >
      > --dkomo@cris.com[/color]


        Comment

        Previous template Next
        Working...