>>Hi,
>>
>>So the customers would access their data directly on the accountants server? No local data copy?
>>Regards,
>>Viv
>__
>
>I'm a customer and I have my local mdf file which I access with the native drivers
As already stated you will need SQLServer installed to do that. The native client is used to access the server. IAC, if you are using .NET you should use the build-in SQL dataprovider not native client.
>
>Then, at the end of the month or so, I put the mdf file (or a backup - to sort out) in the mail to the accountant. My local database becomes read-only.
>
>The accountant has his (sql) server and restores the backup from the mail to the server. The database is attached and accessed via the sql server service
>He works a bit on it and may then decide to mail back a changed version of that database.
>
>At any point in time, although there will be different 'copies' of a database, only one will be 'alive'
>
>No customer has access to any computer of the accountant
>
>thanks, Viv
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only