Note

you must make a Full backup daily (at least) and a transaction Log Backup at 1 hour (at maximum) so the data and the Log file will not increase...

Note

you must make a Full backup daily (at least) and a transaction Log Backup at 1 hour (at maximum) so the data and the Log file will not...

I know that

1- Loop is the worest (no Index key on any side of relationships)

2- Merge is the best (Index is found on the 2 sides of the relationships)

3-...

I think there will be no problems, if you transer the Domain Users and Groups successfully

Make The ISOLATION LEVEL Read committed (SQL Server default level).

and make (No Lock) in Select

and don't supply any Lock hint in Update, insert and Delete (SQL Server will...

are you sure thera are not any jobs that Called this

sp_table_statistics_rowset function?

do u know how to use Form Wizard to make Access Make the form for u (Basec on table)?

also you would find something similar to that wizard in ASP.net...

here is the link of MSDE with SP3a included

http://www.microsoft.com/downloads/details.aspx?familyid=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

by the way you have to searh in http://www.microsoft.com for how to use it.

I hope this help u

if you have 5 customers or less using your program, you can use MDSE.

MSDE is for free.

MSDE is the Simplest VERSION...

This is a major problem in access (Corruption) .. which happens when Data get corrpted (inserted wrong)

So you have to compact and repair every week to rearrange the tables...

I don't know realy ..

but I think MDAC 2.7 and its SP1 and its SP1 refresh is the best

I think Mdac 2.8 support ADO ver 2 !!

did you install MDAC 2.7 AND its SP1 on the client machines.. it may work

of course use MDB (not ADP) because there are many features in MDB that is not found in ADP, and many functions in MDB you have to convert it to...

I think you have to made mirror (software or hardware) on SQLSERVER partions instead of clustering .. it is very cheap.

SQL Server is monster in dealing with Memory .. it is recommeded not to use any other programs with SQL Server.

or you must assign a Fixed Memmory

I hope...