David Stein

Archives

What's in Your Backup?

I’ve been speaking with a fellow M2M Admin and helping him get up to speed. I was shocked when he admitted to me that he had no backups. He explained that they were using Raid 5, and therefore didn’t need any. If you’re in this situation, don’t feel bad. Most of us work for small [...]

Permissions Report Pecipitates Predicaments

In a previous post a user made the following comment:

talking on the topic of permission how I can generate a report per screen that will show only the user that have at least one permission and not showing all users wit no permission at all!!

I’ve always been annoyed by the report aspect of M2M [...]

Web Support Spotlight Days

What are Web Support Spotlight Days?

Anyone who administers Made2Manage is aware of Web Support Spotlight Days. These days always occur on Fridays and Made2Manage Support stops accepting incoming support calls, only accepting requests through its website. This idea is sold to customers as a means of showcasing M2M’s excellent web support options, and that support [...]

Purging Pointless Permission Records Provides Performance Payoff

This article is obviously a follow up to Permission Problems post I published previously. The other day I was using the User Permissions Report (RPUSER), I noticed something amiss. I had recently deleted a couple of educational and testing companies which many people used. However, like many other areas of M2M, the records are [...]

Honey, I Shrunk my Project File

I’ve mentioned in the past how difficult M2M’s flavor of VBA is to use. One problem that I haven’t touched on is the problem of VBA file corruption.

M2M VBA File Corruption? What exactly are you talking about?

When I talk about the VBA file, I am referring to the M2VEvents.prj file. This is the [...]

All the Little Ants are Marching...

“I got an ant farm; them fellas didn’t grow shit.” – Mitch Hedberg

A few months ago I became aware that a company I deal with still uses dot matrix printers. For those of you who have never seen one, that’s because most companies phased these relics out of existence fifteen years ago.

The dot matrix printer [...]

Removing Null Country Values From the Syaddr Table

Unfortunately M2M does not automatically populate the Country field on many screens when a US State is selected. This can cause problems in reporting when an executive wants sales broken down by country and many of them are grouped under Null.

Anyway, if you want to see how many addresses are missing “United States” you [...]

Standard Disclaimer

As I was preparing to post another script, this time with an update statement, I started to insert my standard disclaimer. However, as more and more of my posts will include SQL code, I thought I would just dedicate one post for the disclaimer and then link to it. So, without further adieu…

Important: All information [...]

M2M Database Polls

One of my crappy college jobs was in market research. Yes, I was one of those annoying guys in the mall holding a clipboard. I would approach you, politely ask you about your soda preferences (for the enlightened folks we call it Pop), and then take you back into the “store” to do a taste [...]