I have these function also which get date only

http://www.sqlservercentral.com/scripts/contributions/733.asp

Date without Time (2 functions)

Some time you need to know only Date without Time.

This is simple function that allows you truncate...

I have these function which may also help u

http://www.sqlservercentral.com/scripts/contributions/733.asp

Date without Time (2 functions)

Some time you need to know only Date without Time.

This is simple function that allows you truncate...

I think _1 is added because there is another table found with tha same name !!

take care that you might face some problem if you make SQL Server and SQL Server Agebt work on Local account  ...

it is recommended to set it to a Domain...

by the way remove the ldf file of its place and the SQL Server will make a new one for you.

or you can copy both Ldf and MDF and attach...

is there any space on your harddisk?

what about restarting the Server?

in your button click write this

Dim cnn As ADODB.Connection

On Error GoTo Err_Command44_Click

'put your code of calling server here

Exit Sub

Err_Command44_Click:    'Access Errors

   DoCmd.SetWarnings True

    'MsgBox Error$

    MsgBox " Error: " & Err.number...

what about increasing your RAM amount? SQL Server is monister in dealing with RAM .. and when you increase your Memory then the performance of SQL Server is increased

also do u have...

please check that:

1-  you have a Space on your Hard Drive

2- the log file of DB is not huge in size

3- do u have SP3a installed ? it solve many...

by the way , SQL Server 2000 was a great jump than SQL Server 7 ... ecpecially if you use Relationships which was not found in ver 7. and a...

by the way .. why yo save the image in DB ?.. 

it is best to save image to files on a certain folder(with ImageRecordPK.JPG as an example) and show it...

Currently I getting the number in the End of adding Customer (by making transaction and get Max+1 )

are there any other solution ?

which version of Access you use ? I recommend you to use Access XP (2002) to upsize your DB to SQL Server .. it solved many problems shown with Access...

Note also that any Windows operating System , there is Virtual memory put on Harddisk that is the file PAGEFILE.SYS (i think its size is added to your real Memory )

yes, the different departments are entering customers at the same time ..

and i want them to see Customer Number without no change in the future ..