I think I got my answer.:-)

Just change the clustered index to:

CREATE CLUSTERED INDEX IX_YourTable_ColA

ON #YourTable (ColA,ColB)

22441

22462

22483

22554

24191

24282

25461

26241

This code is great.

Now let's assume we want ColC to be sequenced in ColA ascending, ColB ascending order.

How would your code be modified to accomplish that?

2244NULL

2246NULL

2248NULL

2255NULL

2419NULL

2428NULL

2546NULL

2624NULL

It depends!

How many users will be using the FE?

How many records will be in the BE?

Your network speed?

Etc.

I make lots of FE applications(over 200 in last 18 months).

I have found...

Like Lynn's code I do.

I am using SQL Server 2000 and solved the problem without the "over" statement and Join.

If I had more time, I may be able come...

It appears to me that Lynn's code assumes the data is entered in time_stamp order and the ID for the previous Time_Stamp is one less than the current record.

Where as...

May not be the most elegant way to solve, but it works.

CREATE TABLE #MyMeter(

ID int identity(1,1) PRIMARY KEY,

Value ...

Not a problem.

Here is a great list to subscribe to for "Access".

After you get a login you have access to years of questions and answers to common and unique problems.

I...

Try this link: http://www.teacherclick.com/access2003/t_10_2.htm

How to create an Update Query in Access 2003

Which version of Access are you running?

If you are running the script one time or on occasions you would create a query to perform the operation.

Try this,

Update [YourTableNameHere] Set M1C = M1Q * 10 where M1 = 'Glue'

One thought.

If the OP is using SQL Server Express there is a Maximum 4GB database size limitation.

Will this pose a problem in the future if the DB is going to...

Maybe you already found your answer but, I tried a Google for "Cannot connect to WMI provider" and found a possible solution at:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/468b8484-2729-4a06-bfc3-efe54507dcb6

Sorry, we need a little more information.

1) Is this an access .mdb file?

2) Is this an access .mdb front end linked to an access .mdb data back end?

3) Is this...

Try to check for your duplicate prior to adding the record.

In the BeforeUpdate event in the text box of your possible duplicate field try something like this:

Private Sub txtYourFieldName_BeforeUpdate(Cancel As...