Never mind, I figured it out.
After posting this question, I saw another thread about ovrriding the GetConnectionString method in Abusiness Object. This is what I did and it works fine.
>The connection string for SqlCE can contain a path like this:
>
>Data Source = C:\MyApp\MyApp.sdf
>
>This works great if the database will always be in the same folder, but I would like my install to copy the database to the Common Application Folder for all Users. So in Windows XP, the folder might be:
>
>C:\Documents and Settings\All Users\Application Data\MyApp
>
>The Common Application Folder in Windows Vista is totally different. So I would like to default my connection string to just the database name. Then add logic to the mmBuisnessObject.GetConnectionString() method to add the correct path.
>
>What is the best way to accomplish this? Can I add a Factory method? Thanks in advance for any help.
>
>Kind Regards,
>
>Mat