How To Fix “We Can’t Verify Who Created This File” Security Warning On Windows

So let’s say you have a Microsoft Access Database file, which you need to have 5 employees working on, at the same time. A great way to achieve it, is by creating a network drive, or in my case – shared folder.

In our office, we use Microsoft Access to manage our PO (purchase orders) system. We have 5 employees putting data in. The file itself is located on a “server” which is basically a local machine with Windows 7 premium installed. It has a shared folder, and they all work on this Microsoft Access Database (using Access “shared” open mode).

For 4 of the 5 employees everything goes pretty smoothly. One employee encountered a problem, where while trying to open the file – while others were using it – he got the following error:

“Open File – Security Warning: We can’t verify who created this file. Are you sure you want to open this file?”

We Cant Verify Who Created This File - Security Warning
We Cant Verify Who Created This File – Security Warning

The Solution

The problem here, is that the user is trying to open a file which is not located on the local drive. Windows thinks that the file is not safe (an intranet location) and tries to block it.

In order to resolve it, all we need to do is add the file’s location to the “trusted area”/ “safe zone”. To do that, follow these steps:

1. Open Control Panel, and go to “Internet Options”.

2. Click on the “Security” tab.

3. Click on “Local Intranet”.

4. Click on “Sites”.

Internet Options - Security - Local Intranet - Sites

5. Click on “Advanced”.

6. Click on “Add”.

7. Type in the shared folder address where the file is, for example \\home-pc\users\admin\documents\.

8. Click “Add”.

Windows 7 - add local intranet shared folder to zone

9. Click “Close” and then “OK”.

10. Try to open the file again, and you will be rid of the security warning.

Sync issues with OneDrive (SkyDrive Pro)

Recently I migrated our office from exchange server 2003 on premises to office 365 (mid-size business plan). I used the old-safe way of exporting all the mailboxes (.pst files) and importing them into Office 365, since we have only 30 mailboxes.

In terms of file sharing, we used a mounted drive located on the server. When the migration was done, I got rid of the server, and in terms of file sharing system, I purchased a 100 GB Dropbox account, which I installed on each and every computer.

Microsoft Office 365 comes with Sharepoint and file sharing features (based on Microsoft OneDrive, used to be called “SkyDrive Pro”), which means every user gets 25 GB of personal storage. The files are hosted on the cloud, and basically accessible from every computer that’s connected to the internet, where you can also set files to be accessible offline, by syncing folders to the computer).

I chose Dropbox because I didn’t have the time to train the employees on how to use OneDrive.

Recently I decided to migrate the whole file sharing system from Dropbox to OneDrive, so I started playing around with it, and testing it, before we switch to the new system.

The problem

While everything went smoothly in the beginning, as soon as I restarted my computer, OneDrive aut0-started, and there was a yellow exclamation point on OneDrive’s icon in the taskbar and an error message saying “we ran into problems syncing”, and also Microsoft Upload Center said “upload failed”.

Checking the error log, I found this:

ICsiError: csierrOdc_ScopeIntersectionUnresolvable (0x7B)

Error code=0x80004005; Error source=Groove

The solution

To solve this problem, we have 2 options. Option 1 is the shortest and most of the time solves it pretty fast. Option 2 takes more time, so use it as a backup if option 1 fails for you.

Option 1

1. Open the Task Manager and end every Office process (MSOSYNC.EXE, GROOVE.EXE and MSOUC.EXE).

Sync issues with OneDrive - SkyDrive Pro
Sync issues with OneDrive – SkyDrive Pro

2. Open Windows Explorer, navigate to the following locations and delete everything (files & folders):

C:\Users\%username%\AppData\Local\Microsoft\Office\Spw

C:\Users\%username%\AppData\Local\Microsoft\Office\15.0\OfficeFileCache

3. Go to Office 365 online, click “sync” in OneDrive, and OneDrive app should start running again and sync normally.

