I've been taking metformin for years. I can tolerate 500mg x 2 daily, but beyond that and I have trouble.
Here's a thought:
Take 250mg x 2 daily. (Break the 500mg tablets in two.) One after breakfast, one after dinner.
See if that helps.
Good luck!