Sage 100

**90 Minds Feed The Mind Series** Education Committee member Roberta Chase has prepared the following for our membership. This article will also be posted into our Evernote Knowledgebase collection.

OLE DB is the preferred connector and I agree it is a lower level, more efficient connector than ODBC. One caveat: If using Alerts & Workflows to schedule Crystal reports, OLE DB won;t work. You need to use an ODBC connector to SQL for A&W or the Crystal report won't run. This is ironic because A&W is SQL driven, ie events are SQL triggers. You would think A&W would be OLE DB compatible.

I thought that even though it's SQL driven, it still uses Access to drive the bus.

Aren't there two version of A&W, one being the Access version?