NEED ADVICE on setting up a networked App.

[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.

 

[HebieBug]

Should not have a problem until you get to more then 5 workstations accessing the MDB file at one time. Have also been informed that the limit to MDB is 50MB.

 

[ErroR]

I've done basically what you described, only simpler using VBScript and I didnt have any trouble with several people adding records at the same time. I'm not sure why 5 people would be the max unless that is the limitation of Windows non-Server OS concurrent connections. But I don't know a whole lot about it.

The 50MB thing is true, (not sure of the exact number, but there is a limit) I had to export my records each morning or else it wouldnt keep additional records.

Your other option would be to setup a SQL database that could be accessed through DB2 or ODBC...

 

[harmmeijer]

You can use a disconnected, updateble recordset by giving the recordset a client site cursor, you can disconnect the command object and edit, add. browse the (local) recordset when you do an update it will be done in batch(optimistic or pessemistic). I am talking about ADO here.

I know some about it in theory but never tried it in practice (the asp worked allso fine for me).