Dear Forum:

GOAL:  
I want to use MS Access to write reports based on the BCM SQL database.   I
need to utilize the standard fields in BCM, plus any custom fields that I
create.

APPROACH TO DATE:
1.  I have set up MS Business Contact Manager and it is running well.  
2.  I have added several custom fields in the Accounts form.  That works
fine as well.  
3.  I have also used MS Access to connect to the BCM SQL database. I am
connected to the database and can see all of the tables and views.  I have
used Access as a front end to MS SQL via an Access Project.
4.  When I pull up a view in Access (i.e. AccountIMAPIview) I can see the
Account data, as well as the custom fields that are called UserField(1 - 40).
I can even see SOME of the data that I entered in the custom fields and that
is my problem.

PROBLEM I AM HAVING:
The problem I am having is that only certain custom fields appear to be
visible in the Access DBS.  It looks like only a Text or Drop Down custom
field is visible in the Access DBS.  The other fields (i.e. Number, Percent,
Integer) have a ?A in the field.  It appears as if Access or SQL cannot
recognize the custom field that was created.

Does anyone know how to solve this issue, or have any other suggested
methodologies.

Regards,
zMendel