One question to ask is : Does Access Know that you changed the field from String to Autonumber?

One way to be sure is to drop the textbox from the form...

Couldn't you use that same script after each backup is taken and save the required restore script in a different location (central DB, network drive...).

I'd tell them to pass the requests to you so you can analyse the actual need for the index and run it for them.

The problem is that if they can...

Might be a crutch, but that also might work.

Can you put the install file on D:, then unzip the package on D:. If it's automatically put on C:, I'm...

Yes, I still don't see why it makes a difference as to when the id is displayed / created. The id is useless without the rest of the data...

I never worked with that... I'll let you explain that one :D.

NP, that was faster than the usual poster :D.

1 - Why does it matter in your case that the number be displayed before or after the record is inserted?

2 - Why not just use access working and built...

You just told your mechanic that you have a problem with your car, but you didn't bring the car, nor what the problem actually his.

Please post the code you tried...

SSC or SSN Steve?

You've been working here too long me thinks ;).

Just a final note, as always test, test, test. I chose to do it this way because it...

bpowers (9/12/2008)

---

The script worked great. However, I have run into another problem with this. The data that goes into this table is entered into an Access form. When a user...

Why do you need to do this exactly?

Do you need to find a given value in any columns in any tables?

Is that something that you have to do as a...

Awesome job Tom.

I however have a suggestion for all those articles with 15 different code snippets. Could you include a download link where we can get the whole thing...

Are you sure about that one? Like I tested it and in this case exists is faster than in?

That looks like an order system.

What I did in mine that really improved performance was to create the PK as an int, but I also kept the order id as...