It must be version conflict.

If you create a mdb file in access 2000 and opens it up in Access 97 then  it creates problem.

hi mahesh,

i'll try today itself.

Otherwise i'll send u at ur emailid.

ok bye

nitin

hi mahesh,

u can use

sysobjects

sysindexes

sysreferences

system tables.

The primary key is ID.

I would have given u the query but I don't have enough time.

ok bye

nitin

Hi,

Create a seperate table

id_tbl

id_name varchar(20),

id_prefix char(5),

id_current_number int

Store your PK id in this table with the prefix string you want and enter by default starting number for the PK.

Then before insertion...

Hi,

Very first create a new login and then mapped this new login to the users you want to create.

Then bound these users with the roles like

for reader - db_datareader

for...

Hi Bill,

I think , u must describe ur database design first.

i.e. how are u storing ur month in database table.

Nitin

Hi,

Yes ,it does affect. Actually when u rebuild the clustered index then the optimized plans already developed by SQL Server won't work. It needs to generate new plans and thus...

Hi Lars,

Below is the corrected syntax.

declare @UnitWeight as Real,

@fVal as Real

set @UnitWeight = 1

set @fVal=0

SELECT @fVal=SUM(isnull(FVALUE,0))  from ITEM

SET @UnitWeight = @fVal

Pls check it out.

Nitin