If this method didn’t help you, try the following option 2, and at the end repeat step 1 to 3 of option 1.

Option 2

1. Right click on OneDrive’s icon in the taskbar, and choose “stop syncing a folder”.

2. Open windows explorer, and look for the OneDrive folder (usually on the left side, under “favorites”). Right click on the folder and delete it (all the content + the folder itself).

3. Go to Internet Explorer (even if you’re not using it), and clear browsing history (Settings -> Internet Options -> “Browsing History” -> Delete).

4. Run Disk cleanup (right click on your system drive -> Properties -> Disk cleanup).

5. Repeat Option 1.

Good luck!

What is Trello and How to Use Trello

Trello is currently being marketed as a collaboration tool that can help to organize various projects and make it easier to get things done on time. You can use it to organize your tasks, create checklists and search assignments- among other things- and the possibilities are virtually endless when it comes to using this website. It can be used in a variety of different ways.

If you are looking for a better way to keep yourself organized, then Trello really can help. It is not only fun to use, it is practical- and best of all it is free to download!

Trello Example Board
Trello Example Board

Using Trello for Project Collaboration

Trello was originally created as a project collaboration tool. It uses boards, checklists, cards, and various labels to assign tasks to members of your team, and you can also see what is in progress and who is working on what assignments. It is one of the easiest ways for you to handle the task management in your workplace, or in your home environment. It can help with both large and small collaborative projects.

Whether you are trying to set up a large project for a large number of freelancers that work remotely, or you are just trying to set up a chore list for the people in your household, Trello can help! If you haven’t already started using this great tool, then you don’t know what you are missing out on. Let’s go over some of the information about how it works, and how it can help you.

Add members to Trello
Add members to Trello

Understanding the Components of Trello

It is important to understand the three basic components that make up Trello. They include the boards, the lists and the cards.

Boards: Boards are actually used to help when it comes to managing large projects or campaigns. You use it board to build your project on the program. You may have a separate board for various projects that you have going on, to keep them separate and keep them on track. You can manage the board, and determine how small or how large you need it to be. It really is completely customizable, and it makes it easy for you to stay on track with your goals.

  • On the right of your board, you will notice that there are various different functions that you can choose from. You can add members, change settings, and filter.
  • You can also take a look at the activity feed within your board, just to see how much progress is being made, and by whom.

Lists: Lists are used along with the boards, and they separate and track the tasks into columns- based on categories. This helps you to see what is going on with the project, and how many tasks are required to finish the project. You can modify your lists as needed to make sure that you are on the right track with everything.

Move cards on Trello by dragging them from list to list
Move cards on Trello by dragging them from list to list

Cards: Cards are actually the components that fall under the lists. They are the individual tasks that are assigned to the lists within your boards. Each card is a task that is assigned to certain members of your team, and you can track progress on the cards as well. This is basically a small ‘checklist’ of sorts.

  • If you click on a particular card within your list, you will be able to see properties. You can also add due dates, team members, files, or checklists to the card.
  • You can also take a look at the progress on the card, if you take a look at the progress bar that is located on the bottom of the card.

Now that you have a better understanding of the basic components of Trello, are you ready to get started with it? This gives you a bit of a background on the program, but using it is something that you will actually learn best through first hand experience. Sure, you can watch tutorials and learn various tips and tricks, but many things you will actually be able to learn by simply playing around with the website.

Who Can Use Trello?

Trello can actually be used by both professionals and individuals. It helps to make it easier to manage time, and get things done. For people that procrastinate, this can actually be a life saving tool! Don’t let yourself get backed up with projects, or spend time trying to figure out how to effectively manage your projects! Instead, why not just give Trello a try? It has really started taking the world by storm, and many people are finding it to be a tool that they just can’t live without now that they have tried it and found it effective at helping with time and project management.

Trello Card
Trello Card
Trello iOS app
Trello iOS app

How to Use Trello

