安装程序安装的数据库无法显示记录 [英] database installed by the setup program can not show records

问题描述

亲爱的朋友
这是萨法拉兹(Sarfaraz).大家好吗?

今天，我为我的项目创建了一个安装文件，并将其安装在目标计算机上.一切都很好.
但是我试图打开由项目的安装程序安装的访问数据库.我得到的只有3条记录，我在编码过程中已在自己的计算机上输入了这些记录.但是我已经在项目的前端输入了100条记录.为什么我看不到后端的所有记录(在msaccess中打开数据库后)，尽管我可以将它们全部打印在报告中，并且可以在我的项目中搜索所有记录.



谢谢.

Dear friends
This is Sarfaraz here. How are you all.

Today i created a setup files for my project and installed it on target computer. All is going good.
But I tried to open the access database which was installed by the setup program of my project. All i get was only 3 records which i have entered at my own computer during coding. But i have entered 100 records through the front end of my project. Why i am not seeing all the records from the backend (after opening database in msaccess)although i can print them all in my reports and can search all the records through my project.



Thank you.

推荐答案

我只能假设您已将它们保存到一个数据库中，并且正在从另一个数据库中查看它们.
检查您的文件路径！

I can only assume that you have saved them to one database, and are viewing them from another.

Check your file paths!

这些天我不再使用访问权限，但我似乎还记得在开发阶段可以选择将访问数据库副本附加到该项目中始终单击不附加.我的猜测是您可能已经在项目文件夹中创建并存储了具体"本地副本.具体来说，我的意思是没有动力.

我可以在这里工作的服务器上安装访问权限，并使用bindingsources和table适配器加载当前数据，例如:

me.programsTableAdapter.Fill(me._yourAccessLinksDataSet.programs)

这些其他计算机仅需要访问引擎即可免费下载，并且可以通过字符串"server \ folder \ myDB.mswtfdb"中的连接路径进行连接

您还可以通过简单地更新已附加到访问权限的数据集来保存对访问权限所做的任何更改.

i don''t work with access anymore these days but i seem to remember there being an option in the development stage to attach access DB copies to the project which I always clicked do not attach. My guess is you might have created and stored a ''concrete'' local copy in the projects folders. by concrete i mean not dynamic.

I had access installed on a server here at work, and used bindingsources and table adapters to load current data like:

me.programsTableAdapter.Fill(me._yourAccessLinksDataSet.programs)

these other computers only required the access engine which is free to download and could connect via a connection path in string "server\folder\myDB.mswtfdb"

you could also save any changes made back to access by simply updating the datasets you''ve attached to access.

这篇关于安装程序安装的数据库无法显示记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！