我需要从我的VB项目在线更新我的数据到MS访问数据库吗？ [英] I need to update my data online from my VB project to MS access database?

问题描述

我需要从VB项目在线更新数据到MS Access数据库吗？请帮帮我怎么做我在我的本地电脑上有一个连接我需要它在线我重复我的问题如何保持在线？

我的配置文件在这里=>

i need to update data online from my VB Project to MS Access Database? Please help me How to do it i have a Connection on my local PC I Need it to be online i m repeating my question How to keep it online ?
My config file is here =>

<connectionStrings>
        <add name="KKS.My.MySettings.kksdatabaseConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\kks\kksdatabase.accdb"
            providerName="System.Data.OleDb" />
        <add name="KKS.My.MySettings.kksdatabaseroznzmchaConnectionString"
            connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\kks\kksdatabaseroznzmcha.accdb"
            providerName="System.Data.OleDb" />
    </connectionStrings>

我尝试过：



i试过这个但没有结果：

What I have tried:

i tried this but no result :

<pre><connectionStrings>
        <add name="KKS.My.MySettings.kksdatabaseConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\kks\kksdatabase.accdb"
            providerName="System.Data.OleDb" />
        <add name="KKS.My.MySettings.kksdatabaseroznzmchaConnectionString"
            connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=http://nntechs.net/kksdb/kksdatabase.accdb "
            providerName="System.Data.OleDb" />
    </connectionStrings>

推荐答案

您只需将数据库移动到网络驱动器即可。如果通过'在线'表示可以从任何地方访问，那么您需要创建一个网站来管理它，或者使用类似DropBox或OneDrive的东西。

You just need to move the database to a network drive. If by 'online' you mean accessible from anywhere, then you either need to create a website to manage it, or use something like DropBox or OneDrive.

我真的不推荐它。

要直接在线使用Access数据库，您必须通过对整个互联网的读写访问权限来公开它 - 这是让数据被盗和/或被删除的好方法。直接将任何数据库暴露给互联网是一个坏主意！



此外，Access是一个非常差的多用户数据库，因为必须假设所有在线活动要大规模多用户我强烈建议你走另一条路线。



如果这是一个网站，那么使用SQL或MySQL数据库（以你的主机提供者为准）服务）防止需要保护您的数据库免受意外访问者的攻击。<​​br />
如果不是，请考虑创建一个WCF服务来托管您的访问文件并处理来往于它的请求。这为您提供了保护，也意味着您的WCF任务可以是唯一直接访问数据库的任务，同时可以改善多用户访问。

I really wouldn't recommend it.
To "use" an Access DB directly online, you have to expose it with read and write access to the whole internet - which is a good way to have it's data stolen and / or trashed. Directly exposing any DB to the internet is a bad idea!

In addition, Access is a very poor multiuser DB, and since all "Online" activity has to be assumed to be massively multiuser I would strongly suggest you go a different route.

If this is a website, then using an SQL or MySQL database (whichever is provided by your hosting service) prevents the need to "Protect" your DB from unexpected visitors.
If it isn't, then consider creating a WCF service to "host" your access file and to process requests to and from it. This provides the protection for you, and also means that your WCF task can be the only thing directly accessing the DB, ameliorating the multiuser access at the same time.

这篇关于我需要从我的VB项目在线更新我的数据到MS访问数据库吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！