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

  1. Paulvtis

    Export MDB to DBF using visual basic 6

    sorry if i didnt make it clear.. DBF = Foxpro what i do is i get data from our sql server and put it in the table of access database. then from that specific table of access database, i want to export or convert or save it to dbf(Foxpro) file. iam using vb6. thanks for the help guys!
  2. 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!
  3. Paulvtis

    torn page error

    on the lowest part this is what is written after checkdb: CHECKDB found 0 allocation errors and 4 consistency errors in database 'UIGPI'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (UIGPI ). DBCC execution completed. If DBCC printed error messages...
  4. Paulvtis

    torn page error

    Below is the error after running checkdb can the db still be fixed? Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:7697) could not be processed. See other errors for details. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 2, index ID 255, page...
  5. 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...
  6. 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...
  7. Paulvtis

    generating report zeros coming out

    yes tnx. we tried installing same version of crystal everything is ok already tnx again
  8. 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...
  9. 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
  10. Paulvtis

    primary domain missing

    not yet. but why is it sometimes it allows sometimes not. anyway is there anything i can do like unjoin then rejoin to domain or whatever rather than use the kit? tnx
  11. 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...
  12. Paulvtis

    BACKUP TAPE AND RESTORE

    I have this already but my concern is i want to be able to restore the tape to an offsite server. Why is it like that wherein i can't restore the tape in another server? tnx
  13. Paulvtis

    BACKUP TAPE AND RESTORE

    they are the same. even the servers are the same. where can i see regarding if the hardware compression is enabled or not? if this is the case then what will be the purpose of my tape backup considering one of its purpose is for disaster recovery. Some told me there is a way but they cant seem...
  14. Paulvtis

    replication of certain tables

    1.) can i filter only to what has been modified? meaning those are the only ones that will be replicated. 2.) can you pls elaborate what you mean by the administration overhead? can you specify samples? 3.) This is because we will have a 'transaction server' for daily entry of trx then another...
  15. 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.
  16. 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...
  17. 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...
  18. Paulvtis

    connection from VB to crystal report

    yes i used admin user. no not trusted connection. i used 'sa' user in sql server to connect. tnx
  19. Paulvtis

    starting sql server service to allow master restore

    by the way i have tried the restore, it worked for the same instance but if i backup master from an instance say 'ins1' then i install another instance named 'ins2' when i tried the script to restore in a single user mode it still point to the old path of 'ins1' and i cant start the server...
  20. 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...

Part and Inventory Search

Back
Top