I need to check for the existence of a field in an Access DB and automatically add it if it does not exist (without crashing with an error message). I've searched here (found nothing) and on Google (found about 500 or so different methods, none of which worked).
There are some methods that use ADOX, but I've noticed that it seems to work best with Access only. Most will transfer to MS SQL Server, but I digress.<
you could allways just do a SELECT COLUMN FROM TABLE and place it in a try catch block, if it errors then create the column, if it doesn't error then the column exists<
Topic Locked
Posted - 24 December 2008 : 21:20:16
