I wrote a small database using VB program for a friend who uses NT sever. The problem when he go to run the program it lock up thr Sever.
Printable View
I wrote a small database using VB program for a friend who uses NT sever. The problem when he go to run the program it lock up thr Sever.
No where near enough Information.
VB apps generally have no problem on NT so the following info would be nice.
NT Version
VB Version
What db (SQL Server ODBS?) MS Access? etc
local db? network db?
RDO, ADO, DAO ???
when does it lock up? on app load or when a button is pressed? what is the code in the event before failure?
Well.. Scott...
I think you should specify more...
Whether the database or the server which is locked by the application.
Coz, till now, I never face the problem like yours.
I'm using VB 6.0 SP2, Windows NT Workstation SP6 with Windows NT Option Pack 4.0
I've experienced using Access 97/2000 with DAO 3.5 and currently, I'm using SQL Server 7.0 with ADO 2.5
And, I never experienced the problem like you Scott..
Perhaps, you should check the open recordset type (whether you use adOpenDynamic / adOpenKeySet / adOpenForwardOnly /..) and the locking recordset type (whether you use adLockOptimistic / adLockReadOnly /...) or something like that.
Coz, I think, VB will never ever lock your server without any permissions from you. Yeah, the permissions will come from your coding of course...
Cheers,
Wen Lie
I talk my friend he said that when he installed it it ran fine but then when he shutdown the machine and restarted it the program wouldn't work. The error message was this was program was created in Win98 and will not work in NT
He using NT 2000 sever