Using Trello is actually quite simple, at first glance. You can use it to make lists within lists, and you can drag and drop tasks, and it is really just a fun tool to use. While it appears really simple, there are various features that may make your experience with this tool a lot smoother. In fact, you can use certain features to help you when it comes to switching boards, editing cards, uploading attachments, and much more. There are also shortcuts that you can use to make it easier for you to get things done.

All in all, Trello seems to really be making a positive impact on the world. In a world where it seems like the days just get shorter and shorter, it makes sense that we would need to find a way to make things just a little bit easier. This is perhaps one of the main reasons why Trello was introduced- and definitely one of the main reasons why it has been such a hit!

Sign up to Trello

What is Dropbox And How To Use Dropbox

Dropbox is a cloud storage program that offers a great way for you to store and access your data from virtually anywhere with an internet connection. It is designed for people that want to access their files from anywhere, but don’t like to carry around a thumb drive or email files to their own email address. It has become increasingly popular, as more and more people are moving to the cloud. If you are looking for something that will help you to manage your files easier, then it may be something worth looking into. Let’s take a closer look at how it works, and how it may benefit you.

How Dropbox Works

When you create a Dropbox account, it gives you a folder that will sync with all of your devices. When you save a file, you will simply add it to your Dropbox folder on your desktop, or on any of your other devices. It doesn’t require you to have a large storage space on your desktop, because the data is stored virtually through the cloud. It works on a variety of devices, including PCs, Macs, iPhones, iPads, and many Android devices, among others.

Accessing Your Dropbox Account

Accessing your account is not difficult. In fact, when you set your account up, you will be able to sync the folder on all devices. Then, when you login to your account, whether you are on your desktop or on your mobile device, you will be able to view the folder and open the documents. You can even log in from another computer, go to Dropbox.com, and login to your account to view your folders. You don’t even have to keep the icon on your desktop, although this is the easiest way to drag and drop files to be saved and synced. It is really quite simple, and anyone with any background with computers should be able to do it.

The Benefits of Using Dropbox

Dropbox offers a variety of benefits. While it is obviously a great place to store your data because it allows you to access it anywhere, it has other benefits that you should consider as well:

  • You can store audio, video, photo, and other document types.
  • You can sync devices across the globe, with just the click of a button.
  • You can recover your deleted files for up to 30 days, or longer with a paid account.
  • You can use the software to share files and folders with friends and family.
  • You always have a backup of your data, even if you lose it on a particular device.

As you can see, Dropbox is really an effective tool that can be used for a variety of different reasons. If it isn’t something that you have tried before, then it may be time for you to take a look into it. It could really prove beneficial to you- even if you just use it as a way to backup your files virtually so that you don’t have to worry about losing important documents in the event that your computer is stolen, damaged, or compromised. It is also safe to use, and your data is always secure.

Share Files Easily

One of the biggest advantages is the file sharing. Any time you want to share a file with someone, as long as they have a Dropbox account, you can just click share and choose the folder or file. It shares instantly. You can even make shared folders that you share with everyone in your family, which is a great way to share family photos. It is also great for business use, because it allows you to share your information with everyone in the workplace with ease. It is an essential tool for businesses, for sure, as well as individuals.

Pricing Structures

So, just how much does Dropbox cost? If you look into it, you will find that they offer a free version. This gives you up to 2GB of storage space, and you don’t have to pay anything for it. This is sometimes enough for some people, and they even have a great referral program that allows you to earn more storage space.

They also offer paid memberships, and they are as follows:

  • 100GB for $9.99/mo or $99/year
  • 200GB for $19.99/mo or $199/year
  • 500GB for $49.99/mo or $499/year

For teams that need a great deal of storage space, they also have the Dropbox Teams option, which costs roughly $795 annually. It can be used by up to 5 users, and it offers a terabyte of storage space. It also offers 200GB of additional storage space for any new users that may be added later. These added users are $125 annually.

How to Get Started

