Hi,
I am currently creating a VB.NET app using ADO ( ADO.NET was to slow!!, if anyone has some help on this i would appreciate it ) and Dbase III databases. I cannot switch to anything else, it has to be dbase III databases. I have been accessing the databases locally for testing using Jet. my question is, how should i go about making my program available for multiple users. 10 users at the very most, but most likely only 2 or 3 will actually be using the files at a time. Each table is a seperate file and i have about 20 of them.
2nd, how do i make the dbs available to my users. Do i just create a server computer then create a simple file share for other users on the network to access? LIke through drive mapping?
3rd, im creating classes for each dbase III file that will hide all the junk of ADO and provide simple methods of reading and writing to the files specific to the application. Should i use a dynamic cursor or a static cursor? I am thinking a static as dynamic doesnt allow for bookmarks.
Also how do i for instance, if i have a tree control that is populated from the DB, and another use on a different computer say adds a record or deletes a record, the tree control is then not current, how do you guys handle updating the control so that when another user changes something, you can refresh it and be able to "see" the changes. Do you just refeth it on a certain interval or is there a trick or something that i just dont see?
I am newb to creating frontends for a database and this multiuser stuff is rather tricky. So any help is Mucho Appreciated!
I am currently creating a VB.NET app using ADO ( ADO.NET was to slow!!, if anyone has some help on this i would appreciate it ) and Dbase III databases. I cannot switch to anything else, it has to be dbase III databases. I have been accessing the databases locally for testing using Jet. my question is, how should i go about making my program available for multiple users. 10 users at the very most, but most likely only 2 or 3 will actually be using the files at a time. Each table is a seperate file and i have about 20 of them.
2nd, how do i make the dbs available to my users. Do i just create a server computer then create a simple file share for other users on the network to access? LIke through drive mapping?
3rd, im creating classes for each dbase III file that will hide all the junk of ADO and provide simple methods of reading and writing to the files specific to the application. Should i use a dynamic cursor or a static cursor? I am thinking a static as dynamic doesnt allow for bookmarks.
Also how do i for instance, if i have a tree control that is populated from the DB, and another use on a different computer say adds a record or deletes a record, the tree control is then not current, how do you guys handle updating the control so that when another user changes something, you can refresh it and be able to "see" the changes. Do you just refeth it on a certain interval or is there a trick or something that i just dont see?
I am newb to creating frontends for a database and this multiuser stuff is rather tricky. So any help is Mucho Appreciated!