Category: 2019.03

How you can unlock your Access Database if forgot Password

If forgot Microsoft Access Database password how you can open and unlock it? On Access 2003 minimizing versions, Microsoft supply the code to unlock mdb database password in the Visual Basic for Applications. But on Access 2007 and higher edition, Microsoft can’t help you to find back the protection password after you forgot or lost it. Which means you are prompted to keep the password inside a secure place when setting a password in your accdb database.

However, if unfortunately, you forgot the accdb encrypted password, what to do?

Part 1: Recover your Access Database Password

It is simple and simple for you to recover your Access database password having a tool.

Step 1: To begin Access Password tool.

1.1 Download Cocosenor Access Password Tuner, and install it on the computer where you are going to recover Access Database password.

1.2 Select to begin Access Password Tuner when finish the installation.

Step 2: Click on Open button.

Step 3: Select your Access database file to import in.

Step four: Select a type of attack from the drop-down list, and adjust the settings.

Step five: Click Start button and also the recovery process will start!

Tips: The recovery time depends on the complexness of the password, and also the attack type you decide on.

Step six: After a while your password is recovered, it will likely be showed around the box below. Copy the password, and paste it to unlock your Access database password.

Part 2: Remove password from your MS Access database

After recovering your accdb password, you can use it to open the database file from Microsoft Access easily. If don’t need the password anymore, you can remove it from your Access database following a steps below.

Step 1: Open the accdb file on Access with password, click on File, and click on Open.

Step 2: Choose the accdb file that you simply want to decrypt, click on the drop-down list beside Open, and select “Open Exclusive”.

If need, go into the password on the text box again.

Step 3: Click on File, and then click on Decrypt Database.

Step 4: On the Unset Database Password dialog, go into the password, and then click OK.

Now your Access database password continues to be removed, and you may open it without typing password the next time.

Part 3: Unlock mdb database password with VBA code

If you work with the lower version of Access, such as Access 2000, you can unlock it without software, using the code on Visual Basic of Application.

Step 1: Produce a new Access Database, and open it.

Step 2: Press Alt + F11 to open the Visual Basic of Application.

Step 3: Click Insert → Module.

Step four: Go into the code on General window.

Tips: Remember to change the database file road to yours.

Step 5: Press F5 to run it. After some time, if go successfully, your locked mdb file will be unlocked without password.

How to locate your Office Product Key after installation on computer

Within this information will demonstrate how to get your Office product key out of your computer after installation.

Prior to doing a clean install of Windows, or upgrading to Windows 10 from Windows 7/8/8.1, it’s a good idea to find out and save your valuable office product answer to a safe location.

If you’re prompted to go in the license number to activate your Office, while you are reinstalling it on your current computer or any other PC devices.

Don’t hurry to purchase another activation key, even if you lost your Microsoft Office product key, try the methods below to find it.

Where can you find your Office product key?

Find online with Microsoft account: If your Office was purchased and downloaded online, or of a Microsoft account, your MS Office product key can be found online.

Open Microsoft website, and login with your Microsoft account accustomed to buy or activate Office. The Office serial key is going to be showed on your Office account page.

Check from email: Should you downloaded your Office from a web-based store, you may be able to get the license key from the email receipt. Check your mail folder, if you haven’t deleted it, there is a key on it.

Printed on a sticker: In case your Office program came with your pc, the license key might be printed around the Certificate of Authenticity sticker inside your computer.

If included a CD, card, or box, search for the sticker around the card or packaging.

Find from system registry: The Office serial secret is stored around the hard disk in which you install Office program. You’ll find it in the registry, but you can’t see clearly normally, since it is encrypted with binary code.

Discover the DigitalProductID from registry by this way: HKEY_LOCAL_MATHINE\Software\Microsoft\WindowsNT\CurrentVersion\DigitalProductID.

Look at your MS Office serial key with VBScript

The serial keys are encrypted on registry, you can’t see clearly normally, but you can retrieve it with product key tool or VBScript.

To check your Office product key with VBAcript:

Step 1: Type the code to some notepad.

Step 2: Click File, select Save AS, enter personal files name “find key.vbs”, select All Files below, after which click Save button in order to save it as being vbs file.

