从我的ms-access数据库中自动删除列名 [英] Column name deleted from my ms-access Database Automatically

问题描述

大家好，



我在winform应用程序中遇到一个非常不寻常的问题。我把数据库作为MS-ACCESS数据库扩展名为.accdb并将该文件调用到我的winform应用程序中。



后来我发现我忘了添加一列而且后来我在同一个数据库的表中添加了一列，即条款（没有引号），数据类型为备注



然后我运行我的应用程序调用在我的winform页面中的同一列。



我在winform应用程序中发现该列不存在错误。



当我再次打开我的同一个数据库时，我发现的是从表名中删除了列名Terms。我不知道它是如何发生的以及解决方案是什么。



我甚至再次创建相同的数据库并删除之前的数据库但仍然遇到同样的问题。 ....



任何人都可以遇到同样的异常问题。如果是的话，我要做些什么来解决这个问题.....





非常感谢

Hi All,

I get a very unusual problem in my winform application. Where I took database as MS-ACCESS database with extension .accdb and call that file into my winform application.

Later I find that I forgot to add one column too and later I add one column into my table in the same database namely "Terms" (without quotes) with datatype as Memo

Then after I run my application with the calling of same column inside one of my winform page.

What I found that that column does not exists error inside my winform application.

When I again open my same database, then what I found is that the column name "Terms" removed from my the table Name. I don't know how it is happened and what is the solution.

I even make the same database again and deleting the earlier one but still get the same issue.....

Can anyone suffering from the same unusual problem. If yes, what I've to do to solve this problem.....


Thanks A Lot In Advance

推荐答案

如果您修改了项目下找到的Access数据库的版本 bin \ Release 或 bin \Debug 您修改了错误副本的文件夹。



您的数据库位于 bin 文件夹。它是项目的一部分，作为内容项。每次编译应用程序时，所有内容都将复制到bin文件夹，OVERWRITING那里的数据库文件。这意味着下次在Visual Studio中编译和运行应用程序时，您在 bin 文件夹之一下对数据库所做的任何更改都将丢失。

If you modified the version of the Access database found under your projects bin\Release or bin\Debug folders you modified the wrong copy.

You have your database in the project folder above the bin folder. It's part of your project as a Content item. Every time you compile the app, all content is copied to the bin folder, OVERWRITING the database file that was there. That means any change you made to the database under one of the bin folders is lost the next time you compile and run the app in Visual Studio.

这篇关于从我的ms-access数据库中自动删除列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！