INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Connection String to MS Exchange 2013

Connection String to MS Exchange 2013

(OP)
I have a MS ACCESS 2010 FE and BE loaded to a pair of Citrix servers. The FE is loaded to a folder on the C drive of the server and the BE is stored on the server in a folder along with the WorkGroup. I have a linked table to the Outlook All Public folders area in a folder for the company Contacts. When logged in as any user I can reconnect this Contacts folder to their P drive let's say for this discussion and path down into the public folders to the Contacts folder. The Link is made and all is well. . . Not so. The path to this folder is not been changed a path to the User profile of the user I am currently logged in as. . . Admin for example. I need multiple users to be able to use this FE but they cannot as this link is and they do not have permissions to the link that has been relinked to ONLY one users profile.

I believe this is happening because of the characteristics of MS Exchange 2013(i.e.: http://geekswithblogs.net/marcde/archive/2013/03/2... ) The issue I am having I know how to reconnect most database types using the correct connect string and either creating a new connection or refreshing the link to the contacts folder. But, with Exchange 2013 I just can't come up with the identification that will work. I want to reconnect each and every time a user logs into the FE. Reconnect and let Exchange 2013 relink to the user's profile.

Example:
For Each tdf In MyDB.TableDefs
If Len(tdf.Connect) > 0 Then
If tdf.Name = "Contacts" Then
MyDBName = "Exchange 2013;MAPILEVEL=Public Folders\All Public Folders\All Public Folders\Contacts\Company Contacts|;PROFILE=CompanyName;TABLETYPE=0;DATABASE=F:\CompanyName\MDBS\DBName.mdb;TABLE=Contacts"
tdf.Connect = MyDBName
tdf.RefreshLink ' Relink the table.
Err = 0
On Error Resume Next
If Err <> 0 Then
RefreshLinks = False
Exit Sub
End If
End If
End If
Next tdf

When I execute this code I get "Err 3170 Cannot find Installable ISAM" on the tdf.RefreshLink. So, the Connect string is incorrect but can't seem to come up with the correct connect string.

Here's the ACCESS Help screen info: Exchange 4.0; MAPILEVEL=folderpath; [TABLETYPE={ 0 | 1 }];[PROFILE=profile;] [PWD=password;] [DATABASE=database;]

I haven't been out here on TT's for a long time but thought you guys could help me on this one. Retired for 10 years and now back at it with a great new company for the past 18 months. So, be kind to a "old" TT programmer . . . LOL

Bob

Bob Scriver
MSU Spartan


RE: Connection String to MS Exchange 2013

(OP)
thanks I was thinking I may not have the correct forum. Is it possible to transfer this question to the other forum?

Bob Scriver
MSU Spartan


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close