Using Access on a server with database on local PC

[Rags]

What is the files name access is looking for? I expect it to be either a reference to a missing code library or the linked tables that don't find the backend. If its an accdb file you will need to copy it to your local computer as well and fix the linked tables using the table link manager. If its a missing reference install the needed libraries and fix the references using the reference manager from the vba editor.

The attached message is what I get when I try to use local Access with copied DB on my PC.



Thanks

[hapm]

Seems very likely that you are working with a splitted database here and your front end misses its back end here. What you have are all the forms reports and queries used to represent the data. But the data it self still lies on the server. You will need to get a copy of that file, place it on your local computer and refresh the table links to apply the new location.

[Rags]

Seems very likely that you are working with a splitted database here and your front end misses its back end here. What you have are all the forms reports and queries used to represent the data. But the data it self still lies on the server. You will need to get a copy of that file, place it on your local computer and refresh the table links to apply the new location.

I copied the DB a week or so from the server earlier, about 8.5 MB's. I assumed I had "everything". Did I just get the front end? How do I refresh the table links?

Thanks for your help.

Have to leave town for a few days, so I'll have to pursue it when I get back home.

[ItsMe]

Why don't you ask someone in Data Administration or your IT department some of theses questions? Maybe your immediate supervisor can lead you in the correct direction. If it is part of your job to work on these files you should know the answers to at least some of these questions. If not, your supervisor should provide you with resources to find the answers.

[June7]

You need both parts of the split db - the frontend file and the backend file - copied to your local laptop.

To change the link path, right click on any table link in the frontend and select Linked Tables Manager. Search Access Help for more guidance.

Changes to either file will of course not be reflected in the originals on the server.

[Rags]

You need both parts of the split db - the frontend file and the backend file - copied to your local laptop.

To change the link path, right click on any table link in the frontend and select Linked Tables Manager. Search Access Help for more guidance.

Changes to either file will of course not be reflected in the originals on the server.

Just got back from being out of town. Thanks for the feedback....I'll try what you suggest.

[Z1nkstar]

What if all you do is setup a remote pc to the Computer that has the database on it then From local pc you could connect to it so that all the data is still on the server instead of you having to update the data on the server?

[Rags]

What if all you do is setup a remote pc to the Computer that has the database on it then From local pc you could connect to it so that all the data is still on the server instead of you having to update the data on the server?

I want to update a copy of the DB with test data so as not to corrupt original DB. Somehow I have to learn how to update the DB links to point to the DB on my copy.

[June7]

The links can be change manually with the Linked Table Manager or can run VBA code. Example:

Public Sub NormalizeTableLinks()
Dim td As TableDef
Dim db As DAO.Database
Dim strOld As String
Dim strNew As String
'replace the following strings as needed
strOld = "old path\filename.accdb"
strNew = "new path\filename.accdb"
Set db = CurrentDb
For Each td In db.TableDefs
    If InStr(td.Connect, strOld) > 0 Then
        Debug.Print td.Name
        Debug.Print "Old Link: " & td.Connect
        td.Connect = Replace(td.Connect, strOld, strNew)
        td.RefreshLink
        Debug.Print "New Link: " & td.Connect
    End If
Next td
db.TableDefs.Refresh
End Sub