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 derfloh 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. 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

    OK, I was afraid of that. I'll see if I can find out more about the H-P formats. Thanks for info.
  6. 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...
  7. EITech

    Batch file open .mdb with workgroup log in

    Hi, thanks for your response. It wasn't any of those things, but your response inspired me to experiment some more. I finally took the START off the beginning of the command line in the batch file, and it worked fine! (I had previously removed the wrkgrp and user switches, and just left the...
  8. 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...
  9. EITech

    AT command

    Aha! Now I get it. Using AT at the command line tells the scheduler what to do. So, there isn't any way to view what the scheduler has in it, when it last ran, etc? Do you just take it on faith that NT knows to do this now? Thanks a lot for your response.
  10. EITech

    Multiple access to Access

    Well if you have tested a different database in the same exact client-server distribution, and it works, then it would be a problem with this specific database. If you've already tried compacting and repairing, try creating a new shell database, and importing all objects into it, then renaming...
  11. 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...
  12. EITech

    MS Database from Linux Server

    Wow, thank you so much for an enormously helpful reply! Do you think it would be advisable for me to become more familiar with Linux (I know for general purposes it would, but I mean relative to this specific client's database)? Or would working on the database be essentially the same...
  13. 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