Read/Write VBA Form to .dbf
Jamie Collins wrote:
Rob Bruce wrote:
Use Access. You only need a single licence for the person who will
create and administer the database. All of the other seats can
connect into the Access db via Excel, ADO and VBA.
Get the admin guy to create and administer the database using ADO.
That way you don't need a single MS Access licence!
<pedant intensity="Extreme"You can't create Access databases with ADO. You
have to use ADOX</pedant
Seriously, administering a database is a lot easier with a dedicated
database administation tool. Sure, you could probably build one in
Excel/VBA, but I'm damn sure it would cost a lot more than buying a single
Access seat.
Rob
|