Search results for query: *

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

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

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

I am trying to read tables on an 2008 SQL server from a 2012 SQL server. I have run sp_addlinkedserver on each server, referencing 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...

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

Thanks, Combo. This has been very helpful.

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

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

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

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

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

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

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

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.

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

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

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;

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.

Thanks, jj72uk. This works perfectly.

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