Hi,
Snips:
The accountant would have an sql server whilst the customers would access the database with the native drivers.
There are many customers - installing/maintaining an sqlserver service is not feasible in terms of work/problems
Can you clarify what you mean here. It sounds as if you expect to place a copy of a SQL database on the customers machine and access it via the VFP OLEDB drivers without an installed instance of SQLServer. You can't do that.
Regards,
Viv
>First, let me describe the scenario
>
>There's an accountant (bean counter).
>The accountant has customers.
>Each customer has several years for which books are kept
>
>In foxpro I had a root folder, containing a folder for each customer, each containing a folder per year
>
>
>Some customers do their own bookkeeping - to a certain extent - mail the 'year' to the accountant who may make some changes and mail it back. The customer's database is readonly whilst the accountant has the year's database - and vice versa
>
>So I'm thinking to do the same in .net with sqlserver
>
>Mail: I think I can backup/restore the database in sqlserver
>
>Sql server: The accountant would have an sql server whilst the customers would access the database with the native drivers.
>The sql server can be 'told' to do certain things - like attaching or detaching databases
>
>There are many customers - installing/maintaining an sqlserver service is not feasible in terms of work/problems. They have a 'light and simple' accountancy software - nothing very fancy. It runs without (too many) problems in foxpro and I would like to keep it that way.
>
>Server Access: I think I cannot work with Windows authentication and need sql server authentication. Each database will be created with a specific owner, ie the same for all databases. The system has to be simple and transparant for the users
>
>
>One of the thoughts was to put all the years of one customer into a single database. But that would not make things simple to exchange a part (year) between the accountant and the customers - would it ?
>
>
>Does this sound like the 'right' approach ?
>
>
>
>Thanks,
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