Hello,
I currently have a database that consists of only tables (mydb.accdb). These tables hold data that is read from using VBA with DAO in Excel. I did not split this database since I thought the only purpose of doing that is for when you have forms/queries/reports for which other users need to use simultaneously.
Is there any purpose/benefit to splitting a database that only has tables to begin with?
Thank you