Search results

  1. N

    How to A sign the Default value on columns

    Hi All, How to A sign the Default value on Columns. i am trying..... ALTER TABLE ABC ADD A_COLUMN VARCHAR(10) NOT NULL WITH DEFAULT. Thanks & Regards
  2. N

    How To Convert Ascii To Decimal

    Hi all, I want to convert the ASCII to Decimal, for Example ASCII --------- DECIMAL ----------------------- A 65 B 66 Like that any one help pls Thanks & Regards
  3. N

    Update Statistics In Database

    Hai all, i am creating one database( .MDB file ). i am creating Indexes also. i create Link Tables also. but database is very Slow. how to UPDATE STATISTICS IN DATABASE, and HOW TO CREATE REINDEXES. i want to Speed up the Database. pls help ASAP Thanks and Regards
  4. N

    Converting .MDB to .MDE

    Hai All, i am new in Access. i am creating the .MDB Format. but that database is very Slow. thats why i am converting to .MDE Format. How to Conver and how to Connect the Data Source( ODBC ). pls Help ASAP Thanks & Regards
  5. N

    make fast (query)

    Hi all, I converted one database from sqlbase to access. It is so fast in sqlbase. But so slow in access. Taking time to run the query. I need to make it fast. Any help please. :confused:
  6. N

    need UPDATE STATISTICS ON DATABASE

    Hai all, i am using the Access2003 version. my problem is i am inserting 500 Record in one Table that time increasing the DATABASE size thats good. but i am deleting the 500 Rows in same table but database is not deceasing the size. why its not deceasing the size, again i am inserting the 500...
  7. N

    How much of Maximum Capacity of Access Database

    Hai all, Let me know the maximum capacity of access database..how many tables can include in the database..is their any limitations? Example: 2GB, 3GB Like Thir any Limitaions of the Capacity of Database Any one Help Thanks & Regards Narasareddy
  8. N

    unique column in Table

    Hai all, i am creating one table like CREATE TABLE XX( CODE NUMBER, NAME VARCHAR(10). I AM INSERTING THE 5 RECORDS LIKE OUTPUT IS -------------- CODE NAME 1 A 2 B 3 C 4 D 2 A problem is...
  9. N

    timestamp datatype

    Hai all, i am creating one table that table i am using the unique field of time stamp( Primary key). but problem is timestamp taking the date, time(hh:mm:ss) only. its not taking the miliseconds thats why its duplication of date, time
  10. N

    Autonumber

    Hai all, My name is Narasareddy. i am using the MS ACCESS. i am creating one table in design mode that time its allow the autonumber. problem is i am create the table in rum time that time its not allow the autonumber. any body help pls Thanks & Regards Narasareddy
Back
Top Bottom