Have you tried using DTS?  That should do it.

If you are using QA, check out the value of Tools/Options/Results/Maximum characters per column.

I am not familiar enough with Access projects to give you a definitive answer here.

Is the selection method something which you have control of?  Or is it an off-the-shelf Access...

Even though they are sharing the program, they are not sharing processes.  Is the selection you are talking about performed at run time, or is it driven by data which...

Are you concerned that multiple user access will cause locking problems?

When you talk of a user's records showing up on other users' reports, what do you mean?  Do users own certain...

Check out INSERT INTO and SELECT INTO in BOL - they will both insert records into a table.

Don't know, but your query could be rewritten using joins:

delete ta

from TaxAddress ta join Parcel pa on ta.parcelid = pa.parcelid

join CvtMadParcel cmp on pa.userdefinedid = cmp.parcel_no

where pa.taxyear = 2004

Might be...

Thanks Sushila.  I think that my main difficulty here is that I need the ranking (1-5 date desc) built in to the query and I cannot see how to do...

Or restore a copy of the db from a month ago and use a third-party differencing program to compare this db with the current version and highlight schema differences.

From EM, click on Management and right click SQL Server Agent.  Select Properties - you can view and modify the info here.

Is this link relevant?  Sounds like similar problems ...

http://www.dbforums.com/showthread.php?threadid=986743&perpage=15&pagenumber=1

You've done it right.  I do this often - the backup should be fine (it's also worth zipping the backup before you send it - you'll see the file size...

Have you tried rebooting?  (The affected server, that is.)

This is a manual job I think.  Suggest you retire the Access db as soon as possible!

My colleague's insurance company increased his rate because he had had an accident in the previous year.  The fact that the accident was not his fault (another car ran into...