Step 3: Double-click on the vbs file, and then click OK to find your Office product key you have placed on computer.

I only tried this process with my Office 2010, if you work with Office 2016, 2013, 2007, or 2003, just have a try following the steps above.

Recover your Office Product key from computer with tool

Forgot or lost your MS Office product key? If you still can’t find your Office Product key, try with the product key tool. The merchandise key tool really is easy and easy to work with just with two steps.

Step 1: Download Cocosenor Product Key Tuner, double-click to set up on your pc in which you wish to discover the activation key.

Step 2: When the Product Key Tuner program pops up, click on Start Recovery button.

You can now view your Office activation key.

Click the Save To file for button, all your product keys will be saved to some file. Keep your product keys file to a rut.

This tool also can be used to find back product keys for the Windows 10/8/8.1/7/XP/Vista, for your Office 2016/2013/2010/2007/2003, along with other applications placed on your computer.

Office 2019 Features: Everything You Need to Know

If you’ve been eagerly anticipating the release of Microsoft Office 2019 – waiting for has ended!

Microsoft has packed plenty of sought after features into this brand new version of the suite.

Read on once we break down what improvements you can expect to see across your preferred Microsoft Office applications as part of the update.

Just when was Office 2019 released?

Microsoft was tight lipped about when Office 2019 would drop, before officially letting it go on September 24, 2018. Commercial, volume-licensing customers were able to preview Office 2019 before official launch because of Microsoft’s Commercial Preview program.

Office 2019 vs. Office 365: What’s the difference?

Most of the features incorporated into Office 2019 are already offered in Office 365, which has resulted in some confusion amongst customers: What is the main difference between Office 2019 and Office 365?

Here’s the main difference: Office 2019 is a one-time purchase, and also you won’t receive any feature updates once you buy it. Of course, you’ll get standard security and quality updates-but you won’t use whatever new tools or functionality added. You’ll have to be using Windows 10 as the operating system to be able to run Office 2019.

In comparison, Office 365 is really a subscription-based service. Unlike Office 2019, Office 365 is powered by Microsoft cloud and therefore includes more collaborative and up-to-date features than Microsoft’s perpetual software does.

Microsoft has channeled a lot of its recent energy and a focus into Office 365 in the cloud, however, they also recognized that does not individuals were willing and ready to make that switch.

“Most in our cloud-powered innovation is coming to Office 365 and Microsoft 365,” explains Microsoft in their FAQs about the Office 2019 preview, “However, we all know this is really a journey for some customers who cannot proceed to the cloud soon. We want to support all of our customers in their journey to the cloud.”

Again, most of the features don’t be surprised from Office 2019 are most likely already offered via Office 365. But, this perpetual software update is a great way for users who aren’t prepared to move to the cloud to obtain access to the new tools and functionality.

What’s new: Office 2019 features

Here are some of the additional features a part of Office 2019 certain to constitute interest to new and seasoned users alike:

1. Advanced presentation features

While PowerPoint is still one of the most popular and commonly-used presentation solutions available, there are many others who notice as dated-particularly with more tech-savvy options like Prezi available.

In order to stay relevant, Microsoft has announced intends to incorporate more advanced presentation features in Office 2019. Included in this are things like enhanced Morph and Zoom capabilities that will help you produce a more sophisticated and dynamic presentation.

Those features already are contained in Office 365 ProPlus, but aren’t open to those who are currently operating with Office 2016.

2. Stronger data analysis

When it comes to data management and analysis, Excel still reigns supreme. Office plans to kick some misconception a notch in the 2019 form of the software.

Customers should expect even more powerful features, such as new formulas, new charts (like funnel charts and 2D maps), the opportunity to publish from Excel to Power BI (Microsoft’s own business analytics service), and enhancements for PowerPivot and PowerQuery.

Obviously, if Excel is the undeniable favorite of the Microsoft Office suite, the anticipated 2019 features will probably have you bursting into your happy dance.

3. Improved inking features

People who use Microsoft Surface products are probably already big fans of digital pen that permit these to draw, note, and doodle directly onto their device’s screen.

