I have to work with PostCodes regularly. We have a problem where users input incomplete postcodes as well as incorrectly formatted postcodes.

I have created the following view which looks at...

I have been working on a very similar problem with Postcodes!

We have all sorts of problems with incomplete or incorrect postcodes but need to report on various postcode regions. the...

Does the Table have a Primary Key?

I have fallen for this myself. EM will let you modify data directly regardless of there being a primary key (as long as you...

Another option I have used several times (this is after being caught out by upsize wizard loosing data!)

Use Upsize wizard to export the desin only to SQL

Then use SQL Import...

I had to create a procedure recently to do the same thing. I needed to change all tables back to dbo. The ownership of the tables belong to the nt...

Thanks

I will give it a try

I can get the sp_start_job idea to work.

I would like to learn more about the vba options as this is obviously more powerfull as I need to move the...

Thanks. That appears to do the trick

Yes I have found this problem as well!

I have XP Pro running on my pc with sql 2k sp3a etc. I change my passwords via Ctrl & Alt & Del....

Thanks for the info, I will have a try and let you know how I get on

Thanks

Karl