Aug 29th, 2000, 04:36 AM
Hi!
I'm developing a multi-user program where multiple users must be able to connect to a database and list/change records. What type would be the best to use? ADO? DAO? RDO? anything else? There will be lots of data in it (about 1 gig per year) but each year (or maybe even each month) a new database will be generated so the 2 gig barrier will never be crossed. I use the ACCESS2000 DLL's and so on, so Data Access 3.6(1).
There are a few rules:
- The load on the database in not real heavy (so there won't be thousands of updates per second)
- Multi-user: I think if it can handle about 3-5 users it's good enough, so I'll design it with about 50 users in mind... ("640k ought to be enough...")
- Because of it's multi-user nature I must be able to lock 1 or more records at the same time.
- I don't want to use any objects on my form for access to the database,
- I don't want to have to code huge amounts of code just to refesh a record or so,
- I've ordered crystal reports 8, and want to be able to generate reports from the database,
- I'd like not to have to use a "Data Environment" in the IDE (but if I have to .... ok)...
- I don't want to have to run a SQL-server or anything, my app will be "stand-alone". The Database file (mdb or so) will be on a shared drive on (mostly) an NT4/2000 Server
Any suggestions? Ideas? Remarks? Tips? Anything will be appreciated.
[Edited by RobIII on 08-29-2000 at 06:37 AM]
I'm developing a multi-user program where multiple users must be able to connect to a database and list/change records. What type would be the best to use? ADO? DAO? RDO? anything else? There will be lots of data in it (about 1 gig per year) but each year (or maybe even each month) a new database will be generated so the 2 gig barrier will never be crossed. I use the ACCESS2000 DLL's and so on, so Data Access 3.6(1).
There are a few rules:
- The load on the database in not real heavy (so there won't be thousands of updates per second)
- Multi-user: I think if it can handle about 3-5 users it's good enough, so I'll design it with about 50 users in mind... ("640k ought to be enough...")
- Because of it's multi-user nature I must be able to lock 1 or more records at the same time.
- I don't want to use any objects on my form for access to the database,
- I don't want to have to code huge amounts of code just to refesh a record or so,
- I've ordered crystal reports 8, and want to be able to generate reports from the database,
- I'd like not to have to use a "Data Environment" in the IDE (but if I have to .... ok)...
- I don't want to have to run a SQL-server or anything, my app will be "stand-alone". The Database file (mdb or so) will be on a shared drive on (mostly) an NT4/2000 Server
Any suggestions? Ideas? Remarks? Tips? Anything will be appreciated.
[Edited by RobIII on 08-29-2000 at 06:37 AM]