Select to view content in your preferred language

New OLE DB Connection should support double-quotes in Data Source Path

346
1
09-21-2023 07:31 AM
Status: Open
Labels (1)
PeterKnoop
MVP Regular Contributor

When right-clicking on Databases in Catalog, and selecting New OLD DB Connection, then choosing the Microsoft Office 16.0 Access Database Engine, the next Dialog asks for a Data Source.

If you go to your Window's File Explorer, right-click on the Access database file you want to use, and select "Copy as path", the value that is generated is a path enclosed in double-quotes. When you paste the value in to the Data Source field, and click on Test Connection you receive an error, "...Not a valid file name." Removing the quotes eliminates the error.

The Data Source field should support entering a quoted path to make it easy to cut-and-paste, and not have to manually enter a path.

1 Comment
SaratogaPLAN

Peter,

Can you help me with a question about Field Maps?  I saw your idea "Support GPS time-duration streaming regardless of apparent distance traveled".  Is it possible to access the resulting points/vertices from streaming a line?  I want to assess the horizontal accuracy of the points; which ones to use and which to discard.

Thanks.

Stewart