Renaming columns is a drastic step: it affects all applications that use the data, and may require a lot of changes to a lot of code - or they will stop working because the old column names no longer exist. Unless this is a new project, and you need to change the names because you have redesigned its function, then I'd strongly suggest you don't do it.
You can use different names in your DGV just by requesting it under a different name:
Instead of
SELECT PN, desc, RP FROM Products
Use this:
SELECT PN AS [Part #], desc AS [Description], RP AS [Retail Price ($)] FROM Products
and the "human readable" names will be used as column headers in your DGV.
If you need to change column names in your DB, I'd suggest you do it in Access itself, rather than your app - it's a lot less prone to causing strange crashes! But ... you can do it with the
ALTER TABLE statement (Microsoft Access SQL) | Microsoft Docs[
^] - it's just very unusual to do it on a regular basis.
Submit an article or tip