write down the Columns names in insert into.

you should do something like this (for example take from Order and put into Invoice table) :

INSERT INTO Invoice ( Order_no, Inv_NO, DEPT, CUST_ID)

SELECT ...

if you don't have any bakcup .. you can't get data back...except you get an log explorer program to see your log .. and this is the last chance for you. (note...

if I am making an application what is the best to use OLE DB or ODBC (to connect to access or SQL Server)?

which one is used with DSN ? .....

I also think that where statement is transfered into Join (implicitly) ... and there is a very very small wasting time.

the important thing is to make Index on the 2...

the difference as I know is:

1-OLE Db is a standard .. ODBC is vendor specific (Microsoft access must have an odbc made by microsoft)

2- OLE DB is more faster than ODBC ...

of...

yes Join is made more faster ... because it join 2 tables more faster (Pk and Fk)

what cpruden  means that

1- you can make the a new db in another server with the  same name (and this DB is empty .. even with...

I wondered of something:

the file extension is .dat not .BAK (bakup) .. so .dat may be the Dat file of the DB.

So try to attach your Db .. by right...

you can make this also from Enterprise Manager..

1- make a new database ..(and name it the same as the old crashed one)

2- right click on this DB and choose "All...

also if you make snapshot .. there is LOCK !! ..

try to make any regular query .. and adjsut it to snapshot .. and on SQL Query analayzar run...

Please read this carefully:

When you want a report which based on complicated queries joined from several tables, These tables are updated frequently, then you lock these tables (or you will...

take care to refesh the tables in Access after you make modification on SQL SERVER.

also take care of filling all field in access that is required

Please read this carefully:

When you want a report which based on complicated queries joined from several tables, These tables are

updated frequently, then you lock these tables (or you will...

I see here in SQLServerCentral.com a script that make a triggers on all tables you have in your DAtabase .. and of course  make an Audit table for you. search...

press the SHIFT + enter .. when entering Database .. and you will see all things (I think you are using MS Access)