Latest Contributions by LanceCole

Can you add an additional field to the table or feature?  If so, you could use field calculator to extract the number from the string using python. Then use that field for your select. The following would return the number only (as a string) or an empty string for values with out a number.   ''.join(c for c in !TESTNAME! if c.isdigit())   Your same string of 'ADAM' would return an empty string of '' and 500-ADAM would return '500'.  You can also use a code block to return an integer but you need to check to see if an empty string is returned first or you will get an error.  This also assumes there is only one number per string. A sting such as '12-ADAM14' would return '1214'. Below is a code block you could use in field calculator to return a number rather than a string.   def returnNum(testname): tmp = ''.join(c for c in testname if c.isdigit()) if tmp != '': return int(tmp) else: return 0   This would be called with:    returnNum( !TESTNAME!)     ... View more

Please keep in mind that the 64-bit version of Microsoft Access Database Engine 2016 Redistributable should only be installed if you do not have ANY 32-bit Office products installed.  This will also cause issues in other Office suite products, such as Excel, Outlook, Word, etc.  I have ArcGIS Pro installed on one of our servers to process nightly scripts with only 64-bit version of Microsoft Access Database Engine 2016 Redistributable installed - No MS Office installed.  I can utilize .accdb and .xslx files without any issues.  However, I cannot access these files on our desktop systems with 32-bit Office installed.  Fortunately, we have licensing to both versions and IT installed the 64-bit version of Office when ever we install ArcGIS Pro. A possible third option, would be to generate a script that would run on a regular basis to import your Access database (or selected tables) into file or enterprise geodatabase tables. Best of luck... ... View more

Here is the rundown from ESRI on this. ArcGIS Pro is a 64-bit platform therefore you must have the 64-bit version of Microsoft Access Database Engine 2016 Redistributable installed to see the Access drivers in the OLE Data Link dialog.  If you want to use Access on the same system you would need to use the 64-bit version of Office or Access.  You cannot install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable while running 32-bit version of Office.  This will break Office and ArcGIS Pro will be unstable when trying to use the drivers.  There are two options: Install a 64-bit version of Office. Don't install Office.  You only need the 64-bit version of Microsoft Access Database Engine 2016 Redistributable installed to use an access database in ArcGIS Pro.  You could use another system to edit the Access database.  Alternatively setup a virtual machine without office and access that from your normal system. ... View more

You are absolutely correct.  I also cannot open the 32-bit version of Access if the 64-bit version of Microsoft Access Database Engine 2016 Redistributable is installed.  Since you are using Office 365 you should be able to download and install the 64-bit version of office this may eliminate the compatibility issue.  I do not have access to a 64-bit version until this evening to confirm if you can still open Access with the 64-bit version of Microsoft Access Database Engine 2016 Redistributable installed but will check it out tonight.  I know the drivers were showing but I did not try to open Access.   ... View more

Got it to work with 32-bit Office.  However, this is against Microsoft’s recommendation not to install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable with any 32-bit Office products installed. 1) From Microsoft, download the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable.  This will be the AccessDatabaseEngine_X64.exe file. 2) Since you have the 32-bit version of Office installed you will need to install the file using the quiet mode otherwise the 64-bit version will not install and fails with a warning. 3) Open an administrative CMD window in the folder that has the file you downloaded.  You may need IT to install this for you, if you are in an enterprise environment. 4) Type "AccessDatabaseEngine_X64.exe /quiet". This will install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable even though you have the 32-version of Office. 5) You should now see the MS Office 12.0 and 16.0 Access Database Engine OLE providers listed.  I did not need to do a restart. It is my understanding that ArcGIS Pro requires the 64-bit Microsoft Access Database Engine 2016 Redistributable be installed as it is a 64-bit application even when running a 32-bit version of office.  I now have both the 32-bit and 64-bit version of the Microsoft Access Database Engine 2016 Redistributable installed and no issues yet.   ... View more

Pete,  I had a little more time to look into this and got it working, however, please see caveat at the bottom. 1) I see you have the Microsoft Access Database Engine 2016 Redistributable installed on your system in addition to MS office?  This needs to match the 32bit or 64bit installation of Office - please confirm.  Once you click the download button you will have the option to select the version or just download both. 2) Once this is installed, I recommend restarting your system. 3) Now when you right-click on Database in Catalog in ArcGIS Pro and select New OLE DB Connection you should have the options for Access I did get this to work when I had the 64 Bit Version of Office 365 installed with the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable.  On another system with the 32-bit versions installed it did not work.  I will put a support case in with ESRI for a possible bug. You can download the 64-Bit version of Office from office.com. ... View more

First, What version of Pro are you running?  You need at least 2.6. Second did you see @KoryKramer and @JoshuaBixby reply's at Is there any way to view .accdb data in Pro?   ... View more

Try clicking on the three buttons - Advanced, Standard or Basic under the license level.  You should see Yes under one of them for the version you are registered if the license has been applied. Again, reach out to ESRI Customer Support.  They are very helpful in resolving these issues. ... View more

Your post made me question if we had interpreted the ESRI's note correctly, so I went down that rabbit hole again.  Unfortunately, we found the same information but this time without question.  Only ArcGIS Desktop 10.0 can be used to manage ArcGIS Server 10.0. This is from - ArcGIS Help 10.2, 10.2.1, and 10.2.2 as was the previous note found in another section. ... View more

We found that note in the 10.1 or 10.2 documentation.  Using 10.8.1 we are able to make "user" connections to the ArcGIS Server but cannot create "publish" or "administrator" connections via ArcCatalog.  We also installed a copy of ArcGIS Desktop 10.2 and tried that as well, with the same results.  The credentials we are using are able to log onto the ArcGIS Server Manager web interface and works with the "user" connection, so it should not be a permissions issue.  The tools we would like to run against the server are not available with just a "user" logon.  It needs to be an "administrator" logon. The connection error we are getting is noted below which made us question the URL and the reason for our original post.  After finding the archived help documents, we believe we are using the correct URLs to connect and the issue is most likely newer versions of ArcGIS Desktop cannot be used.       ... View more

Not necessarily ArcInfo/advanced, we just happen to have that version installed on the old VM, you cannot use a version of ArcGIS Desktop newer than 10.0 to access ArcGIS Server 10.0 via an administrative connection. Below is the reference from https://resources.arcgis.com/en/help/. ... View more

Thanks Joshua.  I found those yesterday as noted in the prior post along with the bad news that you can only create a administrator connection in Catalog or Desktop to a 10.0 ArcGIS Server using ArcGIS Desktop 10.0. Newer versions (10.1+) will not work so I am going to try and reach out to ESRI one more time and see if we can get the old license server running.  ArcInfo 10.0 is installed on the VM just no license is available. ... View more

After more internet browsing I found the connection strings for 10.0 at Making a user connection to ArcGIS Server in ArcCatalog and Making an administrative connection to ArcGIS Server in ArcCatalog.  They are inline with what we were attempting.  However, ArcGIS Server 10.0 or older versions cannot be administered using ArcGIS for Desktop version 10.1 or newer. So unless we are able to get the license for ArcGIS Desktop 10.0 we will not be able to access the data on the ArcGIS Server via Desktop or Catalog.  I will try ESRI one more time. ... View more