Hey guys. I have written a program to create, edit and delete record in MS Access using a visual studio program. I am keeping the program and database divided into a front end and a back end to allow concurrent users. I am going to place the back end on a server and place the front end on several desktop computers. What would be the best way to go about doing this? I have packaged the database but I am not really sure how to go about packing the program. Is there a way I can package the program so when I place it on a desktop I can simply link it to the database? Thanks in advance!
jtodd
0
Junior Poster in Training
kingsonprisonic
42
Posting Whiz in Training
Use MS SQL SERVER for back-end. And use SqlClient for connecting the server database through your program.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.