Office 2019 will introduce brand new inking capabilities across all apps-such as pressure sensitivity, tilt effects that adjust the ink’s thickness with respect to the angle from the pen, and even a roaming pencil case, which allows users to store and organize their favorite pens, pencils, and highlighters to roam with them across their different devices.

4. Easier email management

Finally, if you’re an Outlook user, the release of Office 2019 shouldn’t make you out in the cold. Microsoft has teased several new features to take some from the hassle and headaches from email management.

Based on Microsoft, included in this are things like:

Updated contact cards
Office 365 Groups
@mentions
Focused inbox
Travel package cards

Microsoft is hopeful these additions can help users manage their email far more efficiently and effectively.
Get prepared for Office 2019

Packed with features for that consumer, Office 2019 doesn’t skimp on value for the IT side either.

“We introduced Click-to-Run (C2R), a modern deployment technology, in Office 2013, and it is now used to deploy and update Office across hundreds of millions of devices worldwide,” Microsoft explains in a release, “With Office 2019, we’re moving the perpetual versions of Office to C2R exclusively therefore it can take advantage of modern deployment technology to reduce costs and improve security.”

Now the suite has officially been released, there’s plenty to become excited about with Office 2019-including lots of new (and, oftentimes, frequently-requested) features.

If you wish to dig in even more and find out the best way to leverage Microsoft Office? Take a look at all of our different Microsoft Office courses, becoming updated to Office 2019!

Is Windows 10 Version 1809 Finally Available for Everyone?

The rollout of Windows 10 version 1809 (October 2018 Update) might have reached another stage, as Microsoft is considered to possess started the automatic rollout to all compatible devices.

As mentioned around the Windows 10 update history page, Microsoft started the phased rollout of Windows 10 version 1809 on January 16, using the company providing the update “to devices we believe will have the very best update experience according to our next generation machine learning model.

In other words, only some devices were supposed to obtain the update, as Microsoft otherwise desired to prevent every other issues from hitting computers.

But simultaneously, users were permitted to download the brand new Windows 10 feature update having a simple look for updates on Windows Update.

“Upgrade block in place”

As noted by GHacks, the “Get the Windows 10 October 2018 Update” page has been upgraded with new information suggesting that this version of the operating system is now readily available for everyone via Windows Update and pushed being an automatic download.

“Windows 10 will automatically download the October 2018 Update on your eligible device if you’ve switched on automatic updates in Windows Update settings,” the page reads.

This means that on devices where Windows Update is enabled, Windows 10 version 1809 should automatically download in the background and then request the time to complete the install. A reboot is necessary to accomplish the update process.

However, Microsoft still notes that an upgrade block is in place on devices with certain Intel drivers, and the company recommends users to install the latest driver versions before attempting to download Windows 10 version 1809.

We have reached out to the company to inquire about more information concerning the current phase from the Windows 10 October 2018 Update rollout, and we’ll circle back should any specifics be offered.

March 2019 Windows and Office patches poke a few interesting places

Patch Tuesday originates and gone, not with a bang but a whimper. Currently, early Wednesday morning, I don’t see any glaring problems with the 124 patches covering 64 individually identified security holes. However the day is yet young.

There are some patches of note.

Two zero days

Microsoft says that two of this month’s security holes – CVE-2019-0797 and CVE-2019-0808 – are being actively exploited. The second of these zero days may be the one which had been used in addition to the Chrome exploit that caused this type of kerfuffle last week, with Google urging Chrome browser users to update right away, or risk the slings of nation-state hackers. If you’ve already updated Chrome (which happens automatically for nearly everybody), the immediate threat has been thwarted already.

Both of these security holes are Elevation of Privilege bugs, which means that a miscreant who’s already gotten into your system can use the bugs to move up to admin status. Therefore if you’re responsible for systems which are susceptible to sophisticated attacks, these patches warrant concern. For everybody else, they’re not the stuff of Stephen King class nightmares.

As always, Martin Brinkmann on ghacks.net has a thorough listing, the SANS ISC forum includes a succinct chart, and Dustin Childs around the Zero Day Initiative blog offers many tech details.

Win10 version 1809 oddities

The Win10 version 1809 cumulative update, KB 4489899, fixes the “crazy” performance drop in some games, including Destiny 2, that people encountered fourteen days ago. However, it doesn’t fix the other bug introduced by the “second February” 1809 cumulative update, KB 4482887, which clobbers audio settings in specific circumstances:

