Search results

Agreed. Always import from source to a temp staging table then clean up and massage into target table(s) as needed. I would add a boolean (yes/no) field called, say, 'DeleteFlag' to the staging table and flag every row that matches your 'bad phrases' then delete or ignore based on that flag...

Understood thanks. Thought it was rather sad there was no solution given. Maybe it'll help someone as the character limit persists and can be a latent issue. Just came up on a app that I developed 20 years ago. Ha. Take care.

Depending how critical your database is and no matter how robust your network infra, I would't even recommend running Access even over ethernet. Beyond a couple users with intermitent concurrency is asking for trouble, in my experience. All multi-user Access apps having Access back-end that...

As noted combo box column text properties are limited to 255 characters. It's common practice to copy the value of a combobox or one of it's columns into another field because it often saves a db round trip. It's important to consider memo fields when doing so. I know this is an old post, but...

I see powerapps was recommended. It's Microsoft's most recent answer to the corporate perception that Access proliferation is problematic. I tend to disagree that it's problematic when all things are considered - Primarily the fact that the cost benefit to rapid development outweighs the...