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 Chriss Miller 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. dkaplan

    Can't create ODBC link to SQL 2016

    Thanks for you comments, zandsc1. I finally did get it to work for a single user by downloading ODBC Driver 11 for SQL Server onto the users PC. The link for this is: https://www.microsoft.com/en-us/download/details.aspx?id=36434 Unfortunately, this ultimately has to work for multiple users...
  2. dkaplan

    Can't create ODBC link to SQL 2016

    Thanks for your response, kray4660. Actually, each user is connecting to the FE on a network. I'm pretty sure it's not an Access security issue. Since my post, I've figured out that most of the users do not have an OBDC driver that is compatible with SQL Server 2016. My next focus will be to...
  3. dkaplan

    Can't create ODBC link to SQL 2016

    I have an Access database (Access 10) that is linked to a SQL db via ODBC. Recently that SQL db was migrated from a SQL 2008 server to a SQL 2016 server. After that migration I established an ODBC link to the 2016 server using file DSN. This link works for myself, but users get the error...
  4. dkaplan

    Problem wih sp_addlinkedserver

    ...the other server. The link appears to have been established successfully. However, when I try to query a table on the linked server with select * from NameOfLink.MyDB.dbo.TableName I get the message: Msg -2146893007, Level 16, State 1, Line 0 SSL Provider: The client and server cannot...
  5. dkaplan

    Shell command won't work in Windows 10

    I have an Access form that opens a Word merge document with the following command: Call Shell("winword.exe" & " " & strFileName, 1) The command is in the onClick event of a button. This works on all of our Win 7 machines, but when run from a Win 10 machine, I get Run-time error '53' File not...
  6. dkaplan

    Excel Redaction

    Thanks, Combo. This has been very helpful.
  7. dkaplan

    Excel Redaction

    Thanks, Combo. Am I correct that Auto Recover will not revert to a previous version when the file is sent as an attachment?
  8. dkaplan

    Excel Redaction

    I have a user that wants to remove (redact) information from an Excel spreadsheet (2010), then send that spreadsheet to a third party. They want to be certain that someone at the other end cannot see the information they have deleted. To be clear: they are not deleting entire rows, they are...
  9. dkaplan

    Running Access On a virtual PC

    Actually, I have just been in the process of testing that solution. So far it seems to work. Thanks so much for your response.
  10. dkaplan

    Running Access On a virtual PC

    Thanks, lameid. Yes, I've thought about putting the reference on a network drive, but I was not sure if there would be consequences if multiple users accessed the file at the same time. Do you know if this is an issue? Just FYI: the reference in question is named Microsoft DAO 2.5/3.5...
  11. dkaplan

    Running Access On a virtual PC

    I have a very old Access program (originally developed in 2003, now running under Access 2010) that expects to find certain files on the C:\ drive. In the shop where I work, new users are now being given virtual PC's (non-persistent). Because I cannot see the c:\\ drive on these PC's, I am...
  12. dkaplan

    proc gets different result on different servers -- looses sort

    I have a proc in MS SQL that behaves differently depending on which server the proc is run. Proc B calls proc A which returns a sorted a table. Proc B takes the top 1 record from the sorted table. On our production server, the sort is preserved and we get the expected record. In our test...
  13. dkaplan

    Crosstab query -- average of the transformed field

    I have a crosstab query that returns averages by month. I want to add a final column that contains the average of the averages. (I know that this is not generally a sound practice, but there is a reason) The current output looks like action_type, worker_type april may june initial lead...
  14. dkaplan

    Dynamically change height of Group header

    Actually I did NOT know that. I have to confess I though it was inches. This explains the behavior I was seeing, and I have been able to adjust accordingly. Thanks, dhookom.
  15. dkaplan

    Dynamically change height of Group header

    I'm trying to dynamically change the height of a group header on an Access report, depending on conditions. The group header shrinks as expected, but when conditions change it does not expand. My code is below: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If...
  16. dkaplan

    RTF reverts to portrait in 2007 when using sendobject

    I have an Access 2003 Application which is running under Office 2010. The database creates reports and then automatically sends them as rft email attachments. This is done in VBA using sendObject. After moving to Office 2010 I have noticed that when the reports are printed, the page...
  17. dkaplan

    Is there an SQL UPDATE equivlant in SAS?

    Thanks, TLP I also found a way to do it in SAS syntax. data myLib.originalDataset; set myLib.originalDataset; if id = 22 then city = 'Paris'; proc print data = myLib.originalDataset; run;
  18. dkaplan

    Is there an SQL UPDATE equivlant in SAS?

    Is it possible, using only SAS syntax, to update a single existing dataset? The SQL equivalent would be: UPDATE myTable SET city = 'Paris' WHERE id = 22 P.S. I know this could be done using proc sql. I'm new to SAS and trying to learn the SAS syntax.
  19. dkaplan

    Reading in an existing dataset

    Thanks, jj72uk. This works perfectly.
  20. dkaplan

    Reading in an existing dataset

    I am just learning sas and something very simple is eluding me. I am trying to read specific variables from an existing dataset into a new dataset. I tried something like data newdataset; infile olddataset; input col1 col2; run; but I get an error? Can infile only be used with raw data...

Part and Inventory Search

Back
Top