Yes, that was the forest I couldn't see!
Thanks.
I change the code accordingly, it works to add the table, but same error when accessing it afterwards.
So I closed the DAO object then reopened it after the create and it works fine.
Assume there is some form of 'refresh' that needs doing!
That is because text box has its own background plus surrounding borders (3d effect stuff). All of this is printed as a graphical image at low resolution. The label fld typically is just straight text and 'cleaner' to print graphically, especially on the white paper background.
I am using VB6 and need to create a new table in an existing Access 2003 database. The current application is using DAO 3.6 to perform all the other function without problems.
I did a search and found a piece of sample code to do what I need, but it uses ADO. Anyway, I implemented it and was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.