Recent content by narasareddy

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

Thanks its working

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

update statistics Hai, Thanks for Reply. i created indexes but no Speedup. HOW TO UPDATE STATISTICS IN DATABASE OR TABLES. AND HOW TO RE CREATE THE INDEXES. one thing i am SELECTING ONE STATEMENT. LIKE SELECT EMP_CODE FROM EMP; INDEX IS CREATE INDEX XEMP ON EMP(EMP_CODE); i am running...

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

how to create the linked tables Hai all, how to create the linked table and whats the purpose of linked tabled. i want to speed up the database( .MDB ). any help thanks & Regards

thanks for reply how to use Link Tables and whats the purpose of Link tables

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

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:

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

Maximum Capacity of the Database Thanks for Reply, My Version is MS 2003. so can u tell me the Maximum Capacity of the Database. Thanks & Regards Narasareddy

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

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

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

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