As far as updating data, I am equally comfortable using either ADO or DAO.  If ADO is more efficient, that is what should be used.  But when manipulating objects inside...

I decided that maybe I should check my idea of only allowing one record at a time to be attached to a form to make sure that it is really...

I agree, the Access Projects are the way to go.  

Back when I was doing developement in Access 2000, if I recall correctly, there was no way to import other types...

I have written several successful applications that did update SQL data using linked tables using Access queries, DAO or ADO code.  The last big project I worked on I actually translated all of...

While working on this article, I found that Access 2003 had references to DAO and ADO by default.  I haven't done a lot with Access for the last 2 years and...

Here is an example using Ping:

create procedure usp_ReturnNameFromIP @IP varchar(15),@Name varchar(100) output

as

set nocount on

create table #ping (line varchar(1000))

declare @answer varchar(1000)

declare @command varchar(1000)

declare @pointer int

set @command = 'ping -a...

I have the lock monitoring set up and so far no tempdb problems since it was set up.  The application itself has logging of all statements, so if I know...

If the query doesn't exist, you will get the 7874 error.  Try checking to see if the query exists before deleting it.  Here is an example of checking for the...

What do you mean by "in parallel"?

You can run MSDE and SQL 2K on the same machine at the same time.  At least one of them has to have an...

Since you are storing the average in a column, you can join on the grade lookup table:

select Student, score1, score2, score3, [Avg], grade_letter as Grade from scores join GradeTable_tbl on [Avg]...

Congratulations to SSC!!!!! 

Look in to "Information Schema Views"

Maybe something like

select count(*) visitors,  isnull(page1,0) + isnull(page2,0) + isnull(page3,0) + isnull(page4,0) + isnull(page5,0) + isnull(page6,0) + isnull(page7,0) + isnull(page8,0) + isnull(page9,0) + isnull(page10,0) pageCount

from pagehits group by  isnull(page1,0)...

Here is a script that migh also help you come up with a plan.  It assumes that the import table is called Excel and the derived table is called derived.

truncate...

Here is a script to get you started.  You will have to also write a script to set up the jobs.  Probably the best way to get a sample is...