Thankx for the reply

1. My concern is not about the accessing. but getting same no for both users.

Say User A Read and get number 15 before updating it user B...

this is done from VB

http://www.winnetmag.com/SQLServer/Article/ArticleID/22973/22973.html

More information

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20781766.html

It is strange

What is the relation with the index

U can use query in access

This URL will help

HOWTO: Call SQL Server Stored Procedures from ASP

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q164/4/85.asp&NoWebContent=1

If U R using ADO, U can run stored procedure via ASP.

I wonder y u need to insert those to a table.

That is a great Idea amitjethva 

Yes Andy,

As professional we should not do like that.

Yes, U should give the chance to answer previous as u can learn lot like me

What about DTS. I think it is handlening it

Yes

I have done it in otherway round

i.e SQL -> ACCESS (From VB/ADO)

'Make the conaccess,conSql Connection strings

rstaccess.Open "EventService", conaccess, adOpenForwardOnly, adLockReadOnly

rstSQL.Open "EventService", conSql, adOpenDynamic, adLockOptimistic

Do While rstaccess.EOF = False

    rstSQL.AddNew

   ...

Little bit confused.

Are u developing one code which can use both access and sql?

I think Raymond needs the concat value rather than the sum

SELECT     CAST(a.ID AS varchar(1)) + CAST(b.ID AS varchar(1)) + CAST(c.ID AS varchar(1))...

Sorry De Leeuw David 

I was carried away with the first answer. sorry about that.

I think What...