从Visual Basic 9.0升级Access数据库（VS2008） [英] Upgrading an Access database from Visual Basic 9.0 (VS2008)

问题描述

您好。

我有一个用Visual Basic 9.0（Visual Studio 2008）编写的Windows桌面应用程序。 此应用程序将其数据存储在Access数据库中。 它已经存在了很长时间，最初在十年前创建的一些数据库采用
Access 1997或Access 2000格式。 

I have a windows desktop application written in Visual Basic 9.0 (Visual Studio 2008).  This application stores its data in an Access database.  It has been around for a long time, and some of databases originally created a decade ago are in the Access 1997 or Access 2000 format. 

我试图计算一种方法将这些数据库升级到Access 2003格式或Access 2007格式， 就像使用Microsoft Access打开数据库并使用数据库转换工具一样。 在这种情况下使用转换
工具不是一个选项，因为我不能直接访问数据库（它们位于遍布各地的自定义位置）。

I am trying to figure out a way to upgrade these databases to either the Access 2003 format or the Access 2007 format,  just as you would if you opened the database using Microsoft Access and used the database conversion tool.  Using the conversion tool in this case isn't an option because I don't have direct access to the databases (they are at custom locations spread out all over the place).

我所尝试的是使用作为DOA和JRO一部分的紧凑方法来压缩数据库并将其升级为更新的格式。 紧凑方法有一个选项来指定新格式。 但是，执行此操作后，我使用Microsoft Access桌面产品打开数据库
，它仍然显示它是旧格式。 因此，通过紧凑方法进行的升级与Access内置的转换工具不同。

What I have tried is to use the compact method that is part of DOA and JRO to compact the database and upgrade it to a newer format.  The compact method has such an option to specify the new format.  However, after doing this, I open the database with the Microsoft Access desktop product and it still shows it is in the older format.  So, the upgrade via the compact method isn't doing the same thing as the conversion tool built into Access.

我的最终目标是将客户机器上的这些生产数据库转换为更新版本访问。 话虽如此，如果我只知道我应该用什么技术来操纵Access
数据库的结构，它可能会取得进展。 我目前正在使用DAO，但不再支持。  JRO没有用。  对于SQL Server，我只写了'create table'和'alter column'等sql语句。 此方法不适用于Access。 

My ultimate goal is to convert these production databases on customer machines to a newer version of Access.  Having said that, it might be able to make progress if I just knew what technology I am supposed to use to manipulate the structure of an Access database.  I am currently using DAO, but that is no longer supported.  JRO didn't work.  For SQL Server, I just write sql statements like 'create table' and 'alter column'.  This method does not work for Access. 

任何想法？

谢谢！

Andy

推荐答案

Hello Andy，

Hello Andy,

我正在将线程从VB论坛转移到Access for Developers来自Access专家的更好回复的论坛。

I am moving the thread from VB forum to Access for Developers forum to get better responses from experts on Access.

实际上，根据我的了解，将Access 97文件转换为07文件格式的唯一方法是使用Access内置转换工具作为你已经找到了。

Actually, based on my knowledge, the only way to convert Access 97 file to the 07 file format is using the Access built in conversion tool as you already found.

 

祝你好运，

Ji Zhou - MSFT

Microsoft在线社区支持

Best regards,
Ji Zhou - MSFT
Microsoft Online Community Support

这篇关于从Visual Basic 9.0升级Access数据库（VS2008）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！