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

    Powershell - using WINSCP to submit files to Filetype = JES

    I will try that this afternoon. Another restraint here is that I can only test in a little window everyday because you get 1 batch upload per day. I will let you know if it works.
  2. DBDivaAuto

    Powershell - using WINSCP to submit files to Filetype = JES

    Mikrom - one would think. The code runs and gives the verification that the SITE command was accepted but the file is not making it up to the remote server. I am wondering if it's a time issue. Like the time between the verification and the transfer of the file needs a little break in between.
  3. DBDivaAuto

    Powershell - using WINSCP to submit files to Filetype = JES

    Hi Everyone, I am trying to automate a process that I think should be possible in Powershell using the WINSCP as a mediator. The line in question is "call `"`"site filetype=JES`"`"" ` which I also tried "call site filetype=JES" ` # PowerShell >=7.3 $PSNativeCommandArgumentPassing = "Legacy"...
  4. DBDivaAuto

    Breaking the VBA Password in Access

    Hi Paul - I can see how you might see it this way. However, since I wrote these databases, I do not see it as illegal or hacking. I see it as me being an idiot for trusting my replacement to be diligent as I was in documenting passwords in our department password keeper. I see it in being...
  5. DBDivaAuto

    Breaking the VBA Password in Access

    Is there a way to break the VBA Password in Access? Many years ago, 2017, I handed off a series of databases to the new DBA and passworded the VBA code - giving him the passwords. These were done in Microsoft 2010 on a 2008 R2 server. Well - as you can imagine, we have to retire the server...
  6. DBDivaAuto

    Run VBA after Presentation in PowerPoint Opens

    Finally - easier that I thought. I was able to make the add-in and auto run - we will just have to have 2 engineers run. Thank you
  7. DBDivaAuto

    Run VBA after Presentation in PowerPoint Opens

    I can insert a button and run the code no problem. It's just trying to get an add in to work. I don't think this can be a permanent solution - I'd have to install the stupid add in on every machine in order to make it run. Sometimes Microsoft just gets it wrong.
  8. DBDivaAuto

    Run VBA after Presentation in PowerPoint Opens

    I have it saved as a .ppam and it is going to an AppData folder on the C: but it is not running any code on open.
  9. DBDivaAuto

    Run VBA after Presentation in PowerPoint Opens

    I have never had to make an addin - I tried yesterday for about 3 hours and had no luck. Any hints, clues, help on how to do this. BTW I have Microsoft 365.
  10. DBDivaAuto

    Run VBA after Presentation in PowerPoint Opens

    It's been a while since I have had to code something in PowerPoint (as in over 4 years) and things have changed a bit. I would like a piece of code to run when the presentation is done opening. We have slides that get uploaded to a file documentation system and when they do, it changes...
  11. DBDivaAuto

    Sql Server Connection issue

    Public Shared connection2 As String = "server=IPaddress,1433;Database=SAPC;User ID=myuser;Password=myPwd;
  12. DBDivaAuto

    Sql Server Connection issue

    Yes - of course. I think maybe my internal security is still somehow blocking. I am going to write a mini program and stick it on external server and run it and see if it's that.
  13. DBDivaAuto

    Sql Server Connection issue

    I have an internal and external SQL Server. The External is working great. I am able to write and read to/from... The Internal has an IP address and port, I have created Windows users on the server and gave those users security permissions of db.owner / admin. I set up the Connection to...
  14. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    I am trying to reset the password - but it tells me I need the Mysql command line utility - I don't have and installing has become quite time intensive. I thought I had it installed and it tells me no connection possible. I am forced to using a DB with mediocre admin compared to SQL and...
  15. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    #1044 is the error Don't worry Jim - If I have to wipe the whole frickin thing I will. Found out Plesk resets the root login and password to whatever you set as administrator. My thought now is that when I went on vacation for 2 weeks the password must have expired and is locking me out.
  16. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    I haven't worked with mySQL DBs in years but do have 20 years with SQL. I can tell you this is on a dedicated server I set up and there are no other users. On the Information_schema.USER_PRIVILEGES table only the admin acct I set up initially with this DB is present.
  17. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    And yes - before you ask - the account has the same credentials for DB
  18. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    Jim - I am the only one who currently has access to this account and the user name/ password is the only account with admin privileges on the server. My assistant could have access with this account as he knows the login info but he refrains from database anything because it isn't his strong...
  19. DBDivaAuto

    Admin permissions quandry for MySql permissions schema

    I have a MySql db on an external server where we will be putting an Intranet Site. I have 30 tables built out all under the site /db admin login ID. I finally got to where I only had permissions errors. Did some research and found an article re: the Information_Schema DB and the table...
  20. DBDivaAuto

    Using VB.net to read an Excel Spreadsheet and run Macros.

    Good Morning Skip - I am automating a manual process. I know when the process is run manually - with a human clicking the button that runs the macro we ran into problems because our data person types faster that a normal person. Programatically, I am having issues because no matter what I have...

Part and Inventory Search

Back
Top