Creating an Office XP compatible database?

dkomo

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?
--*****@cris.com

Jul 17 '05 #1

Subscribe Post Reply

3600

John Simpson

This is a compatibility issue with vibe and Access. You need VB6 SP5 and/or
the newest version of MAC.
"dkomo" <dk*********@cris.com> wrote in message
news:40***************@cris.com...

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?
--*****@cris.com

Jul 17 '05 #2

Similar topics

creating a word document from php

by: EJ | last post by:

Does anyone know if there is a class for creating doc files? I have seen ones for pdf and excel spreadsheets. Thanks in advance.

PHP

Creating a database is slow on Windows XP

by: Dim St Thomas | last post by:

I am a developer working on a database client program. I am testing this program on a Windows XP machine (1.5 GHz AMD chip, 480 Mb RAM, 60 Gb disk) This machine has Oracle 9.2.0.1.0 and RedBrick...

Oracle Database

MS Access '97 and MS-Office XP-SBE, would it work?

by: davidl | last post by:

Hello, I apologize if this been asked earlier many times; I use MS-Office XP Small Business Edition, which doesn't include MS-Access - but I own the older Office '97 Pro (not installed) though...

Microsoft Access / VBA

Open Office 2.0 import to dBase from text & spreadsheets

by: Java script Dude | last post by:

For those who are missing the feature on how to import into Open Office dBase app from text files and spreadsheets in OOO Base 2.0: A wizard exists to import from spreadsheets only at this time...

Microsoft Access / VBA

Problem: Windows Service creating Outllook object

by: W Akthar | last post by:

Hi I am trying to create a windows service which queries SQL Server on timed intervals and depending on the results send appointments to Outlook. The problem lies when I try to create an...

C# / C Sharp

Office XP Primary Interop Assemblies

by: J-T | last post by:

I'm trying to read an excell file in my .Net application using Office XP Primary Interop Assemblies (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp)....

C# / C Sharp

Creating a plug-in based WebApp

by: Mats Lycken | last post by:

Hi, I'm creating a CMS that I would like to be plug-in based with different plugins handling different kinds of content. What I really want is to be able to load/unload plugins on the fly without...

ASP.NET

creating an excel file from .net application

by: Paul | last post by:

Hi I have created an excel file download feature within a .net application using Microsoft Office XP primary interop assembly for excel. I was just wondering if anyone knows if you can also embed...

ASP.NET

Create Excel without installing MS office

by: =?Utf-8?B?UHJpeWE=?= | last post by:

Hi, I'm developing a webservice whicg reads data from a database and exports to a excel sheet. This applciation works if i have MS Office installed in my system . Since i'm unable to install MS...

.NET Framework

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA