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 TouchToneTommy 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: *

  • Users: Paulvtis
  • Content: Threads
  • Order by date
  1. Paulvtis

    Export MDB to DBF using visual basic 6

    hi everyone! im new in programming vb. can anyone help me how to export mdb to dbf. thanks!
  2. Paulvtis

    torn page error

    this is the error: [microsoft][ODBC sql server][sql server]I/O (torn page) detected during read at offset 0x00000000003c22000 in file 'c:\sqldata\ms......mdf'. This prompted in our ERP software that is using SQL 2000 when I go to one of the modules. But generally the database is still working...
  3. Paulvtis

    process id deadlock causing error in shrinking db

    Am trying to shrink a database but error comes out always about deadlock with a process ID. when i killed the process, another deadlock occurs with another process. does this mean when am shrinking a db users cannot query reports from the said db? can't it be simultaneous since it is just...
  4. Paulvtis

    generating report zeros coming out

    We have an sql server that contains our data. We use VB to create programs. We use crystal for reports. We use access as local db. Problem: Our VB gets data from sql server from our database server in the network. Then, VB sends the data to local access mdb before crystal gets it from access...
  5. Paulvtis

    cannot login to domain

    I am using win2k professional. Everytime I login to our server win2k server error exist : the system computer's account is not in the primary domain. Therefore the workaround I do is login to local as admin then rejoin to domain but then everyday same thing happen. Please help tnx
  6. Paulvtis

    primary domain missing

    what is the error when i am trying to login to domain but sometimes it allows me to log while sometimes dont. the error is something like the primary domain account of computer is missing...
  7. Paulvtis

    SHARE PERMISSION

    what permission pertains to share permission in win2k? i want some users to be able to share folders while some shouldn't be allowed.
  8. Paulvtis

    replication of certain tables

    is it possible to replicate, using 'replication' function, only certain tables every night? but then, only the changes within the day will be replicated not all contents of the table. i know there is such thing if we will replicate the whole DB, but what if i will just replicate let us say...
  9. Paulvtis

    BACKUP TAPE AND RESTORE

    I have raised this question before but seems there was no answer yet, I am just wondering given the scenario wherein I have 2 servers namely S1 and S2. Then, I usually backup SQL data to disk and disk to tape using built in win2k backup. I am doing this in S1. If in case S1, let us say...
  10. Paulvtis

    connection from VB to crystal report

    I have the following connection string in VB 6 to be able to link my VB to crystal report 8. There is no problem with this. cryPO.connect = "DSN=TST;UID=sa;PWD=grr;DATABASE=DAT1;" but then, I want to 'not' include the user and password since in the ODBC we have already specified the...
  11. Paulvtis

    encrypt pword in tables

    how do i encrypt the password in a field if i have a table to contain a password for the users so that when i open the table i wont see the actual passwords? tnx
  12. Paulvtis

    blocking access to tables

    I would like to 'deny' access to certain users in sql but the problem is i have around 500 tables. for each tables i have numerous columns. does sql have a mass update feature rather than i have to deny access for example the 'delete' access for each table? if not, can i execute an sql script...
  13. Paulvtis

    starting sql server service to allow master restore

    How do I start the service in order to be able to restore master? what is the syntax for starting that allows this master db restore. there is something to do with a -m but I can't seem to get the actual syntax tnx
  14. Paulvtis

    backing and restoring tape media in win2k

    We have 2 servers. When I backup a tape using the built in backup tool from 1 server then, when I load the tape to another server I can't seem to view the media set on the other server. How do I restore the data to another server using the other server's tape drive? tnx
  15. Paulvtis

    error when executing connection using VB to crystal report

    I have a program in VB then upon doing all the processes in VB I send the output to crystal report. My database is SQL SERVER. I encountered an error require ansi_nulls and ansi_warnings during the connection what should I do?

Part and Inventory Search

Back
Top