By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,315 Members | 2,150 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,315 IT Pros & Developers. It's quick & easy.

Linked Tables path.

P: n/a

I have my front and back end database (they are in development) on a network
drive. Everytime I start the database up I get #Error? on DLookup objects
and such. This is solved by 'updating' the tables through the Linked Table
Manager. The path is S:\databaseBE.mdb. Can I just not set the path to

Because when i distribute the database to others users, the back end
database is going to be in the same folder as the front end database, and on
top of that they are probobly not going to have network drives, especially
ones with the drive letter 'S' if you get me.

I also have that problem with linked images. I have a report that keeps
changing the path I specify. I specify db_files\logo.JPG and access keeps
changing it to the full path (eg: S:\db_files\logo.jpg).

Any thoughts and help would be appreciated. thanks!


Kind Regards...

Customer Services Team
Blue Bell Trading


Blue Bell Trading
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I havent used this for a whiile, but I used to setup a button to
refresh links it would open a form with a text box where the user could
browse to the back end db and press OK, then the following code would
run. It basically would check for one table and if that table existed
in the backend it woudl continue trying to link to all of the. I would
store the name of the linked tables in a table named 'tblClientTables'

Private Sub cmdLink_Click()
Dim dbs As Database
Dim tdf As TableDef
Dim connections As Recordset
Dim connect_string As String
DoCmd.Hourglass True
' change the connection to the control_information table
' and check if there is a problem with that. If not, change
' all the other connections. If there is, warn user and kick them
back to
' the choose valid connection.

Set dbs = CurrentDb()
Set tdf = dbs.TableDefs("tblEvents") ' Checks for this single table
to make sure it is a valid backend, replace with any table of your
choice that is in the backend

connect_string = Me.txtFileName ' could add a browse function to
populate this box or type it in manually

tdf.Connect = ";DATABASE=" & connect_string
' Err = 0
' On Error Resume Next
'tdf.RefreshLink ' Relink the table.
'If Err <> 0 Then
' MsgBox "Data path is invalid", , "Operation Cancelled"
'DoCmd.Hourglass False
'Exit Sub
' End If

Set connections = dbs.OpenRecordset("tblClientTables")
If connections.RecordCount = 0 Then
Exit Sub
End If

While Not connections.EOF
Set tdf = dbs.TableDefs(connections![table_name])

tdf.Connect = ";DATABASE=" & connect_string
Err = 0
On Error Resume Next
tdf.RefreshLink ' Relink the table.
If Err <> 0 Then
MsgBox connect_string & " data path is invalid", , "Operation
DoCmd.SetWarnings True
DoCmd.Hourglass False
Exit Sub
End If

MsgBox "Tables Linked to " & connect_string & " were Refreshed", ,
"Operation Successful!"
DoCmd.Hourglass False

Exit Sub

MsgBox Err.Description
Resume Exit_cmdchange_Click

End Sub
Let me know if this works for you.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.