Markaa, waxaad halkan u joogtaa sababtoo ah waxaad isku dayaysaa inaad furto fayl wata faylka “.MDB” oo dheerayn ah, laakiin ha haysan koobi Microsoft Access si aad u muujiso siraha qarsoon. Kaliya^(Just) waa maxay qaabka faylkan iyo, arrinkaas, waa maxay Microsoft Access ?

Su'aasha koowaad waxay la xiriirtaa tan labaad, laakiin aan ku bilowno faylka MDB laftiisa. Kordhinta ayaa u kooban Microsoft DataBase waana qaabkii Microsoft Access adeegsatay ilaa 2003. Qaabka cusub, oo waa hore bedelay MDB , ayaa loo yaqaan ACCDB . Haddii aad haysato faylka MDB , waxay u badan tahay inuu ka yimid il dhaxal ah. 

Xagga Helitaanka^(Access) , waa qaybta kaydka xogta ee qaybta wax-soo-saarka Microsoft , oo ay ku jiraan codsiyada sida Word iyo Excel . Aynu eegno siyaabaha qaar aad u furi karto faylka mdb la'aanteed^(Access) .

Tixgeli Gelitaanka Iibka^{(Consider Buying Access)}

Haa, maqaalkan waxaa loola jeedaa in lagu sheego sida loo furo faylka MDB iyada oo aan la ^{(without )}helin^(Access) . Si kastaba ha ahaatee, sababta ay dad badani wali u waydiinayaan su'aashan waxay ka timid markii Access uu ahaa badeecad qaali ah oo aan lagu darin xirmada  caadiga ah ee Microsoft Office .

Arrimuhu aad bay isu beddeleen ilaa maalmahaas. Dadku hadda ma iibsadaan noocyada kala duwan ee Xafiiska^(Office) , laakiin iska diiwaan geli adeegga Xafiiska 365^{(Office 365)} . Xitaa heerka ugu jaban ee adeegga waxaa ku jira nooca desktop-ka ee Helitaanka^(Access) . 

Waxay ku kacaysaa wax ka yar toban doolar hal bil oo adeeg ah waxaadna ku heli kartaa tijaabo bilaash ah oo hal bil ah akoon cusub oo Microsoft ah. Markaa ka hor inta aanad u bilaabin safarkaaga dariiqyada Access-free si aad u furto faylasha MDB , ka fiirso qaadashada habkan gaaban.

Ku soo daji Excel^{(Import It With Excel)}

Haddii aad gasho kombuyuutar leh Microsoft Excel , laakiin aan lahayn Access , waxaad furi kartaa faylka MDB oo waxaad ku arki kartaa waxa ku jira xaashida. 

Tani kuma siinayso galitaanka feylka qaab xogeedkiisa hooyo, laakiin ugu yaraan waxaad arki kartaa dhammaan xogta ku jirta oo aad xitaa u dhoofin kartaa faylka qoraalka ah ama baakad-dhammaadka. Haddii taasi ay tahay waxa kaliya ee aad u baahan tahay, tani waa daw degdeg ah oo sahlan oo lagu arki karo waxa ku jira faylka MDB .

Isticmaal Isha Furan Beddelka Galitaanka^{(Use An Open Source Alternative To Access)}

Microsoft Office maaha ciyaarta kaliya ee magaalada marka ay timaado qaybaha wax soo saarka. Waxa jira ilo badan oo bilaash ah iyo Isha Furan^{(Open Source)} oo ka duwan xirmada  Microsoft ee heerka warshadaha .

LibreOffice waa meel fiican oo laga bilaabo. Waxay la socotaa codsi la yiraahdo " Base " oo tani waxay ku xirmi kartaa faylasha Microsoft Database . Siyaalo kala duwan bay u xaddidan tahay. Gaar ahaan, foomamka iyo weydiimaha ma shaqeeyaan. Si kastaba ha ahaatee waxaad weli ku arki kartaa miisaska xogtooda adigoo isticmaalaya Base .

