StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19823799
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-11-06T22:05:28.947
FavoriteCount
0
LastActivityDate
2014-01-09T15:18:46.663
LastEditDate
2014-01-09T15:18:46.663
LastEditorUserId
122139
OwnerUserId
1582588
ParentId
9607611
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I'd like to add to this; a password for a back end table connection can be updated in a VBA macro. Add the following lines and replace the name for the linked table & the password. <pre><code> Dim cdb As DAO.Database Set cdb = CurrentDb cdb.TableDefs("Projects").Connect = "MS Access;PWD=PaSsWoRd;DATABASE=C:\Users\bob.smith\Desktop\Split\Database_NEW_be.accdb" cdb.TableDefs("Projects").RefreshLink </code></pre> I found this was useful after splitting a database into a front end and back end using the built in split functionality. I needed to encrypt the back end for security purposes and didn't want to have to recreate all the data connections - isn't that the point of using the split function? Duplicate the above lines for each linked table and let the macro run through. The linked tables should resume working after this. <hr> This answer solved an issue for me. So I am upvoting, and also I want to provide an enhanced version that you can run on all tables: <pre><code>Public Sub RevisePasswordForLink() Dim cdb As DAO.Database Set cdb = CurrentDb Dim tdf As TableDef, colTdf As TableDefs, strConnect As String Set colTdf = cdb.TableDefs strConnect = "MS Access;PWD=paSsWoRd;" _ "DATABASE=C:\Users\bob.smith\Desktop\Split\Database_NEW_be.accdb" For Each tdf In cdb.TableDefs ''I believe best to skip the hidden tables ("MSys*") If Not tdf.Name Like "MSys*" Then ''If your DB has any local tables, you can save yourself some errors ''by filtering them out (similar to hidden tables). cdb.TableDefs(tdf.Name).Connect = strConnect cdb.TableDefs(tdf.Name).RefreshLink Debug.Print " " & tdf.Name End If Next tdf Set cdb = Nothing Debug.Print "FINISHED " End Sub </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMS Access Can't Link to Encrypted Backend Database
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSmandoli
UserOwnerUserId
1. USShrout1
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.