I don't use those type of connections, but try this:

\\[NAB-WK-EN39197].nab.ds.usace.army.mil\access2003

SQL Server doesn't like dashes in names and that might be causing the problem.

-SQLBill

First, you don't have to update a whole new column...it's a COMPUTED column. That means it's a virtual column. When you add new rows, this column is 'automatically' updated.

Second, if...

Really Scott, this is way too simple.

Go to the computer that has SQL Server on it. Right click on the My Computer icon. Select Properties. Go to Computer Name tab....

Do your users have access (logins) on SQL Server?

-SQLBill

Then you are appending your backups. WITH NOINIT is the default and causes the backups to append. WITH INIT overwrites the previous backup.

-SQLBill

oooooooo....check to see that the SQLServerAgent service is set to be dependent on MSSQLServer service. If the agent service tries to start first, that will cause problems.

Or set MSSQLServer service...

What kind of backup is this? Is it a FULL backup?

-SQLBill

How was the backup done?

Did you backup to disk first and then copy the backup to tape? If so, you need to reverse the order, you won't be able to...

Now that you know your system is clean....set your antivirus to ignore the extensions .mdf, .ndf, and .ldf.  I have found that antivirus programs can cause errors with SQL Server...

Did you mean HAIKUs? (Japanese poetry).

-SQLBill

Backup and Restore doesn't work with SP levels.

You need to make sure the instance is the same level or higher than the original. You can restore a database from...

Do you have a strong password on the SA account? (Installing SP3a should have required this). I suggest running an updated antivirus on your system; since you had an unprotected (no...

1. Is SQL Server installed on the other server? I'm pretty sure this is obvious, but I've seen other people try to move a database to other places on a...

Martin,

It IS best practice to separate your log and data files. Log files get LOTS of writes. Even Microsoft suggests putting the log files on separate disks.

I believe the best...

As everyone else said....if you set the column for NOT NULL, then you must provide a datetime. If you don't provide a datetime, then the default is used. If you don't...