Maybe you could try reproducing the problem by running in Query Analyser - this way, you will narrow down where the problem is going wrong - obviously the SQL itself...

Try the Table Analyser Wizard in Access - haven't used it, but looks like it targets your sort of situation.

Regards

As SQL Server 2005 (not 5000) is not yet out of beta testing, there will be very few businesses using it for production purposes, whereas there are thousands using SQL...

Creating the table structure isn't hard - it's easy to get yourself a CREATE script, if you already have the table locally.  Just browse to the table in the Query...

What are you trying to do exactly?  It is possible to trim the time bit from a date before storing it in SQL Server, if that is your requirement.

Regards

Define 'weird result'!

I assume CompanyID is unique in Company?

Is DepartmentID unique to the Company table?

Regards

Can you send the data in the format 'yyyy-mm-dd'?  This format should work regardless of American/English date worries.

Regards

If you are not going to use SQL Server in production, why use it during development?  Surely you're just storing up a big headache for yourself at go-live when you...

Can't you just keep multiple versions of the database within SQL Server and take Access out of the equation?  If you script all of the db changes you make, you...

The easiest way to do this is first to add the new columns to Sarah_2 - just use Enterprise Manager - making sure that the datatypes are the same as...

Not 100% sure I understand.  Do you want to create a brand new column in Sarah_2 to which will be copied the Sarah_1 data?

Is there a one-to-one relationship between the two tables?

Regards

Phil

Excellent stuff - like it.

OK, this isn't so bad.  If you execute a CREATE TABLE script after a DROP, it will do exactly that - delete the table and its data and then recreate the...

This sounds like an Access issue rather than a SQL Server issue - files do not "get locked for editing" in SQL Server.  In Access, open the database and check Tools/Options/Advanced, ensuring...

Hi Sarah

If you are just changing the structure of an existing database, you should be able to script the required changes without losing data (but this depends on the extent...