After installing this update on machines that have multiple audio devices, applications that offer advanced choices for internal or external audio output devices may cease working unexpectedly. This issue occurs for users that select an audio output device different from the “Default Audio Device”.

As erpster4 notes on Tenforums:

KB 4489899 causes that problem only if there are multiple audio outputs or playback devices for Realtek HD audio (speakers, realtek digital output [SPDIF], etc.) and also the output selected is not the “default audio device.” If perhaps the “Speakers” output shows up around the Sound properties playback tab for Realtek audio (usually on ALC2xx codecs), then KB 449899 is protected to set up.

In addition, this month’s KB 4489899 doesn’t fix the MSXML 6 bug introduced by the first cumulative update in January:

After installing this update, MSXML6 causes applications to stop responding if an exception was thrown during node operations, for example appendChild(), insertBefore(), and moveNode().

Enables you to ponder whether 1809 will get the “ready for business deployment” imprimatur before 1903 hits the skids. Er, goes out the chute. That’s what it is supposed to work, yes?

Servicing Stack Update for Win7

Here’s where the going gets a bit thick.

As explained in November, Microsoft is evolving the way it’s signing patches for Win7. From July, your Win7 machine needs to understand SHA-2 encryption to be able to receive new patches. (Yes, this is the same Win7 that’ll no more receive new security patches next January.)

Microsoft released two SHA-2 related patches. KB 4490628 is really a Servicing Stack Update – it fixes the part of Windows 7 that installs patches. KB 4474419 fixes Windows itself so it are designed for SHA-2 encryption.

As @DrBonzo explains, and @PKCano reiterates, if you’re manually installing Win7 patches, you’ll need the Servicing Stack Update KB 4490628 before you decide to install this month’s patches. (Should you let Windows Update install the patches, it’ll get installed first.) Then your Windows-only fix KB 4474419 can follow along any time before July.

If you’re installing the Win7 updates manually, there’s a particular installation sequence detailed by @PKCano that ensures the updates go in the correct order.

Dearth of Office patches

With all the love being showered on Windows 7 now (including DirectX 12 for many games, and much more annoying “Get Windows 10” nag screens), you may expect more sweetness and lightweight for Office apps. Not so.

We only have six new Office security patches, to increase the 28 non-security patches from earlier this month: one for Office 2010 and five for various Server versions. Remarkably, there are no new security patches for Office 2013 or Office 2016, although we all do have two new versions of Office Click-toRun: 15.0.5119.1000 for Office 2013; 14.0.7230.5000 for Office 2010.

Office 2019 perpetual volume license products available as Click-to-Run

For almost two decades, Microsoft Office has trusted the Windows Installer (MSI) technology for core deployment functionality. To higher address the ever-growing requirements of businesses, Office has continually introduced modern deployment features.

In Microsoft Office 2013, we introduced Click-to-Run, a modern deployment technology that is now delivering Office to hundreds of millions of users worldwide. Starting in Microsoft Office 2019, we’ll expand the supply of Click-to-Run to all client products. Perpetual volume licensed products will be able to make the most of benefits that improve security and simplicity of use while reducing deployment costs. These benefits include the following:

Predictable cumulative monthly updates
Software that’s up-to-date immediately upon installation
Easy upgrade road to Office 365 subscription products

Click-to-Run provides the same enterprise-focused management capabilities as MSI-based products. Included in this are volume activation, Group Policy management, administrative treatments for updates, and integration with management tools such as System Center Configuration Manager. That will help you migrate from older MSI-based products, Click-to-Run will also support in-place upgrade when you move to Microsoft Office 2019 or Office 365.

Starting in Office 2019, Office client applications will no longer be available in MSI format. This transformation in deployment technology has no effect on how goods are licensed or supported. A preview program is available so that you can start to test Office 2019 Preview in your organization.

Frequently asked questions

Q1: Can one continue using my older MSI Office products after Office 2019 is released?

A1: All previously released products will still be supported based on the applicable software lifecycle policy. There is no switch to existing products such as Office 2013 or Office 2016.

