Dean Murray
Mar 14th, 2000, 01:03 AM
Howdy folks,
I have designed a video management system for a video store.
I used DAO with Access because I had VB5 and no ADO. Here is the question. I have only be able to test it on a single machine. Are there any issues I should be aware of if we set up a second computer. The database will reside on one computer but will be accessed by both. I know about pessimistic and optimistic locking but I created the recordsets leaving the default. I also closed and set to nothing the recordsets and database connections after each procedure or beginTrans-commitTrans series. I read that RDO is the pre-ADO method of choice for network database access. Will DAO work fine here?
Thanks
I have designed a video management system for a video store.
I used DAO with Access because I had VB5 and no ADO. Here is the question. I have only be able to test it on a single machine. Are there any issues I should be aware of if we set up a second computer. The database will reside on one computer but will be accessed by both. I know about pessimistic and optimistic locking but I created the recordsets leaving the default. I also closed and set to nothing the recordsets and database connections after each procedure or beginTrans-commitTrans series. I read that RDO is the pre-ADO method of choice for network database access. Will DAO work fine here?
Thanks