Isticmaal Adeegga Furitaanka MDB ee khadka tooska ah^{(Use An Online MDB Opening Service)}

Haddii aadan rabin inaad wax ku rakibto si aad u furto faylka MDB , markaa waxaad isticmaali kartaa daawade online ah oo ku dhex socda browserka. Tani waxay si gaar ah faa'iido u leedahay markaad rabto inaad isticmaasho kombuyuutar dadweyne ama mid aanad lahayn mudnaanta maamulaha, sidaas darteedna aanad waxba rakibin.

Mid ka mid ah daawadayaasha noocaas ah ee aan ku tijaabinay guusha waa MDB Furaha^{(MDB Opener)} . Sida magacu tilmaamayo, waxaad gali kartaa ama ku xidhi kartaa faylka MDB ka dibna waxaad ku furi kartaa bogga shabakadda. Ma beddeli kartid faylka sinaba, laakiin waxaad u dhoofin kartaa qaabka CSV ama Excel oo aad u soo dejisan kartaa darawalka maxalliga ah.

Haddii faylkaaga MDB uu ka kooban yahay macluumaadka xasaasiga ah, sida diiwaannada caafimaadka, ka fakar laba jeer sidii aad ugu diri lahayd adeeg online ah. Waxaa laga yaabaa inaad xogtaas u soo bandhigto adeeg aan ammaan lahayn, kaasoo xataa noqon kara sharci-darro, iyadoo ku xidhan nooca macluumaadka.

Adeegso Daaweeyaha MDB ee qolo saddexaad^{(Use a Third-Party MDB Viewer)}

Maadaama ay jiraan dad badan oo u baahan inay furaan faylasha MDB iyaga oo aan haysan nuqul ka mid ah Helitaanka^(Access) agagaarka, waxaa sidoo kale jira codsiyo daawade oo dhinac saddexaad ah oo MDB ah oo laga dooran karo. MDB Viewer Plus waxay ka soocday xirmada sababo badan dartood.

Marka hore^(First) , gabi ahaanba waa bilaash. Marka labaad, waxaad wax ka beddeli kartaa faylasha ^{(edit )}MDB iyo faylasha ACCDB . Xitaa ka sii fiican, codsigu waa la qaadi karo^{(the application is portable)} , taas oo macnaheedu yahay uma baahnid inaad ku rakibto. Si kastaba ha ahaatee, kani waa codsi Windows-kaliya ah kaas oo ku tiirsan dhowr qaybood oo database-gaar ah oo lagu dhisay nidaamka hawlgalka Microsoft.

Isticmaal tifaftiraha qoraalka^{(Use a Text Editor)}

Tifaftiraha qoraalka hooseeya, sida Windows Notepad , sidoo kale waxaa loo isticmaali karaa in lagu furo faylasha MDB xaalado gaar ah. In kasta oo aynaan nafteena wax nasiib ah yeelan, faylalka MDB qaarkood waxay leeyihiin kaliya nuxur qoraal ah. Tani waxay ka dhigan tahay in tafatiraha qoraalka uu wax ku tusi doono .^(something.) 

Faylasha MDB waxaan ku furnay Notepad , inta badan waxa ku jira waxa ay ahaayeen khariban. Si kastaba ha ahaatee, qaybo ka mid ah qoraalka cad ee ku dhex jira ayaa bixiyay tilmaamo ku saabsan nooca xogta ee faylka ku jira. Maaha hab lagu taliyey, laakiin haddii aanay wax kale shaqayn, ma dhaawici karto.

U beddelo gelitaanka (Qof kale)^{(Convert It With (Someone Else’s) Access)}

Dhabanaan ahaan, waxaanu ku soo jeedin doonaa isticmaalka Access mar labaad maqaal ku saabsan isticmaal la'aanta gelitaanka^(Access) . Gaar ahaan, waxaa habboon in la weydiiyo qof leh fursad^(Access) uu kuugu beddelo faylka qaab ka duwan adiga. 

