try to install MDAC 2.7 and its SP in your Application language on any client machine (which has any O/S).

if it doesn't work, uninstall Connectivivty Tools from Sql Server 2000...

On your remote Server .. try to re-Install the "Client Tools" again .. so your EM may work

I hope this help u.

Alamir Mohamed

Alamir_mohamed@yahoo.com

ok .. I think the problem is that you have the MDB file only ( the LDB has a problem ) ...

if you still have the MDB you can get...

there is a SP3 for the BOL (Books on Line) .. try to download it and then install it ...

I hope this help you

Alamir Mohamed

Alamir_mohamed@yahoo.com

note if any fiels in any table is changed (even if you put only space in it), the whole record of the table containing this field is appeared in Union...

try to uninstall SQL Server from your machine ... then install Mdac 2.7 RTM refresh (if you want).. then install SQL Server again ..

note : the best way to remove...

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

I think you have to change your Collation DB to use Arabic .. so use ..

SQL_Latin1_General_Cp1256_CI_AS

and make fields nvarchar (unicode) ...

and you can use DTS to transer table to...

Read this:

try to put the DATA and the LOG file of SQL Database on a partition that is Formatted with 32 K or 64 K Cluster Size (not the...

I use norton Antivirus Corporate Edition, and i don't use to scan the MDF, NDF, LDF , TRN and BAK files, and not to scan important Folders.

and also not...

Good morning,

I suggest you to use Access XP upsizing wizard to move Tables , Relationships and DATA ... it is very powerful ..

note: Access 2000 upsizing wizard...

Solution :

----------

1- set collation of DB to SQL_Latin1_General_CP1265_CI_AS

2- set field type to NVARCHAR(50) (so it is unicode)

3- if you install SQL server 2000 on NT, you will see "?????" instead...

you say: The Phase 1 upgrade will be MS Access ADPs ..

so why you use ADP not MDB ... MDB is more powerful with SQL Server and support many...

you can also make a table in SQL Server named MyAuditTable .. and make trigers on every table you have to add a record in your MyAuditTable when any data...

for System_User in SQL Server .. there is a function called CurrentUser() in Access

for Host_Name in SQL Server .. I don't know the same function in Access .. can anybody...