Linking BCM to Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there
I would like to use my BCM Accounts as a linked table in a new database I'm
creating in access but when I do this, only a very limited number of fields
appear and I cannot seem to add any more. In particular, I would like the
"category" field to be available (read only) in access, so that I could
filter the table by customer/supplier etc.
Thanks in advance
Rebecca
 
Are you linking Access by connecting via ODBC/OleDB to the BCM
database? If that's the case, try linking to one of the SQL views
instead of going to the tables directly.
 
Back
Top