Haddii uu qof kuugu soo diro feylka MDB iimayl ahaan, tusaale ahaan, waxaad waydiisan kartaa inay dib ugu soo diraan xaashida xisaabaadka ka dib markaad ku beddelato nuqulka codsiga. Marka la eego sida uu caanka u yahay Office 365 maalmahan, waxaa hubaal ah in uu jiro qof qaylo dheer ku jira oo Access ku rakibay kombayutarkiisa, markaa waxa ay mudan tahay in la toogto ugu yaraan.

Waa Wax walba oo ku saabsan Saldhigga (Data).^{(It’s All About That (Data) Base)}

Gelitaanku^(Access) hadda kuma qarsoona gadaasha mushaharka lacagta ah sidii ay ahaan jirtay, laakiin wali waxaa jira dad badan oo aan marin u helin (aan ciqaab loogu talagelin) software-ka. Waxaan rajeyneynaa in mid^{(Hopefully one)} ka mid ah xalalka beddelka ah ee kore uu ku shaqeyn doono oo uu ku gelin doono xogtaas qadiimiga ah ee yaabka leh ee markii hore laga xiray indhaha soo jiidaya.

7 Ways To Open An MDB File Without Microsoft Access

So, you’re here because you’re trying to open a file with an “.MDB” file extension, but don’t have a copy of Microsoft Access to reveal its mysteries. Just what is this file format аnd, for that mattеr, 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.

Related posts

• Soo kabashada Faylka Microsoft ee Windows ma shaqeeyaa? Waanu Tijaabnay.

• Tababarka Qorsheeyaha Microsoft: Wax kasta oo aad u baahan tahay inaad ogaato

• Parser-ka Iimayl-ka Zapier: 3 Hab oo Hal-abuur leh oo Loo Isticmaalo

• Waa maxay Microsoft Power Automate iyo Qaababka bilaashka ah ee la soo dejiyo

• 9 Siyaabood Oo Looga Duubi Karo Ciyaarta Kubada Cagta

• Farqiga udhaxeeya Qaababka Faylka ee Kaydka badan

• HDG wuxuu sharxayaa: Waa maxay SQL, T-SQL, MSSQL, PL/SQL, iyo MySQL?

• 7-da Qalab ee ugu Wacan ee loogu talagalay Chromebook

• 5-ta Apps ee ugu Fiican ee Shaandhaynta Iftiin Buluugga ah ee loogu talagalay Windows, Mac iyo Linux

• 3 Qalab oo lagu Baaro laguna Xaliyo Dhibaatooyinka Kormeerahaaga

• Sida Loo Dooxi karo DVD-yadaada & Blu-rays-gaaga si Dadaal la'aan ah adigoo isticmaalaya MakeMKV

• Sida Looga Joojiyo Goobaha Software-ka Kontoroolka Waalidka ee Bilaashka ah

• 10ka Qarsoon ee ugu Fiican Chrome (2022)

• Sida loo hubiyo in heerkulka CPU-gaagu uu aad u sarreeyo

• Waa maxay Chatbot-ka iyo sida loogu isticmaalo mid ka mid ah boggaaga

• Tafatiraha qoraalka Apps Google: Wax kasta oo aad u baahan tahay inaad ogaato si aad u bilowdo

• Buuxinta otomaatiga ah ee Google Chrome: Hage Dhamaystiran

• 4-ka ugu Wacan ee Soo Gudbinta Barnaamijyada Software-ka iyo Sida Loo Isticmaalo

• Barnaamijyada ugu Wanaagsan ee lagu dari karo hawlqabad cusub Windows 10

• Waa maxay Adeegga Wicida Shirka ugu Fiican - Apps-ka ugu Wanaagsan marka la barbardhigo