I would be very grateful for any advice on this.
The business I work for want all their paper data stored in Access 2000, and to be accessible through a small network - server, 3/4 PCs running XP.
The main question is: Is there any reason not to use VB6 for this?
I'm pretty much a novice with VB6 but it's the best option for me. Unless absolutely necessary, I'd rather not have to familiarise myself with VB.NET at this time.
I've read of the version issues (having to convert to Access 97) but I downloaded service pack 6 and I have no problem accessing tables on a test Access 2000 database on my work pc. However, any advice on specifying the correct connection settings for the above setup would be gratefully received. From what I read, ADO is the best method but I could use some help on the finer points.
Thanks in advance to anyone who can help.