Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johndweidauer

    Drop Trigger, hangs

    trying to drop a trigger on a table, but it just hangs, for hours...where do I begin looking as the cause of this issue? entire database is less than 1gb, table is maybe 300mb (varies), I am not sure where to begin?
  2. johndweidauer

    Drop Trigger, hangs

    trying to drop a trigger, but it just hangs, for hours...where do I begin looking as the cause of this issue? entire database is less than a gig, table is maybe 300mb, I am not sure where to begin
  3. johndweidauer

    sp_addextendedproc

    I was hit with some spyware/malware/trojans. one of these executed procedures on sql server 2000 sp4 that drop xp_cmdshell. i cleaned the servers, or so i thought, and also created a little job that would run every 5 mins to verify that xp_cmdshell still exists, recreate if not using...
  4. johndweidauer

    Win2k Svr AD Client Desktop

    I currently use the GPO on a Windows 2000 domain and I have configured the Client's Active Desktop settings to use a single wallpaper (.bmp file) located on another server for all client machines to use as their wallpaper. The downside is that the users that run XP get an Icon with a solid...
  5. johndweidauer

    SQL Server 2000 SP3

    We run MAS 500, a table now times out whenever it is called upon. This is the only table in the entire database that does this. When I open the table to view it, I recieve an ODBC time-out error. We have been using the database for over a few years now without this problem. Any ideas? Thanks
  6. johndweidauer

    Demoting AD on Windows 2000

    I have a Windows 2000 Server that I had created a "test" domain on just so I could play around. I have now Demoted the server and Un-Installed AD from the server. However, it seems that some of the components are still running and fill up the event log with AD errors. I have listed a couple...
  7. johndweidauer

    UNC C$ and Share Name

    Windows 2000 servers running Active Directory, PDC is DNS ******************************************* If i try to browse "\\servername\sharename" it will actually connect to that share, however, i try "\\servername\c$" and it gives me an error "The network name cannot be found". I can browse...
  8. johndweidauer

    Setting up RAID 1

    I am using Intel's Server Board SE7501WV2 with 2 73.4 gig scsi drives. i ran through the Intel Server Board Resource CD as instructed and installed the Service Partition. However, when windows set up starts, i provide it with the windows 2000 drivers, it tells me there are no drives to install...
  9. johndweidauer

    Run Access without Access Window?

    Dumb question, but is there a way to run my access database without seeing the actual Access Window? Probably not, but just a thought that i had. Thanks
  10. johndweidauer

    Resize Form (Inches to Twips, Twips to Pixels, You new size)

    Ok, for those of you that want to resize your form's height and width during Run-Time, here is your solution. First, create a Class Module and name it "clFormWindow" then paste sampe code "A" into it. Second, create a Module and name it "modConvert" then paste...
  11. johndweidauer

    Import Access 2000 to Pervasive V8

    Is there a good component, or anything for that matter, that gives me the ability to suck in tables/queries from an Access 2000 DB into my PervasiveV8 DB? Thanks
  12. johndweidauer

    Resizing/Positioning Form During Run-Time

    form sample: Dim meForm As New clFormWindow With meForm .hWnd = Me.hWnd .Width = 507 '// in pixles .Height = 340 '// in pixles .Left = 100 .Top = 100 End With Paste this code into the newly created class module and name it "clFormWindow" Option Compare...
  13. johndweidauer

    Re-Center Form

    Say I want to re-center a form, how can this be done? I have a class module that allows me to set the forms height and left position, but i am not sure how to get the access window size, nor the viewing area inside of access. thanks.
  14. johndweidauer

    ADO Access 2000

    Howdy, Its been a while, but i am trying to retrieve the number of fields contained in my recordset and the way i have always done it (vbscript/asp/ado) is Rs.Fields.Count, but this returns 1 or 0. What have i forgotten? How do i easily get the number of fields in my recordset?
  15. johndweidauer

    Transfer List Box values to TextArea

    Howdy, How do I throw the selected items from a list box to a text area?

Part and Inventory Search

Back
Top