Linking BCM to Access Database

R

Rebecca Dell

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
 
L

Luther

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
BCM database name - missing or somewhere else? 0
Excel Word and PDF files on a BCM 2010 shared database 0
BCM 2010 Changelog 1
BCM 2010 DB Sharing Options 0
Suppliers in Accounting 2009 not displaying in BCM 2
How do I clear a form? 0
Sharing BCM contacts and linking items to records 1

Top