don't check "auto close" >>so make this check clear .. because it closes the DB

also don't check "auto shrink" >>so make this check clear

where these 2 check lead you...

Delete this maintenance plan .. and then make backuping up the log in a new maintenance plan .. and see if the error is still exist or not ..

also try...

Here the Solution of Hang:

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...

Please Also Take care of these Notes:

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

the problem is the these tables are Locked .. so make the query run with no lock

this is done by follow: with each table name in the query, add this...

there is no importance to use @@ERROR in Select statement

it is good to use @@ERROR in any updata , insert and delete statements

here is a good way to do this...

on SQL server Enterprise Manager (EM):

1- go to security folder .. and expand it

2- go to logins

3- in the right area, you wil find "sa", so double click on it

4-...

they may be other one who query from this table (so it locks it) and you are waiting for him to release the lock

my advise to you is to see...

here is the solution of the Hang Problem between any Program and SQL server 2000 or 7 🙂

When you want a report which based on complicated queries joined from several...

Note: its recommended to :

1- Install the Connectivity Tools (not the client tool) from the SQL Server CD on Client PCs

2- Install MDAC 2.7 and its SP (on client machines...

I want you to read this very carefully

here is the solution of the Hang Problem between Access and SQL server 2000 or 7 🙂

When you want a report which based...

these are some helpful notes for you

1- use upsizing wizard from XP (access 2002) .. because It transfer data and relationships more accurate

2- relink tables by using ODBC .. by...

If you use Import/Export Wizard ... the tables go with its data to the destination ... but with NO Primarykey or relationship ...

am I right? please check this again...

I think you have to make this table again by

1- make a new table with the same design in a new DB

2- copy data from orginal table to that table

3-...

before doing anything backup your MDB and LDF and any log files ...

are u doing any other kind of Backup with the Full Backup ??

Alamir Mohamed

Alamir_mohamed@yahoo.com