221
i think i'm on my own here, but i figured i would drop back and throw a hail mary in hopes that someone is waiting in the endzone. i am trying to integrate my access database project with UPS WorldShip 10.0. i've used SQL Server Management Express to configure the database and view its structure and procedures. so far i've been able to set up a new SQL logon for the database with which i am able to log into the server remotely after creating a system dsn's using the sql server driver. i currently have it set up so i can view our customer database (and by gosh i can even edit them) within my access project by using ODBC and opening a table called within the default database ("upswsdb") called "dbo_calPkgAgent". this is about as far as i have gotten but i want to be able to add new customers to the database as well (so when a new customer is added to the access database, their shipping info will be put into the database as well). whenever i add a new record through the backend, i have been unable to view the customers through the UPS worldship interface. i can make a lot of guesses, but the one thing i am sure of is that there is a procedure within one of the FIVE databases that UPS WorldShip uses to process new records so i am looking for a needle in a haystack. does anyone have any experience with WorldShip that would be kind enough to give me any pointers in this area?
i could always just add blank john doe addresses to the UPS addresses and make them into actual customers when we get new customers are added but i would prefer a clean automated process. UPS also has a batch import feature, but that could get messy as well. anyways, i would very much appreciate it if any of you have any experience with WorldShip to give me something to chew on.
