Hello Wayne,

Thanks for your BOL clarification. As you told, this explains what is happening in the background.

Now I need further investigation, because strange enough, in one side this table is...

Hello Gianluca,

I am using a Visual Basic ADODB recordset.

rsP.Open is where the record is searched for editing.

If the record is not found, a message apears. If the record...

Hello Ramesh,

Thanks for your help, this is exactly what I needed.

Thanks again.

Hello lmu92,

Thanks for your interest, please note that the SELECT command of my other post is exactly what I want to use.

Of course in the SELECT part, and in...

It is the server and lan administrator user.

That is, I use in the PC the administrator user and password that I also type when I log on to the...

Still unsolved. Here are my latest investigations:

1. If I log on the server machine as the server/lan administrator, and execute the backup program, it works.

2. If I log on a...

The user used to log to the SQL Server in the ADO Connection in the VB 6.0 program is the SQL Server administrator.

SQL Server autenthication is used in the security...

The service account of SQL Server on the Windows Server 2000 has administrative rights, and to the directory backup as well.

If I execute the VB 6.0 program in the server,...