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!

Register Log in
  • 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: *

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

    Export to Access fails: Locking

    I have set up a DTS to export 5 or 6 tables from SQL Server to MS Access. The largest is about 125,000 records. The sequence is, delete from the MS Access table, then copy the table from SQL to Access. No trsnformations, just straight copying. Each time I test this DTS, at least one step...
  2. EITech

    Automate switch of web page ODBC recordsource

    The intranet uses one of 2 .mdb's as a recordsource. The ODBC connection has to be manually switched to point at the .mdb for the day. They are alternated because they need to be compacted & repaired daily, and something about the intranet connection causes an .ldb to be open all the time, so...
  3. EITech

    Grouping of table imports in DTS package

    Hi, I have a group of 6 tables I am importing using a DTS package. No particular reason why these 6 are grouped together, except that they all come from the same ODBC connection & DB. The DTS is Create table . . . Copy table sequence for each of the 6. The tables vary in size but the largest...
  4. EITech

    FollowUp on DTS DateTime Question

    Thanks, fluteplr and tlbroadbent, for your responses to my earlier post. I have a bit more information and am hoping you can keep me going. The field looks like this: }sÓ when it is imported from the H-P. From the vendor technical info, I see it is a 6-byte field mapped to different...
  5. EITech

    Newbie question on DTS DateTime Data

    I'm just getting started with SQL Server. I'm using the DTS wizard to set up an import from a Hewlett-Packard database. The H-P has a timestamp field that is not importing correctly -- I think it is importing in unicode? I searched the BOL and MS KB but didn't find anything that seemed to...
  6. EITech

    Batch file open .mdb with workgroup log in

    I'm trying to set up a batch file to open an .mdb. This would run unattended during the night. So far I have: START "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Folder\RevSchedules.mdb" /wrkgrp "L:\ITStuff\Workgroup.mdw" /user GoodUser /pwd MagicWord...
  7. EITech

    AT command

    OK, I'm a novice with NT so please explain slowly and clearly. I need to schedule something to run during the night. I've got the routine written, and I've got a batch file which opens the routine. I read in NT help about using the AT command, but I can't figure out WHERE you type the...
  8. EITech

    MS Database from Linux Server

    Hello, I am new to this forum and Linux. I am a database programmer, mostly MS Access. One of my clients is changing their network system to Linux. I can't seem to get a straight answer re: will client machines still be able to run Access (say they still have Windows, or have dual boot...

Part and Inventory Search

Back
Top