Hello Rinze
use foreign key relationships and cascade deletes / updates for this
purpose.
with SMS you can do this graphicly but it is also possible with script
http://technet.microsoft.com/en-us/l.../ms173393.aspx
HTH
Michel
"Rinze" <a@xxxxxx> schreef in bericht
news:e22LOKV%23JHA.5092@xxxxxx
Quote:
> Michel Posseth [MCP] wrote: Quote:
>> Hello Rinze
>>
>>
>> Access is a dead end in your situation , the only good substitute would
>> be to use SQL server CE wich is file based and is XCOPY deployable it
>> has all the good stuff that ACCESS had from a developers perspective
>>
>>
>> HTH
>>
>> Michel Posseth
>>
>
> I kinda figured it was a dead end 
In Access I can define relations that
> enforce referential integrity (i.e. I delete/update a record from one
> table and it deletes/updates the related records in another table
> automatically). That seems to be missing from SQLServerCE. I haven't found
> a way to define relations (if there is, please let me know). So in that
> sense it doesn't have all the good stuff Access had/has.
>
> Rinze