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.
Thanks Rick,
It works just beautiful the way I wanted. Now I can apply the followings:
ALTER TABLE <table_name> DROP CONSTRAINT PrimaryKey
and this will drop the primary key created by MS Access.
Again, thanks a lot.
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.
Hello,
Yes, I can just run the code directly. However, performance is a big issue for me. I'm doing lots of table comparasions using about 30+ queries. It would be a lot easier if Access allow to create stored procedure. By storing all queries in a macro, it costs me only one call and...
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.