To get started with Dropbox, you will start by downloading the software to your computer. You will also want to get the apps on your mobile devices. Register for your account and install the folder onto your desktop. You will then be ready to start using the program, and start reaping the benefits. It only takes just a few minutes to download it.

The Bottom Line

As you can see, Dropbox can really be a great tool. It is easy to download, and easy to use. It is designed so that just about anyone that uses a computer should be able to use it. It offers free storage options for those that want to try it out, or those that just simply don’t need a lot of storage space. It is something that people wish they had around many years ago, because it really just helps to make life a lot easier. You always have your files on the go, and you can share with just a few clicks. It doesn’t get much simpler than that.

Sign up – start using Dropbox today!

How To Set Outlook 2013 Calendar Reminders To Stay On Top And In Focus

Recently I migrated our company to Office 365. It was a big change, since we used to use Office 2003 that was connected to Exchange Server 2003 Onsite. One of the biggest changes about Outlook 2013, is that when the Calendar reminder window “pops up”, it usually stays “hidden” behind many other windows. It does play a sound and the window “blinks” yellow in the task bar, but if you’re concentrating on something else, it’s easy to dismiss it, and you could find yourself running late to a meeting.

The Problem

Microsoft has designed it to work that way, so that if you’re in the middle of something and don’t see the pop up window, you won’t press “Enter” by mistake, confirm the reminders and make the window disappear. Hence, when Outlook 2013 calendar reminder window pops up, it becomes hidden since there are other open windows covering it.

The Solution

One simple solution is to set a different – more noticeable – sound to the reminder window. You can do that by opening Outlook -> File -> Options -> Choose “Advanced” on the left side -> Click “Browse” and choose a different sound under the “Play Reminder Sound” field.

Of course – this simple solution won’t help you set Outlook reminders to stay on top.

The real solution here is a VBA based code (Don’t freak out, it’s pretty simple and easy to create) that pops up a customizeable message box that stays on top of every other window, and you can’t ignore it. The only con I find for this solution, is that this message box comes before the reminder window, and in order to view the reminder window, you need to click “ok” on the message box.

This guide is related to Windows 7 and Office 2013 / Office 365, althoug h I assume it will work in Windows 8 as well. So here we go:

1. First – we need to create a Digital Certificate:

How To Find And Create Digital Certificate In Office 2013:

I read on many websites that you need to click “Start” and type “Certificate” and then choose “Digital Certificate for VBA Projects”, but it will not work in Office 2013 / Windows 7.

In order to Create a Digital Certificate, we need to run the file “SELFCERT.EXE”. Here is the file location: “C:\Program Files\Microsoft Office 15\root\office15”.

When you run the file, you’ll get this window:

Office 2013 "Create Digital Certificate" window
Office 2013 “Create Digital Certificate” window

2. Name your certificate and click “OK”. “outlookreminder” for example [without the quotation marks].

3. You’ll get a message says “Succesfully created a new certificate for outlookreminder”. Click “OK”.

4. Go to Outlook, and press ALT + F11 to open the VBA Editor.

5. On the left side, you’ll see “Project 1”. Double click, it will expand and you’ll see “Microsoft Outlook Objects”. Double Click it, it will expand and you’ll see “ThisOutlookSession”. Double click it.

6. On the window on the right side, copy and paste the following code [You can always change the text ‘This is a friendly reminder…’ and the title “Attention!”]:

Private Sub Application_Reminder(ByVal Item As Object)<br /><br />If TypeOf Item Is AppointmentItem Then<br /> MsgBox "This is a friendly reminder about upcoming meeting!", vbSystemModal, "Attention!"<br /> End If<br /><br />End Sub

7. Your final window should look like this:

8. Click Save [Don’t exit yet!].

9. In order to run the macro, we need to “sign” it. To do that, go to Tools -> Digital Signature -> Click “Choose” and select the certificate name we’ve created before [I named it “outlookreminder”, remember?].

10. Click “OK”, save again and close the window.

