ms使用密码保护访问数据库以及如何为客户端创建数据库 [英] ms Access database with password protection and how to make database for client

问题描述

先生，即时通讯开发Windows应用程序和数据库在sql server2008 R2中制作但客户端需要数据库在Ms Access ...我在ms Access 2010中创建数据表并借助Internet，因为我第一次使用ms访问数据库..所以..

保存并发布数据库...问题是如何保护客户端只保存和使用数据库不修改它所以如何做那个任务，如何防止更改打开数据库文件ms访问并修改它...还有一个问题是::我想备份客户机中的ms Access数据库很长时间才能使用Data ...

sir , i m doveloping windows application and database Made in sql server2008 R2 but Client Required Data base in Ms Access... i made data table in ms Access 2010 and with the help of Internet because i m use ms access data base first time .. so ..
save and publish database ... problem is how to protect client only save and use database does not modify it so how to do that task , how to prevent change open database file in ms access and modified it ... and also one more question is:: i want to back up of ms Access database in Client machine for long time to use Data ...

推荐答案

借助 [<}帮助使用密码保护您的数据库文件a href =http://voices.yahoo.com/microsoft-access-tutorial-password-protect-2350424.html\"target =_ blanktitle =新窗口>此]链接



并将此连接字符串用于passw ord protected db file

protect your database file using password with the help of [This]link

and use this connection string for password protected db file

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;

这篇关于ms使用密码保护访问数据库以及如何为客户端创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！