Forum Discussion
Brian_Hayes
Feb 25, 2020Brass Contributor
Moving Away from MS Access
The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to. Is there ...
DeanBabic
Jul 03, 2023Brass Contributor
Hi all,
to make this move easier for everyone, a lot of SQL from MS Access is a problem for non-skilled would-be devs out there - like myself.
So, have you ever considered using ChatGPT for moving ie Reports SQL from Access?
Here is a large Reports SQL converted by ChatGPT, if asked nicely 🙂
Used ChatGPT on many occasions, sometimes it's wrong, sometimes is 100% correct.
bmercer
Jul 05, 2023Iron Contributor
ChatGPT has its uses as a tool for getting you started, but relying on it to produce accurate results is dangerous. It frequently returns queries which mix syntax from multiple versions or even multiple platforms.
If you are not able to read the output code and verify that it looks reasonable, don't put it in production.
If you are not able to read the output code and verify that it looks reasonable, don't put it in production.