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 Mike Lewis 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. hermes418

    VXA on SBS 2003 odd issue

    I've just taken on a client with a Dell Poweredge 1800 server and an Exabyte VXA-2 IDE internal drive. The issue is very odd; I noticed that ntbackup wasn't working; checked device manager and got an error 39 (bad driver). Reinstalled the VXA2 driver from Exabyte's website, but no change...
  2. hermes418

    Migrating Hardware Question

    I have a rather difficult one here; I have a client who has an old 2003 SMB server with two hard disks: C has the OS partition and Echange server installed, D has their primary accounting system installed. We're migrating to a new server they've purchased with no OS and two SATA drives they...
  3. hermes418

    Access Exchange server over Internet

    Got a question from an Exchange neophyte here. Running Exchange 2000 on Server 2000, everything works well on the LAN, but is there a way to connect Outlook 2000 over the Internet--I know how to do it with 2003, but didn't know how with 2000. And the client is not satisfied with the OWA...
  4. hermes418

    Exchange Public Folders Problem

    Just set up my first exchange server; everything is working great....except for one thing. Exchange is running on our local domain on "server2"; whenever a user opens the outlook web client and selects "public folders", instead of taking them to our public folders, it takes them to an outside...
  5. hermes418

    New to Exchange

    Getting ready for my first Exchange installation soon, and had a question. Company is moving to hosting their own IIS website as "companyname.com", and also wants to not change any of their current addresses, which are currently hosted by a third party and run "employee@companyname.com"...
  6. hermes418

    Server 2000 IIS DNS Question

    I understand it is a security risk--but this client is bound and determined, and I've learned to just go along. So, how would one alias Exhange to the current users? And will IIS work in this manner? Thanks
  7. hermes418

    Server 2000 IIS DNS Question

    I've got a client with a situation I've never handled before; they've had a third party handling their web hosting and email on a domain www.companyname.com. Now they want to start running IIS and Exchange on their own server 2000 PDC, but they have a large AD set up on the name...
  8. hermes418

    Question on Importing .CSV through VI

    And that's it! The job is done. I want to thank you so much for all of your help--I have learned quite a bit through this process--you have been great!
  9. hermes418

    Question on Importing .CSV through VI

    Got it fixed--I did need a UNC path; problems with the old workstation they've got my remoting into. One last question; is there any way to automate the VI job so that it will run daily? I;ve never had to do that before--I've always just run big individual jobs. The manual says that the...
  10. hermes418

    Question on Importing .CSV through VI

    It's working very well, except that if I try to set the destination to a sub-folder of a network drive (F:\tracking rather than F:) I get a runtime error 3625. Any ideas?
  11. hermes418

    Question on Importing .CSV through VI

    I am the happiest boy in the world! Exported the query into a .csv and ran my import and finally--success! Now, just an automation question--do you know any way to automate that export operation, or are they going to have to manually export that query everyday? (I have hit the end of my Access...
  12. hermes418

    Question on Importing .CSV through VI

    So far on my first two tests.
  13. hermes418

    Question on Importing .CSV through VI

    Okay, I've linked in SO_3 and the export, linked them by SO number, and built a query to pull SO,Package,Tracking and "last invoice number", which I presume is the proper field. What would you like me to post?
  14. hermes418

    Question on Importing .CSV through VI

    Familiar enough--I've now set up an empty database with an ODBC connection to MAS's ARN Invoice history header.
  15. hermes418

    Question on Importing .CSV through VI

    I have confirmed that they only do it that way. Do I need to start building an access database?
  16. hermes418

    Question on Importing .CSV through VI

    Okay, much progress has been made; here is what I've got: 1) I need to be importing in AR_19, not SO_19. 2) Unfortunately, AR_19 does require an invoice number and not an SO number, so now I've got my import job straightened out, and we still need the VB applet to add the package numbers, but...
  17. hermes418

    Question on Importing .CSV through VI

    Added the "Send_PKG_To_SI" field--don't see any result so far. I don't have access to rebuild, they'll have to try that on Monday. Thanks so much for your help--we'll see what happens when they get in on Monday and rebuild.
  18. hermes418

    Question on Importing .CSV through VI

    Here is my import job: CONFIGURATION INFORMATION ------------------------------------------------------------------------------------------------------------- FILE NAME: SO.INVTRAK S/O INVCE DATA ENTRY TRACKING IMPORT FILE: F:\Access Databases\upsexportfixed.CSV FILE TYPE...
  19. hermes418

    Question on Importing .CSV through VI

    I was mistaken when posting earlier--the number I am pulling out of Worldship is the invoice number, I just am so used to working with the SO module that I called it an SO number--it is indeed the invoice number.
  20. hermes418

    Question on Importing .CSV through VI

    Okay, the code works great (and I am incredibly grateful), assigns me all the number I need, but when I run the import into MAS I still have a problem. Data goes in, I can run a Crystal eport and see that all three fields have been populated; however, when I go into MAS and run a shipping...

Part and Inventory Search

Back
Top