无法在MSAccess中已设计的表中添加新列 [英] Cannot add new column in already designed Table in MSAccess

问题描述

尊敬的先生，

我正在使用VB.NET开发Windows应用程序，其中我使用MSAccess 2007作为数据库.
在设计了整个数据库之后，我已经在我的应用程序中成功使用了它. 但是后来对现有表进行了一些更改..
当我在特定表中添加另外一列..并运行应用程序时，它第一次成功运行，但是当我再次运行时，错误就出现了该列不存在..当我打开设计表但不存在时.
那么我每次运行都会一次又一次地添加同一列.

有什么问题.为什么会这样?
请帮助我.....

谢谢..

Respected Sir,

I am developing windows application with VB.NET,in which i m using MSAccess 2007 as database..

After designed whole database,i have used it in my application successfully..
but later on some changes came into existing table..
when i add one more column in particular table..and run application then its works first time successfully but when i run again then error comes that column not present..when i open design table but column was not present.
then i have again add same column again and again for every run.

What is the problem..why this is happening?
Please help me.....

Thank you..

推荐答案

您是否已将其部署到应用程序上方或从源代码(IDE)运行?

Have you Deployed above application or running from the source code (IDE) ?

您可能添加了在BIN \ Debug或BIN \ Release文件夹中找到的数据库副本的列，对吗?

每次您从IDE运行项目时，该数据库副本都将被项目文件夹(位于BIN文件夹之上)中的原始文件覆盖.

You probably added the column to the copy of the database you found in the BIN\Debug or BIN\Release folder, correct?

That copy of the database gets overwritten by the original file in your project folder (above the BIN folder) every time you run the project from the IDE.

这篇关于无法在MSAccess中已设计的表中添加新列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！