Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. swstran

    GetDatabaseName method returns only 64 characters

    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.
  2. swstran

    Primary Key Constraint Name

    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.
  3. swstran

    Primary Key Constraint Name

    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...
  4. swstran

    Yes/No field in Access

    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.
  5. swstran

    Invoke/Modify Access Macros Programmatically

    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...
  6. swstran

    Invoke/Modify Access Macros Programmatically

    Hello, Is it possible to invoke/modify an Access Macro programmatically? Please help! Thanks.

Part and Inventory Search

Back
Top