如何使用 MS Access 查看和更改 .mdf 文件的数据? [英] How to view and change data of a .mdf file using MS Access?

问题描述

背景:我有一个 .mdf 数据库，其中包含一些我需要更改的数值(特别是传感器的比例和偏移值).该数据库是由 Visual Basic 程序创建的，该程序控制一些实验室设备并将相关数据存储在 .mdf 文件中.请原谅我对这个话题的基本了解；当谈到 SQL Server 和 VB 时，我是一个完全新手.

Background: I have an .mdf database containing some numeric values that I need to change (specifically, scale and offset values for sensors). The database was created by a Visual Basic program that controls some lab equipment and stores pertinent data in the .mdf file. Please excuse my rudimentary knowledge of the topic; I'm a complete novice when it comes to SQL Server and VB.

在搜索了很多帖子后，我了解到要打开 .mdf 文件，您必须在 Microsoft Server Management Studio 中附加"它(我在 SQL Server 2005 中使用它)，我已经成功完成了.

After searching through many posts, I understand that to open the .mdf file, you must "attach" it in Microsoft Server Management Studio (I'm using that with SQL Server 2005), which I have successfully done.

问题: 这个好像只允许我查看和修改数据库的结构，即.表、列、数据类型等，而不是数据库本身的值.

Problem: It seems that this only allows me to view and modify the structure of the database, ie. tables, columns, data types etc., rather than the values of the database itself.

有没有办法手动执行此操作，例如如何在 MS Access 中编辑 .mdb 文件的字段数据?再次抱歉，我对该主题的了解有限.我很乐意在需要时提供额外的详细信息.

Is there a way to do this manually, like how you can edit the field data of .mdb files in MS Access? Again, sorry for my limited knowledge on the topic. I'll gladly provide extra details where needed.

推荐答案

您提到要使用访问权限.这是可以做到的.附加数据库后，您的数据库已启动并正在运行.

You mention you want to use access. That can be done. Your database is up and running after attaching it.

在 Access 中，您可以简单地在 access 中创建 ODBC 连接，并使用 Access 编辑/修改您想要的数据.您还可以创建查询.

In Access you can simply create an ODBC connection in access and use Access to edit/modify your data as much as you want. you can also create queries.

它在菜单项外部数据"中[我猜是因为我使用的是荷兰语版本].你选择创建一个链接表"，选择你的服务器，你就完成了.

It is in the menu item "external data" [I'm guessing because I use a dutch version]. You select to create a "linked table", choose your server and you are done.

这篇关于如何使用 MS Access 查看和更改 .mdf 文件的数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！