11. Now – since this is a macro, we need to allow it in Outlook. I’ve tried to allow this macro specifically with no success. I had no choice but allowing all macros. It’s not risky in my opinion, but do it at your own risk.

12. In Outlook, Go to File -> Options -> Trust Center -> Trust Center Settings -> Macro Settings -> Check “Enable All Macros”. Click “OK”, close Outlook and open Outlook again.

13. From now on, every time there’s a calendar reminder, you’ll get a message box that will stay on top of each and every window, and trust me, you WON’T ignore it.

14. You welcome:

The Final Result
The Final Result

How to get folder size in Windows

Having a Solid State Drive (SSD) is a great idea. SSD contains no actual “disk” of any kind, nor motors to “drive” the disks. It is a data storage device using integrated circuit assemblies as memory to store data persistently (Wikipedia)

As a matter of fact, imagine your regular hard drive, but on steroids. SSD drives are very fast and reliable, but there are two major problems with them nowadays: Price and Size.

SSD drives are pretty expensive in comparison to regular hard drives, and if that’s not enough, they are pretty small. A decent GB120 SSD costs USD99.99, while 1TB regular drive costs less than USD65.

So when you have a SSD in your laptop, you gotta keep it tight with the space consumption. It’s very easy to run out of space with SSD. My SSD became almost full this week, so I had to clean it up a little bit. The best way to start cleaning up your hard drive, is by identifying fat folders, and start digging in.

How to get folder size in windows

Back then, in Windows XP era, we were able to add the “folder size” column to the explorer window. For some reason, Microsoft decided to cancel this option with windows Vista, Windows 7 and 8. God knows why. I find this feature very important especially when you want to clean your hard drive, and you wanna know which are the biggest folders.

So I found a small program called “Folder Size“. As simple as that. Folder Size shows sizes of folders seen in Explorer windows.

Go to the download page, install the program and you got it:

Folder Size - Get folder size in Windows
Folder Size – Get folder size in Windows

Windows 8.1 is available now

Microsoft announced the global availability of Windows 8.1, a feature-rich update to its popular Windows 8 operating system, enabling customers to create experiences that keep pace with their lives — at work, at home or on the go. Beginning Oct. 17, consumers with a Windows 8 device in more than 230 markets and 37 languages can download the free update via the online Windows Store. Windows 8.1 will also be available on new devices and as boxed software starting Oct. 18 at retail locations around the world.

Windows 8.1 evolves the Windows vision for highly personalized computing while showcasing Microsoft’s continued commitment to rapid and responsive development. It marks a wave of new, innovative devices coming for consumers and businesses — from the convenience and mobility of tablets and 2-in-1s to the productive experience expected from laptops, all-in-ones and specialized industry devices. Many of these new devices are touch-enabled and will deliver advancements in processing power, battery life and design, across a range of price points.

