Accessing the M2M Database Using VBA.

A couple of weeks ago, someone sent me some VBA code which was giving them fits. I often receive requests like this and am glad to help when I can. I came across this bit of code:

Private Function fConn() As ADODB.Connection
Dim oCn As New ADODB.Connection
Dim sCnStr As String
sCnStr =”uid=sa;pwd=HisPassword;” […]

Choosing a Made2Manage Consultant

The Bobs – Office Space

As I mentioned in my first post I’ve been working as a Made2Manage Administrator for more than 10 years. However, even if you’ve been one of my regular readers, you may not be aware that I’ve also been an independent consultant for the last several years as […]

Data Utilities – Convenience or Crutch?

Recently I’ve been assisting a company with discrepancies in inventory master and inventory on hand tables. One problem is negative quantities in their inspection which can’t be removed, and they also have problems with inconsistencies in their on hand quantities of various parts.

So, a user brings the Material Availability (RPMAVL) and the […]

M2M Releases Version 5.6 SP3…. umm..6 weeks ago.

Let me preface this by saying that very few M2M Admins are more active than myself. I am on M2M Expert nearly every day. I found out that SP3 was released through the Los Angeles Area Made2Manage User Group on Google Groups.

Am I the only one who didn’t know SP3 was released? […]

Answers are Easy, the Questions are Hard.

In the past year I’ve been doing a lot of T-SQL (Transact-SQL) programming. My current employer has required a great deal of it, and I have searched out several people and places on the internet to gain this knowledge.

However, as I’ve progressed on this journey I’ve noticed a curious thing. The […]

Please Santa, Can I Have an Error Log in a SQL Table for Christmas.

A Christmas Story

At the time of this writing, the M2M error log is still being kept in a text file, not surprisingly called error.log. I understand that this is probably the most expedient way for M2M to capture it. I suspect it’s a lot easier code-wise to simply append […]

It's Beginning to Look a lot Like Christmas

I’ve always loved Christmas Lights, but some people go overboard.

M2M can’t be decorated like that, but you can add a touch of holiday spirit. Follow the directions below and you can have your active cell indicator switch daily from green to red, the colors of Christmas.

December 4th, 2008 | Tags: , , | Category: Made2Manage | 3 comments

Well, We’re Movin’ on Up. M2M Migration

Movin’ on Up.

In a previous post, I indicated that I would post my migration procedures. Made2Manage offers instructions to set up a test server and basic migration directions, but they don’t offer recommendations of what exactly should be tested during migrations. This is unfortunate, because only they know where […]

Inquiring Minds Want to Know About your use of FastForms

I’m trying to determine which M2M topics you folks want to read about. We can all use VBA, but since FastForms is an optional module less people may be interested in reading about it.

Please specify your level of interest in M2M FastForms.

I own FastForms and […]

Some Quick Topics

Here are some things I thought were interesting this week:

A Few Good DBA’s This is a humorous take on Jack Nicholson’s rant in “A Few Good Men.” I’ll include an excerpt below as the site requires free registration to view the article and I know many of you won’t bother.

Manager: […]