I split my database and then realized that my "make table" queries are writing only to the front end. I edited them to make the table to the BE instead, but then they aren't linked to the FE and my VBA can't use them.
Is it best practice to make the table to the back end and then relink them with VBA or to just change the single make table query into a 2 step process where I delete the table contents and then append the new data? Or is there another way to do this as cleanly as possible?
I'll have multiple FEs that share some tables, but these that I'm creating with the Make Table query aren't among them, so I could just leave these temp tables in the FE, I was just thinking that it was best to not have any tables in the FE.
Looking forward to your advice!
Is it best practice to make the table to the back end and then relink them with VBA or to just change the single make table query into a 2 step process where I delete the table contents and then append the new data? Or is there another way to do this as cleanly as possible?
I'll have multiple FEs that share some tables, but these that I'm creating with the Make Table query aren't among them, so I could just leave these temp tables in the FE, I was just thinking that it was best to not have any tables in the FE.
Looking forward to your advice!
