You might also want to check the correct syntax for an inner join!!! That'll save you a lot of troubles down the road.

I ran this on a clean install of 2005 (sorry, don't have 2000 installed anywhere)

EXEC dbo.sp_dbfixedrolepermission 'DB_ddladmin'

db_ddladminAll DDL but GRANT, REVOKE, DENY

db_ddladmindbcc cleantable

db_ddladmindbcc show_statistics

db_ddladmindbcc showcontig

db_ddladminREFERENCES permission on any table

db_ddladminsp_changeobjectowner

db_ddladminsp_fulltext_column

db_ddladminsp_fulltext_table

db_ddladminsp_recompile

db_ddladminsp_rename

db_ddladminsp_tableoption

db_ddladminTRUNCATE TABLE

That's still ovbious to split all those files.

What's the point of putting the backups on the same drive of the DB. When that drive is gone, everything is gone......

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