Experts, I need your input on weather it is wise to use Access as a database from Excel to Access. I have written some code using a DAO connection which I have found is quicker to upload data from Excel to Access and vise versa, the code is working great so far. Here is my setup at work;
Network Drive Hosts Access Database, 15 users will be extracting the data from Access using Excel, those same users will then upload new data using Excel back to Access. Does this trigger any performance issues since there will be multiple people writing to the Access file? I cannot use a MySQL database since i am limited on resources at work.
Bookmarks