Hello: I'm working on a large database project that I currently have in VBA/Access 2007 and intend to put into VB.Net/Access 2007 as I think it might be a better idea but I'm not sure. This program is for a large law case where I will be required to deploy it by sending it out on disks to various other firms across the country. I'm a bit rusty with this so I want to know the best way to handle the solution. If all these other firms don't have Access, what other type of database should I use? What is the best practice for deployment?
Your users do not need to have Access installed; you'll need the JET/MDAC libraries, that's what VB needs to read/write Access-databases. If you need some of the functionality from Access, you could distribute the Access Runtime[^].
I'd recommend against using Access, unless it's a single-user database. Sql Server (Express) would be a more reliable way.