what if you make linked tables Hidden ??

and in "Tools" menu, select "Options" then in "Show" tab, UNselect "Hidden objects"

so any user will not see the tables

what is the problem...

I want you to see this solution, may be it help you.

here is the solution of the Hang Problem (ODBC Timeout) between any program and SQL server 2000 or 7...

of course I mean .. that you have to install MDAC 2.7 or higher on all client machines.

and install MDAC 2.7 or higher on your SQL server 2000 or just...

i think you may need to install MDAC 2.7 or higher.

but you must check correctly your Access application on SQL Server before putting user on it .. so you...

i am sorry but i don't hnderstand the order of the steps ...

so can anyone give the steps i must take (1,2,3, ... ) to restore the DB to a...

note : when use [ Select max() from table1 ] make it .. [ Select max() from table1 with (Nolock) ] .. to not take any lock.

it is very...

I want to know where the script that take the Db and copy it to another partition ??

and is it possible to copy DB get out of Database maintainace planner...

i think you make a scedule to this Stored Procedure to run every 30 minutes daily...

you must know how to make a job ..

Alamir Mohamed

Alamir_mohamed@yahoo.com

is the cash is the same size??

is the RAM is the same type (DDRAm, RDRam or SDRam) ?? DDRam is more faster.

did you check the Partition you put data on...

do u make restart for the whole copmuter and server !! may be this solve the problem.

any way .. I think i have face this problem before .. and when...

I have some comments

1- the triger will not affesct the performane (as I know) ... and you can use Stored procedure in stead of it (in case you call stroed...

what is your frontEnd Application ?

you can Execute stored procedure "with (NOLOCK)" in stead of long runing queries ..

check again All reports and make all reports that gets huge data...

for BIT value :

True = 1 (in SQL Server)

True = -1 (in Access db)

false = 0 for the two system

( so when you link, Access Automatically [internally] convert 1...

Good Morning All

I have read all what you All said about migrate Access 2000 DB to SQL Server 2000 DB.

I already migrate Access 2000 DB to SQL Server 2000 DB...

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

When you want a report (a set of read-only data) which based on...