Using Delphi Firedac to compact and repair a MS Access Database.

Rad Studio Delphi Development
Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. The tools provide developers with components or services that create superb applications. Delphi Firedac provides a unique set of Universal Data Access Components for developing multi-device database applications. This will show the older method of compacting and repairing MS Access databases. The code listed below demonstrates the process. Very straight forward you need to create the object, populate the commands and you are ready to go. function CompactAndRepair(DB: string): Boolean; var v: OLEvariant; begin Result := True; try v := CreateOLEObject('JRO.JetEngine'); try V.CompactDatabase('Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB, 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB+'compacted;Jet OLEDB:Engine Type=5'); DeleteFile(DB); RenameFile(DB+'compacted',DB); finally V := Unassigned; end; except Result := False; end; end; Delphi Firedac now has…
Read More

Microsoft Office 2019 will only work on Windows 10

Software Releases
Microsoft Office 2019 will only work on Windows 10 Microsoft is providing an update on Office 2019 today, revealing that it will only run on Windows 10. On the Microsoft web site there is a story for service and support of Windows and Office, Microsoft has revealed you’ll need to upgrade to Windows 10 if you want the latest version of Office without subscribing to the company’s Office 365 service. Microsoft Office 2019 has been one of the strongest profit making packages that Microsoft does sell and since It’s a move that’s clearly designed to push businesses that are holding off on Office 365 into subscriptions to use it will have to upgrade all machines to Windows 10. This won’t affect Office for Mac, which is a separate product with a different release…
Read More

Windows 10—Fall Creators Update SDK is now available Sweepstakes

Microsoft Development, Software development Concepts
  Windows 10 SDK Fall Creators Update SDK Downloads and tools for Windows 10 Visual Studio 2017 The latest version of Visual Studio, released October 2017 The latest Windows Standalone SDK (ver. 10.0.16299.15) Templates for Universal Windows Platform (UWP) apps for tablet, phone, PC, Windows IoT, or Xbox Templates for Windows desktop applications Windows 10 Mobile emulators Log in and take a chance *No Purchase Necessary. Open only to Universal Windows Apps developers 18+. Sweepstakes ends November 17, 2017. For details, see Official Rules Download the Windows 10—Fall Creators Update SDK today. Want to learn more about what’s in it? Get the overview by watching the Windows Developer Day keynote and dive deeper with over 18 sessions on Windows 10 features and capabilities here. And don’t forget to enter an epic sweepstakes with amazing prizes.…
Read More

How to purge Microsoft SQL email Items

Computer PC Tips - bits and bytes, SQL Tips
How to purge Microsoft SQL email Items There are times that housecleaning older mail in your database needs to be done.  A simple scheduled task can be done every month to purge what is no longer necessary.  SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove these mail history unless it is required for auditing or other purposes. As always make sure you have your backups done prior to running any sort of removal in the event you did something incorrectly.  By purging you are reducing the amount of wasted space in the msdb database that could be used for other things activities. Simply running the following statement using T-SQL you can check the amount of database mails that have been processed from…
Read More

How the 9-to-5 workday has disappeared

Software development Concepts, Software Events
How the 9-to-5 workday has disappeared   Work has changed dramatically over the last few decades, according to a report in The Wall Street Journal recently release it has become more time-consuming, less stable, and more flexible. In 1973, 6% of Americans said they worked excessive hours while in 2016, 26% said they worked more than 48 hours a week. Insurance coverage by employers has also dropped since 1973, although companies now provide more benefits to aid work-life balance, such as paid parental leave and remote work options. Businesses are spending less on employees, both in terms of compensation and capital investment, while investors get triple the payout from 30 years ago. This has all contributed to workers increasingly acting like free agents in the job market.  While they have…
Read More