I used ODBC to connect to Access database. The application is written in VC++. Unfortunately, CDatabase::GetDatabaseName() method returns a maximum of 64 characters, although the return type is a CString. Is there any way to get around this problem.
Please help! Thanks.
Is it possible to drop primary key of an Access table using SQL? What I really meant was that the ALTER TABLE DROP CONSTRAINT statement can be used to drop a primary key, but it requires the constraint name. Since our primary key was created within Access, we don't know what is the constraint...
Is there a way to create Access table with Yes/No, or Boolean, as data type, programmatically, so that when user opens it using Access, the field appears as checkbox? I'm using DAO 3.60.
Thanks.
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.