I want to create a system with 1 database and many users that can access it
a solution is the server client model
ok lets say we have a database in a remote server(vfp database)
i go to each client and make a datasource and a connection to that database
1)the tables of that database will ONLY be viewed by clients through remote views
2)if yes ,i will put the views in the data enviroment
3)if yes,i can insert,delete,update,buffer...etc the views like they were tables
4)must i make a server programm with fox if yes what must kind of functions must i put there
5)does sql pass through has anything to do with all this
6)i think i must make a database to every client and then inside that database choose connections and make a connection to the server database,right
7)if yes then whats the point of the local database for temporary local tables for example
8)and most important:)is there a sample anywhere
remote data
Amit Bhagwat
1) No if you don't force it via some ways (like IIS, OS permissions, DBC events etc)
2) How you prefer
3) Yes (considering you only update one base table from an RV)
4) Depends
5) Yes
6) No
7) A local database is a container
8) Start with checking solution.app
You asked too many questions in one. Each really might take paragraphs to answer. Maybe what you are looking for is using SSE/MSDE or SQl server as backend with VFP.
John Sewell
1)in my application there is no need for security .can i make a database to a shared folder in a server and then let all client applications(made with vfp) connect to it
2)i guess i can execute sqo statements normally and the only problem would be not to exclusively open a table that many users use right
3)no server program would be actually needed right
the database must be made with vfp ,no sql server
Vibhu Bansal
Having data on a shared folder and:
set exclusive off
is almost all you need. This basically creates a multiuser application (it's not client/server - I think you don't bother if it's or not).
For example create a form or application with wizard. Created application or form is ready for multiuser. Basically this works and later you can have more control over locking yourself.
Free stuff from MS:) Yes MSDE was for free and now SSE. Actually there is much more free things from MS now. For example Express series (C#.Net express, VB.Net express, ...) are free for the first year then $49 if you want to keep developing with. Nothing surprising IMHO. If developers can afford it and develop MS based solutions then more and more MS product sales it actually means from my point of view:)
LPXO
but how come microsoft gives something for free its kinda strange,is it full of bugs or something
Free SoftWare From Microsoft:One Small Step For Man,One big Step For Microsoft
Bruce Taimana
LeandroTubia
I prefer my name to be spelled as Cetin or originally as it is written Cetin.
I don't think somwehere I said "shared folder is safest environment for a public database", did I Sorry I don't understand what you mean by partitioning (disk partition, SQL server partitioned views/tables ).
Joie Cariaga
SQL Server Express, a new (free) product that puts a local SQL Server light database in your PC. It replaced the older (but still functioning) MSDE (Microsoft Data Engine).
http://www.microsoft.com/sql/editions/express/default.mspx
Fred Reimer
thank you
withersd
It's a question I turn over in my mind too Billars, although my assumption is that it's a short-cut to sideswipe SUN and all the other whinning ninnys who're complaining Microsoft are too secret with their technologies. Beware of Greeks bearing gifts is a sound tenet.
I will agree with Centin though, DB creation is such an intricate and confusing arena these days, gaining such experience Microsoft and MSDN are offering, for free, is a potentially life-changing opportunity. Agreed the small-medium scale market will grow with MS at the root, thereby giving MS more room for manoeuvre to supply that market, but the potential is to oversupply the db and applications sector in the near future, without breaking the wrapper of Windows; tyrannical meritocricy. I personally like the concept of MSDN, because people give their time to help others; altruistic communism.
Are you sure the shared folder is the safest environment for a public database Centin I thought partitioning would be a better alternative