Windows 8.1 offers a host of increased customization refinements and functional improvements, including the following:

  • Highly personal. An improved and more customizable Start screen offers variable tile sizes, more background designs and colors so each Windows device looks unique and personal to the individual. In addition, customers can choose how to start their Windows experience — at the Start screen or directly in the familiar Windows desktop — while all their Windows devices stay in sync with their Microsoft account.
  • More familiar and easy to navigate. As an iconic part of the Windows experience, Windows 8.1 brings back the Start button as a familiar point of navigation. An updated apps view lets users see all their apps at once for easy access and new clicks and cues, as well as a Help + Tips app that gets them up to speed quickly.
  • Enhanced search. The new Bing Smart Search provides the easiest way to find what users need on the device or on the Web in one beautiful and easy consolidated view that’s built for touch. Simply swipe or type from the Start screen, and Smart Search will find it — whether it’s a document on a PC, a photo album on SkyDrive, a favorite app, a song from Xbox Music or a website.
  • Wide range of apps and services from the Start. Windows 8.1 is the most complete out-of-the-box experience. It offers a range of apps and services from the Start screen, allowing customers to quickly and easily do the things they love on Windows, such as catching up with friends and family via Skype, emailing effortlessly in the Mail app, watching movies and TV shows on Xbox Video, finding new recipes with the Bing Food & Drink app, or listening to free streaming music via Xbox Music. Windows 8.1 also comes with the new Internet Explorer 11, which is fast, fluid and perfect for touch. Internet Explorer 11 brings enhanced touch performance, speed boosts, and synchronized browsing history, favorites and settings across all Windows 8.1 devices. Windows 8.1 also provides native support for 3-D printing, meaning it will have plug-and-play support for 3-D printers, enable apps to seamlessly print 3-D jobs and understand 3-D file formats.
  • The best for multitasking and productivity. Windows 8.1 includes the display and use of up to four apps side by side, flexible windows sizing for each app on the screen, the ability for one app to launch another app, and improved multimonitor support so users can view the desktop or apps from the Windows Store on any or all monitors.
  • Deep cloud integration with SkyDrive. Windows 8.1 makes it easier than ever to work from anywhere and know that files are always accessible — across devices and locations. With SkyDrive, users can create, edit, save and share files anywhere, anytime, on whatever device they’re using.
  • A beautifully redesigned Windows Store. The new design of the Windows Store improves how great apps are showcased and makes it easier for customers to get the apps they want. Fresh layouts and categories, such as New & Rising, make it easier to stay up to date on the hottest new entries to explore. Personalized recommendations use the Bing advanced recommendation and relevance system to help find new favorites. And with Windows 8.1, apps are updated automatically by default, so users always have the newest and best version of any app, such as Fresh Paint, which now includes watercolor, a new graphite pencil set and a new clean, modern user interface for the latest painting or drawing creations. New and updated apps are also continually being delivered to the Windows Store, including Evernote, Facebook for Windows 8.1, Hulu Plus, Adobe Photoshop Express, eBay, Netflix and NOOK.

Customers can go to http://www.windows.com/shop to learn about the wide variety of new Windows devices available now and throughout the holiday season to find the one that best fits their needs and budgets. More information about Windows 8.1 is athttp://blogs.windows.com and http://www.microsoft.com/en-us/news.

Filezilla Site Manager – Cannot remember password

Almost every web developer I know uses FileZilla. FileZilla is free and cross-platform FTP software, consisting of FileZilla Client and FileZilla Server. Binaries are available for Windows, Linux, and Mac OS X. According to Wikipedia, at 2011, Filezilla FTP Client was the 7th most popular download of all time from SourceForge.net.

I recently got a new computer, and had to install Filezilla on it. Usually when I get a new laptop, I remember to backup almost everything from the old one. This time, I forgot to backup The Site Manager. The Site Manager allows FileZilla client users to store information about their FTP sites, so they won’t have to remember a lot of info, such usernames, passwords, ports etc.

I had login details of almost 20 sites, so it was kind of annoying to store the details all over again.

The problem:

I started typing in the first server’s details – host, username and password. Simple one. I hit “ok” to save this entry and all I got was this error: “Site Manager – Cannot remember password: Saving of passwords has been disabled by you. ‘Normal’ and ‘Account’ logotypes are not available. Your entry has been change to ‘Ask for password”. Filezilla Site Manager cannot remember password.

Filezilla: Site Manager Cannot remember password
Filezilla: Site Manager Cannot remember password

Since I’d just installed it, I didn’t remember that I set this option during the installation process. I tried to think about any other solutions, including User Access Control of Windows 7, etc.

The solution:

Apparently, FileZilla – for some reason – sets this option by default. The solution here is pretty easy. I spent 30 min on this, just because there was no solution on Google. You spent only 2 minutes reading this post 🙂

To make Filezilla’s Site Manager save passwords, all you have to do is to go to Edit -> Settings -> on the left side click “Interface” -> On the right side, uncheck the “Do not save passwords” checkbox under “behavior” section.

FileZilla - Save passwords option
FileZilla – Save passwords option