Connecting Tech Pros Worldwide Forums | Help | Site Map

Creating an Office XP compatible database?

dkomo
Guest
 
Posts: n/a
#1: Jul 17 '05
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.CreateDatabase(Database_Name,
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

John Simpson
Guest
 
Posts: n/a
#2: Jul 17 '05

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@cris.com> wrote in message
news:4069ED70.E21EAC03@cris.com...[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.CreateDatabase(Database_Name,
> 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]


Closed Thread