database record document management

[John Smith]

I'm involved with creation of a database application that will need to
create & update documents (case notes and such) related to client records.
Scanning documents and relating them to records is also on the want list. An
application development platform hasn't been chosen yet but Office
w/VBA/Visual Studio are being looked at. I'm in a position to push a
different solution if I can make the case. Any pointers and/or tips
appreciated.

Thanks!

[Lysander]

Post by John Smith
I'm involved with creation of a database application that will need to
create & update documents (case notes and such) related to client records.
Scanning documents and relating them to records is also on the want list. An
application development platform hasn't been chosen yet but Office
w/VBA/Visual Studio are being looked at. I'm in a position to push a
different solution if I can make the case. Any pointers and/or tips
appreciated.

That can be done with any programming language capable of using OLE, and
also with any database format.

Using Firebird or another 'real' SQL server will of course make things a
lot of easier, because some things will take a lot of profit out of
using triggers for database integrity.

I have been doing and implementing this with Visual Studio/C# and using
Firebird as backend.