NEED ADVICE on setting up a networked App. 1

[adamr1001]

Hey all,

I am developing a VB application that will connect via LAN to an MDB file, using the Jet Engine, etc etc. Simple text boxes are set up to display, alter and add records. I would like to have more than one workstation able to access the databae at the same time. Will this be a problem? I have a feeling it will be. The application and the MDB file (as of now) are set up to be on one main computer, and I'd like a couple of networked workstation to be able to run the application simultaneously. Any suggestion are more than welcommed. Thanks in advance. Adam.

 

[Hackster]

Years ago, before I got involved with useing MS SQL Server and Oracle as backends, I wrote dozens of applications that used an Access MDB sitting on a network where numerous people were adding and editing and deleting and doing all kinds of stuff on a daily basis. I never had any problems whatsoever. One word of advice that I would like to give, however, concerns the drive mappings. At first I figured I'd have to use a drive that I knew was mapped, at login time, for all of the people that would be using my
app(s). Well, I ran into all kinds of problems. Sometimes the mapping didn't happen at login time. Other times, the users "inadvertently" disconnected themselves "somehow" from the drive. Eventually, I programmtically mapped the drive myself at program execution time, and then disconnected it when the program ended. End of problem.

 

[adamr1001]

Regretfully, I am a novice and do not know much about networking and mapping drives. As of right now, I plan to have the app and the MDB file together in the same folder on the main computer. Users from networked workstations will simply execute the app from the network neighborhood ...etc... A friend of mine said that this system would suffice. Any thoughts or suggestions to a beginner?

Adam.

 

[Hackster]

Are you doing it this way so you don't have to distribute the application to the user's desktop?

 

[adamr1001]

kinda. it is a shortcut, but it may also prove to be useful in terms of its portability and independence as a program.