Yes, it does keep a Tx. log. And, I have it on good authority that integrated security is in fact, supported. Based on the website, when you install MSDE, you have the SQL-DMO objects at your disposal. If this is true, then you can define users, roles, etc.


>Hi JVP -----
>
>I agree. With the need for strong security and transaction logging, a dedicated server database is required regardless of topology. DBFs fall down in that respect. I haven't played with MSDE too mush; does it keep a trnxlog?
>
>
>>OK John, consider this scenario:
>>
>>I have a data-set that will never grow beyond 10 mb's. However, the data set contains confidential information and needs inherent security. Also, because of certain requirements, a detailed transaction log needs to be kept.
>>
>>Is the data-set small? Yes.
>>Will DBF's work? No.
>>
>>I could have taken this example further to really skew it toward SQL-Server, or some other server RDBMS. Then again, I did'nt have to.
>>
>>This is an interesting discussion. Let's keep it going...
>>
>>
>>
>>>>
>>If an application is never going to grow beyond a set, reasonable amount of users I was advocating sticking with the good ole DBF format.
>><<