Connecting to Microsoft Access Data Sources
Connecting to Microsoft Access
Below are example connection strings to MS Access database files or streams, using the driver's default data modeling configuration (see below)
| Service provider | DataSource formats | Connection example |
| Local | File Path file://localPath/MyDatabase.accdb | DataSource=C:/folder1/MyDatabase.accdb; |
| HTTP or HTTPS | http://remoteStream https://remoteStream | DataSource=http://www.host1.com/streamname1; |
| Amazon S3 | File Path s3://remotePath/MyDatabase.accdb | DataSource=s3://bucket1/folder1/MyDatabase.accdb; AWSSecretKey=secret1; AWSRegion=OHIO; |
| Azure Blob Storage | azureblob://mycontainer/myblob/MyDatabase.accdb | DataSource=azureblob://mycontainer/myblob/MyDatabase.accdb; AzureStorageAccount=myAccount; AzureAccessKey=myKey; DataSource=azureblob://mycontainer/myblob/MyDatabase.accdb; AzureStorageAccount=myAccount; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Google Drive | File Path gdrive://remotePath/MyDatabase.accdb gdrive://SharedWithMe/remotePath/MyDatabase.accdb | DataSource=gdrive://folder1/MyDatabase.accdb;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; DataSource=gdrive://SharedWithMe/folder1/MyDatabase.accdb;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| One Drive | File Path onedrive://remotePath/MyDatabase.accdb onedrive://SharedWithMe/remotePath/MyDatabase.accdb | DataSource=onedrive://folder1/MyDatabase.accdb;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; DataSource=onedrive://SharedWithMe/folder1/MyDatabase.accdb;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Box | File Path box://remotePath/MyDatabase.accdb | DataSource=box://folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Dropbox | File Path dropbox://remotePath/MyDatabase.accdb | DataSource=dropbox://folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; |
| SharePoint SOAP | File Path sp://remotePath/MyDatabase.accdb | DataSource=sp://Documents/folder1/MyDatabase.accdb; User=user1; Password=password1; StorageBaseURL=https://subdomain.sharepoint.com; |
| SharePoint REST | File Path sprest://remotePath/MyDatabase.accdb | DataSource=sprest://Documents/folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; StorageBaseURL=https://subdomain.sharepoint.com; |
| FTP or FTPS | File Path ftp://server:port/remotePath/MyDatabase.accdb ftps://server:port/remotepath/MyDatabase.accdb | DataSource=ftps://localhost:990/folder1/MyDatabase.accdb; User=user1; Password=password1; |
| SFTP | File Path sftp://server:port/remotePath/MyDatabase.accdb | DataSource=sftp://127.0.0.1:22/folder1/MyDatabase.accdb; User=user1; Password=password1; DataSource=sftp://127.0.0.1:22/folder1/MyDatabase.accdb; SSHAuthmode=PublicKey; SSHClientCert=myPrivateKey |
| Azure Data Lake Store Gen1 | adl://remotePath/MyDatabase.accdb adl://Account.azuredatalakestore.net@remotePath/MyDatabase.accdb | DataSource=adl://folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; AzureStorageAccount=myAccount; AzureTenant=tenant; DataSource=adl://myAccount.azuredatalakestore.net@folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; AzureTenant=tenant; |
| Azure Data Lake Store Gen2 | abfs://myfilesystem/remotePath/MyDatabase.accdb abfs://[email protected]/remotepath/MyDatabase.accdb | DataSource=abfs://myfilesystem/folder1/MyDatabase.accdb; AzureStorageAccount=myAccount; AzureAccessKey=myKey; DataSource=abfs://[email protected]/folder1/MyDatabase.accdb; AzureAccessKey=myKey; |
| Azure Data Lake Store Gen2 with SSL | abfss://myfilesystem/remotePath/MyDatabase.accdb abfss://[email protected]/remotepath/MyDatabase.accdb | DataSource=abfss://myfilesystem/folder1/MyDatabase.accdb; AzureStorageAccount=myAccount; AzureAccessKey=myKey; DataSource=abfss://[email protected]/folder1/MyDatabase.accdb; AzureAccessKey=myKey; |
| Wasabi | File Path wasabi://bucket1/remotePath/MyDatabase.accdb | DataSource=wasabi://bucket/folder1/MyDatabase.accdb; AccessKey=token1; SecretKey=secret1; Region='us-west-1'; |
| Google Cloud Storage | File Path gs://bucket/remotePath/MyDatabase.accdb | DataSource=gs://bucket/folder1/MyDatabase.accdb; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; ProjectId=test; |
| Oracle Cloud Storage | File Path os://bucket/remotePath/MyDatabase.accdb | DataSource=os://bucket/folder1/MyDatabase.accdb; AccessKey='myKey'; SecretKey='mySecretKey'; OracleNameSpace='myNameSpace' Region='us-west-1'; |
| Azure File | File Path azurefile://fileShare/remotePath/MyDatabase.accdb | DataSource=azurefile://bucket/folder1/MyDatabase.accdb; AzureStorageAccount='myAccount'; AzureAccessKey='mySecretKey'; DataSource=azurefile://bucket/folder1/MyDatabase.accdb; AzureStorageAccount='myAccount'; AzureSharedAccessSignature='mySharedAccessSignature'; |
| IBM Object Storage Source | File Path ibmobjectstorage://bucket1/remotePath/MyDatabase.accdb | DataSource=ibmobjectstorage://bucket/folder1/MyDatabase.accdb; AuthScheme='HMAC'; AccessKey=token1; SecretKey=secret1; Region='eu-gb'; DataSource=ibmobjectstorage://bucket/folder1/MyDatabase.accdb; ApiKey=key1; Region='eu-gb'; AuthScheme=OAuth; InitiateOAuth=GETANDREFRESH; |
| Hadoop Distributed File System | File Path webhdfs://host:port/remotePath/MyDatabase.accdb | DataSource=webhdfs://host:port/folder1/MyDatabase.accdb |
| Secure Hadoop Distributed File System | File Path webhdfss://host:port/remotePath/MyDatabase.accdb | DataSource=webhdfss://host:port/folder1/MyDatabase.accdb |