Q2: Does this mean that Office 2019 is going to be subscription-based? Will the software get additional features?

A2: Office 2019 is a perpetually-licensed product similar to previous major versions. It will receive regular security updates but no additional features after its release.

Q3: Will Office 2019 require an Internet connection or perhaps a user sign-in for product activation?

A3: Office 2019 uses device-based licenses similar to previous major versions. Users will be able to sign in if they wish to. However, they are not required to do this. Key Management Service (KMS) and Multiple Activation Keys (MAK) activation are available to volume license users for offline licensing. No Internet connection is needed to use the product.

Q4: Does this proceed to the Click-to-Run deployment model affect Visio or Project? What about Office Server?

A4: There will be no MSI releases for just about any Office client apps from 2019 onwards. All new Office client apps, including Visio and Project, is going to be distributed as Click-to-Run exclusively. However, Office Server will stay MSI-based only.
Pertains to

This article pertains to:

Office Professional Plus 2019

Windows 10 to automatically uninstall faulty monthly updates

The next iteration of Windows 10 will self-diagnose start-up failures and if necessary uninstall recent updates to get the PC ready to go, Microsoft quietly announced in a support document earlier this week.

“If Windows detects that the machine cannot launch successfully, it will attempt to diagnose and resolve failures because of disk issues, system file corruption, invalid registry keys, or other such causes,” the document said. “If each one of these steps are unsuccessful and your machine is still not able to launch properly, Windows determines if the startup issue was introduced after recent driver or quality updates were installed. If so, these updates might be uninstalled automatically to obtain the device back to a workable state.

“This is just done as a last resort,” Microsoft asserted.

The brand new functionality will be included with the following feature upgrade, designated 1903 in Microsoft’s yymm format and likely named “Windows 10 April 2019 Update.” The upgrade will most likely begin reaching users within the next a month.

If this sounds familiar, it ought to: Windows already retreats following a failed upgrade or update, attempting to restore the device to some runnable state. It’s in a single form or another since at least Windows, said Woody Leonard, a Computerworld columnist who also operates the AskWoody.com Windows tips website.

“There is a major difference,” said Susan Bradley, a pc network and security consultant who moderates the PatchMangement.org, a mailing list where IT administrators share questions and trade craft.

Bradley was requested her insights in the support document’s proclamations. “Currently if [Windows] rolls back the update, it will try again…and again…and the next day and the next day. The thing is update history screens in the forums where this poor person who includes a laptop that reboots every night is actually trying to install exactly the same stuck update over and over again.”

What Microsoft outlined for Windows 10 1903 would, if it worked as advertised, avoid the repetitive reboots Bradley described.

“If the removal of these updates enables the device to start up successfully, Windows will even prevent the removed updates from installing automatically for the following 30 days,” the support document read. “This is intended to give Microsoft and our partners the chance to investigate failure and resolve any issues. After Thirty days, when the updates are still applicable, Windows will try to install them again.”

“So instead of trying to reinstall every single day and rebooting every single day like now, [Windows] will go ‘Dang, I want help,’ and stop and then give Microsoft Thirty days to figure out wrong using the update,” Bradley explained.

Although Microsoft has spent more than a decade adding recovery skills to Windows – System Restore, for example, first took snapshots of everything by 2009’s Windows Vista – to cope with inevitable failures, criticism has steadily mounted about the quality of Windows 10’s refreshes. Last fall’s Windows 10 1809, which Microsoft yanked from distribution when reports surfaced of file deletions, pushed some customers to the edge of despair. Others regularly rail at half-baked monthly security updates that need another round – or more – of revisions before they’re judged safe to install.

The new restore-and-wait feature in 1903 is Microsoft’s method of admitting there’s a problem with quality, whether or not the response does not get towards the essence from the problem.

“They are acknowledging [that] they screw up, and [that] it takes approximately per month to find it and connect the updates,” Bradley said.

Microsoft Office 2019 Mac System Requirements – Preview Information

Microsoft is preparing to release the following major standalone form of Office 2019 edition for both Windows and Mac os’s. We already learned that the Windows Edition would only work on Windows 10 PCs. Although we’re many months away from release, we will become familiar with once the software is in GA ( Generally Available). In this article, however, we are only focussing around the Microsoft Office 2019 Mac System Requirements in the preview stage. Let’s find out!

