I've gotten different sortorders with

SELECT TOP 10 

 CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion

 ,S.fecha_creacion AS B

 ,ID

FROM dbo.test  S

ORDER BY B DESC

ID 1 on top

SELECT TOP 10 

 CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion

 ,S.fecha_creacion AS B

 ,ID

FROM dbo.test  S

ORDER BY fecha_creacion...

Aren't DSN's for ODBC-sources only?

You can use DSN-less connections however

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21009195.html

Interesting issue

SELECT TOP 10
S.id_solicitud, 
CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion, 
S.nombre, 
S.clave_material,
IsNull(CONVERT(NCHAR(10), S.fecha_ini_pruebas, 120), 'N/A') AS fecha_ini_pruebas,
IsNull(CONVERT(NCHAR(10), S.fecha_fin_pruebas, 120), 'N/A') AS fecha_fin_pruebas,
IsNull(CONVERT(NCHAR(10), S.fecha_emision_reporte, 120), 'N/A') AS fecha_emision_reporte
FROM
dbo.tblSolsInstrum_Solicitudes S
WHERE
id_usuario = 'car6527'
ORDER BY
fecha_creacion...

The log continues to grow if there are any lasting open transactions.

Perhaps the SET implicit transaction option was modified?

Have you contacted the vendor on what settings were modified?

like barsuk wrote

What are you current connection settings of

SET ARITHABORT ON|OFF (abort batch on error)

and SET ARITHIGNORE ON|OFF. (issue a warning but continue)

Welcome to the forum

Some guesses:

1) if you "link" the intercache table in Access, is there a primary key/unique index?

2) How fast does

SET NOCOUNT ON

SELECT A.ID, X.ID

FROM tblTable01AddOn...

In which Access version?

logging on to the network with the account sql server/sql server agent runs under and try to put a file on the share

have a look at

http://www.sql-server-performance.com/articles_audit.asp

1)when to add memory: monitor Buffer Cache Hit Ratio

In OLTP applications, this ratio should exceed 90%, and ideally be over 99%. If your buffer cache hit...

Is the sql server running on your pc?

What OS do you have?

In addition you can set a default value for the bit fields so that Access doesn't try to insert NULL in them.

Better late than never.

1)

If sql server is the only running application, why don't you give it 7GB to work with?

->SQL Cache Hit Ratio - 87-90% is quite low.

Have a look...

Not sure but are all commands done within the same connection?

Can't find it immediately but the application is responsible for committing/rollbacking the transaction in case of an error.

When the connection...

Backup how often:

Depends on requirement (how much of the data may be gone, how critical is the database)

Depends on the time limit to restore a database. If your timewindow is...

This looks like a MSAccess matter.

Can we see the DLL of your Table? (use sql enterprise manager or sql analyzer to generate a create table script)

Does the linked table layout...