因此,您来到这里是因为您正试图打开具有“.MDB”文件扩展名的文件,但没有Microsoft Access的副本来揭示其奥秘。这种(Just)文件格式是什么,就此而言,Microsoft Access是什么?
第一个问题与第二个问题有关,但让我们从MDB文件本身开始。该扩展名是Microsoft DataBase的缩写,是Microsoft Access使用到 2003 年的格式。这种新格式很久以前就取代了MDB,称为ACCDB。如果您有MDB文件,它可能来自旧版源。
至于Access ,它是(Access)Microsoft生产力套件的数据库组件,其中还包括Word和Excel等应用程序。让我们看一下在没有Access(Access)的情况下打开 mdb 文件的一些方法。
考虑购买访问权限(Consider Buying Access)
是的,本文旨在告诉您如何在没有(without )Access的情况下打开(Access)MDB文件。但是,许多人仍然问这个问题的原因源于Access是标准(Access)Microsoft Office软件包中 不包含的高级产品。
从那时起,情况发生了巨大变化。人们不再购买独立版本的Office,而是订阅Office 365服务。即使是最便宜的服务层也包括Access的桌面版本。
一个月的服务费用不到 10 美元,您可以使用新的Microsoft(Microsoft)帐户获得一个月的免费试用。因此,在您开始使用无访问权限(Access-free)方式打开MDB文件之前,请考虑采用这个明显的捷径。
用 Excel 导入(Import It With Excel)
如果您可以访问装有Microsoft Excel但没有Access的计算机,则可以打开MDB文件并在电子表格中查看其内容。
这不会让您访问其本机数据库格式的文件,但至少您可以查看其中包含的所有数据,甚至可以将其导出为电子表格或逗号分隔的文本文件。如果这就是您所需要的,这是查看MDB(MDB)文件中内容的一种快速简便的方法。
使用开源替代方案进行访问(Use An Open Source Alternative To Access)
(Microsoft Office)在生产力套件方面,Microsoft Office并不是唯一的游戏。行业标准的Microsoft(Microsoft)软件包 有很多免费和开源(Open Source)的替代品。
LibreOffice是一个很好的起点。它带有一个名为“ Base ”的应用程序,它可以连接到Microsoft 数据库(Microsoft Database)文件。它以各种方式受到限制。具体来说,表单和查询不起作用。但是,您仍然可以使用Base查看表及其数据。
使用在线 MDB 打开服务(Use An Online MDB Opening Service)
如果您不想安装任何东西来打开MDB文件,那么您可以使用在浏览器中运行的在线查看器。当您想使用公共计算机或您没有管理员权限的计算机时,这特别有用,因此无法安装任何东西。
我们成功测试过的其中一种查看器是MDB Opener。顾名思义,您可以上传或链接到MDB文件,然后在网页上打开它。您无法以任何方式编辑文件,但可以将其导出为CSV或Excel格式并将其下载到本地驱动器。
如果您的MDB文件包含敏感信息,例如医疗记录,请考虑将其上传到在线服务。您可能会将这些信息暴露给不安全的服务,这甚至可能是非法的,具体取决于信息的类型。
使用第三方 MDB 查看器(Use a Third-Party MDB Viewer)
由于有很多人需要在没有Access副本的情况下打开MDB文件,因此也有相当多的第三方MDB查看器应用程序可供选择。MDB Viewer Plus在众多原因中脱颖而出。
首先(First),它是完全免费的。其次,您可以编辑(edit )MDB文件和ACCDB文件。更好的是,该应用程序是可移植的(the application is portable),这意味着您不必安装它。但是,这是一个仅限 Windows 的应用程序,它依赖于 Microsoft 操作系统中内置的几个特定于数据库的组件。
使用文本编辑器(Use a Text Editor)
Windows Notepad等不起眼的文本编辑器也可用于在某些情况下打开MDB文件。(MDB)虽然我们自己没有任何运气,但一些MDB文件只有纯文本内容。这意味着文本编辑器会向您展示一些内容。(something.)
对于我们用记事本打开的(Notepad)MDB文件,大部分内容都是乱码。但是,其中包含的纯文本片段确实提供了有关文件包含哪种数据库的线索。这不是推荐的方法,但如果没有其他方法,它不会受到伤害。
使用(其他人的)访问权限进行转换(Convert It With (Someone Else’s) Access)
厚颜无耻地,我们将在一篇关于不使用 Access 的文章中再次建议使用(Access)Access。具体来说,值得请具有Access 权限(Access)的人为您将文件转换为不同的格式。
例如,如果有人通过电子邮件向您发送了MDB文件,您可以要求他们在将其与他们的应用程序副本进行转换后,将其作为电子表格重新发送。鉴于如今Office 365非常受欢迎,肯定会有人在他们的计算机上安装Access,因此至少值得一试。
这就是(数据)库(It’s All About That (Data) Base)
访问权限(Access)不再像过去那样隐藏在高级付费墙后面,但仍然有很多人无法访问(不是双关语)该软件。希望(Hopefully one)上述替代解决方案之一对您有用,并让您进入那个以前被锁定远离窥探的古老奇迹数据库。
7 Ways To Open An MDB File Without Microsoft Access
So, you’re here becаuse you’re trying to open a file with an “.MDB” file extension, but dоn’t have a copy of Microsoft Access to reveal its mysteries. Just what is this fіle formаt and, for that matter, what’s Microsoft Access?
The first question is related to the second, but let’s start with the MDB file itself. The extension is short for Microsoft DataBase and is the format that Microsoft Access used up to 2003. The new format, which has long ago replaced MDB, is called ACCDB. If you have an MDB file, it’s probably from a legacy source.
As for Access, it’s the database component of the Microsoft productivity suite, which also includes applications such as Word and Excel. Let’s look at some ways you can open an mdb file without Access.
Consider Buying Access
Yes, this article is meant to tell you how to open an MDB file without Access. However, the reason many people still ask this question stems from a time when Access was a premium product not included with the standard Microsoft Office package.
Things have changed drastically since those days. People no longer buy discrete versions of Office, but subscribe to the Office 365 service. Even the cheapest tier of the service includes the desktop version of Access.
It costs less than ten bucks for a single month of service and you can get a one-month free trial with a new Microsoft account. So before you start your journey down the road of Access-free ways to open MDB files, consider taking this obvious shortcut.
Import It With Excel
If you have access to a computer that has Microsoft Excel, but doesn’t have Access, you can open an MDB file and view its contents in a spreadsheet.
This doesn’t give you access to the file in its native database format, but at least you can see all the data contained within it and even export it as a spreadsheet or comma-separated text file. If that’s all you need, this is a quick and easy way to see what’s inside that MDB file.
Use An Open Source Alternative To Access
Microsoft Office isn’t the only game in town when it comes to productivity suites. There are plenty of free and Open Source alternatives to the industry-standard Microsoft package.
LibreOffice is a good place to start. It comes with an application called “Base” and this can connect to Microsoft Database files. It’s limited in various ways. Specifically, forms and queries don’t work. However you can still view the tables with their data using Base.
Use An Online MDB Opening Service
If you don’t want to install anything in order to open an MDB file, then you can use an online viewer running in a browser. This is particularly useful when you want to use a public computer or one where you don’t have administrator privileges, and therefore can’t install anything.
One such viewer we tested with success is MDB Opener. As the name suggests, you can upload or link to a MDB file and then open it on the web page. You cannot edit the file in any way, but you can export it to CSV or Excel format and download it to the local drive.
If your MDB file contains sensitive information, such as medical records, think twice about uploading it to an online service. You may be exposing that information to an unsecure service, which could even be illegal, depending on the type of information.
Use a Third-Party MDB Viewer
Since there are plenty of people who need to open MDB files without a copy of Access around, there are also quite a few third-party MDB viewer applications to choose from. MDB Viewer Plus stands out from the pack for a number of reasons.
First of all, it’s completely free. Secondly, you can edit MDB files and ACCDB files. Even better, the application is portable, which means you don’t have to install it. However, this is a Windows-only application that does rely on several database-specific components built into Microsoft’s operating system.
Use a Text Editor
The humble text editor, such as Windows Notepad, can also be used to open MDB files under certain circumstances. While we didn’t have any luck ourselves, some MDB files only have plain text content. This means that a text editor will show you something.
With the MDB files we opened with Notepad, the majority of the content was a garbled mess. However, the snippets of plain text contained within did provide clues as to what sort of database the file contained. It’s not a recommended method, but if nothing else works, it can’t hurt.
Convert It With (Someone Else’s) Access
Cheekily, we’re going to suggest using Access again in an article about not using Access. Specifically, it’s worth asking someone who does have Access to convert the file into a different format for you.
If someone sent you the MDB file via email, for example, you could ask them to resend it as a spreadsheet after converting it with their copy of the application. Given how popular Office 365 is these days, there’s bound to be someone within shouting distance who has Access installed on their computer, so it’s worth a shot at least.
It’s All About That (Data) Base
Access is no longer hidden behind a premium paywall in the way it used to be, but there are still plenty of people who don’t have access (no pun intended) to the software. Hopefully one of the alternative solutions above will work for you and get you into that ancient database of wonders that’s been previously locked away from prying eyes.