Microsoft Office 2019 Mac System Requirements

In April 2018, the commercial preview of Office 2019 began for Enterprise customers who would primarily function as the target customers with this release. For private and small business users, Microsoft already has got the following options that you can go for, underneath the O365 subscription model. For Mac, you will find the following options, as per the state Microsoft Office blog.

Office 365 ProPlus standalone
Office 365 E3
Office 365 E4
Office 365 Business standalone
Office 365 Business Premium

With Office 2019 for MAC, you will get the next client applications:

Word 2019
Excel 2019
PowerPoint 2019
Outlook 2019 (Some features are dependent on Exchange 2019 or O365 Groups)
Onenote 2019

System Requirements: (Same as Mac for Office 2016 till final confirmation post GA)

Intel x86 64 CPU

4 GB or even more RAM

MAC OS 10.10 or newer

1280 x 800 or more display resolution monitor

6 GB of HDD with HFS Plus formatted disk.

Support for browsers for example IE, Edge, Safari, Chrome, or Firefox

DVD Drive

Ethernet/WiFi – Just in case if you’re installing over a network drive

The new edition of Office 2019 for Mac is expected to have better support for Pens and highlighters. A few of these features already are on O365 Pro plus but not on the current edition of Office 2016.

So, what’s the distinction between Office 2019 vs. subscription-based Office 365 model? Office 2019 for both Windows & Mac will probably be a one-time purchase and as per Microsoft, won’t receive feature updates after you buy the car. Office 2019 includes a meaningful subset of features available in Office 365, but it won’t be a part of Office 365. However, Office 2019 will receive both quality and security patch updates every so often as needed. Just like the earlier releases, this release is going to be fully supported for five years with two years of “Extended support” according to Microsofts FAQs.

In summary, Office 365 is a per-user-based subscription model run by Microsoft’s cloud service. It provides easy access to some suite of services well past exactly what the perpetual edition provides, and sometimes receives feature updates on an ongoing basis. Essentially it includes the most collaborative, secure, and up-to-date features.

So, how you can decide the uses cases for both the offerings?

Scenario Solution
  • Users interested in the latest features and functionality of Office
  • Someone who wants an early look at forthcoming changes or changes from prior Office versions
 Office 365

Office 365 products are continuously refreshed with new features & functionality. All functions in perpetual products are made accessible through Office 365 first.
  • Still picking between subscription (O365) or perpetual products
  • Wants to appraise new Office features to circumscribe suitability for deployment
  • Has a specific need for on-premises or per-device software licensing.
  • Using Windows 10 and wants to decide C2R deployment as a replacement for the current MSI deployment technology.
 Office 2019 Commercial Preview

Office 2019, the latest edition of on-premises apps and services, is available in preview with existing end-user and IT capabilities.

For many of our patrons, Office 365 is the way to go. It is the most secure, intelligent & collaborative version of Office products. However, moving to the Microsoft cloud is a journey, and customers may be in various stages of that journey, including approaches such as hybrid and on-premises.

Conclusion

If you want to join the preview, visit Office 2019 Commercial Preview Support. We will update the Microsoft Office 2019 Mac System Requirements once we get the final information post-release officially on the Microsoft website.

Disclaimer: The Answers and questions provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any sort, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or even the information, products, services, or related graphics contained online for any purpose.

Microsoft releases fix for botched Office 2016 patch, KB 4011093

Late last night, Microsoft released a brand new Office 2016 patch, KB 4011093. Based on the KB article, it fixes an insect within the Aug. 1 Office 2016 non-security patch KB 4011051, which left hyperlinks in Excel 2016 non-functional.

It also fixes two additional bugs:

For the 32-bit form of Outlook 2016, Office Store redirects you to the web store rather than opening the in-client store.
Editing languages and Help languages may be changed unexpectedly. For example, a presentation language might be missing from the editing languages list even if you haven’t took it off.

There’s no need to install this patch of the patch, unless you’re having issues with hyperlinks in Excel 2016 spreadsheets. KB 4011093 won’t go out via Windows Update. Check the KB article for manual download and installation instructions.