TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
patrick
NA
397
0
One Program, 3-4 computers
Jul 29 2009 10:17 AM
I am writing a program for an environment and need some advice.
The program will be run on 3-4 computers, but each one needs to access the same data.
The issue is that the users are not skilled, so the program needs to set up everything.
I was using ADODB and jet as a database provider to set up a database in a windows shared folder and having the other computers access that file. I am running into a few errors with access rights though, and cant seem to serialize a class and store it in the database.
As a work-around, I was using a binary file to store the classes I needed serialized and storing everything else in the database. This isn't at all practical.
The program is nearly done, but i need to address these issues. It is well-organized code, so I am prepared to quickly swap data providers.
The other issue is that when I publish an update, if there are structural database changes, I have had to delete the database. Obviously this wont work once the user has the program. I can't tell them they are losing all their data because i forgot to make a field for a phone number...
There must be a more efficient way to do this, But these are computers are not always connected to the internet, only a LAN. So I need to manage the database through the initial install and updates.
Reply
Answers (
3
)
Block acitveX Control
lotto application in vb.net 2005