I must be blind!

[AGF]

I want to interface my BCM database with Access for reporting. So I followed
the many posts here to find my BCM database (C:\Documents and
settings\<username>\Local Settings\Application Data\Microsoft\Business
Contact Manager) and there is not a .lbf or a .mdf file in the BCM folder.
The only thing there is the registration.xml and the startupservice.ini
files. My BCM database name is MSSmallBusiness3. I have searched the hard
drive for these extensions and db name and come up with nothing. But yet
everything works fine. Any thoughts on why I can not find anything?

 

[AGF]

In my account settings it shows the location as <cumpter name>:MSSmallBusiness3

 

[Nigel Ainscoe]

Download the SQL Management Express tools (FREE) from microsoft

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en


This will have wrapped over more than one line once I have posted it so make
sure you get the whole URL

After you install this you can explore all sorts of exiting things about
your BCM database, including where the data files are.

Happy New Year
Nigel Ainscoe

 

[Luther]

I want to interface my BCM database with Access for reporting.  So I followed
the many posts here to find my BCM database (C:\Documents and
settings\<username>\Local Settings\Application Data\Microsoft\Business
Contact Manager) and there is not a .lbf or a .mdf file in the BCM folder..  
The only thing there is the registration.xml and the startupservice.ini
files.  My BCM database name is MSSmallBusiness3.  I have searched the hard
drive for these extensions and db name and come up with nothing.  But yet
everything works fine.  Any thoughts on why I can not find anything?

When Access connects to a sql database, it does so using the sql
service, instead of using files directly. So, if you can't find the
files themselves, that shouldn't prevent you from using Access.

I second using SQL Management Express if you need to work with a
database outside of BCM.