Admin Rights - Linked Table Manager

[Dwight]

I have an application in MS Access 2000 that consists of a FE and BE. The BE
is located on the user's C:\ in a folder titled "ResumeBuilder2.0". With
security getting tighter and tighter, users are starting to lose admin rights
to their PC. This is creating a problem with installing and running the
application. Since the linked tables must be in a location specified in the
"Linked Table Manager", and the user does not have rights to save the BE to
the required folder, the application gets a invalid path error.

Does anyone have any solutions to this type of problem?

I would like to be able allow the user to save the application files to
whatever folder they choose and have the FE know where the BE is.

Thanks in advance!

Dwight

 

[Stefan Hoffmann]

hi Dwight,

Does anyone have any solutions to this type of problem?

%USERPROFILE% is the right place for per user data or for all users
%ALLUSERSPROFILE%.


mfG
--> stefan <--

 

[Keith Wilby]

I have an application in MS Access 2000 that consists of a FE and BE. The
BE
is located on the user's C:\ in a folder titled "ResumeBuilder2.0". With
security getting tighter and tighter, users are starting to lose admin
rights
to their PC. This is creating a problem with installing and running the
application. Since the linked tables must be in a location specified in
the
"Linked Table Manager", and the user does not have rights to save the BE
to
the required folder, the application gets a invalid path error.

Does anyone have any solutions to this type of problem?

I would like to be able allow the user to save the application files to
whatever folder they choose and have the FE know where the BE is.

Thanks in advance!

Dwight

The common approach is to have the BE on a server where all users can access
it. The FE can reside in the user's profile space. Is that not an option?

Keith.
www.keithwilby.com

 

[Dwight]

This is not an option. The application is a single user application.

 

[Dwight]

This is not something that I can use in the "Linked Table Manager". How can
it be used for this problem in code?

Thanks!

 

[Stefan Hoffmann]

hi Dwight,

This is not something that I can use in the "Linked Table Manager". How can
it be used for this problem in code?

Go to a commandline and type: echo %userprofile%. This is the place
where the actual user has full access. So place the BE in folder below,
e.g.:


Public Sub LinkTable()

Dim Connect As String

Connect = Environ$("USERPROFILE") & _
"\Application Data\NG\mpa.modulesdaovba.mdb"

DoCmd.TransferDatabase acLink, "Microsoft Access", Connect, _
acTable, "table1", "table1"

End Sub



mfG
--> stefan <--

 

[Dwight]

Stefan,
Thanks for your responses. I have also been looking at some old posts and
found some the really help. I created a function in module1 as follows:

**********************************
Function UpdateTableLinks() As Boolean
Dim db As Database
Dim tdf As TableDef
Dim strPath As String
strPath = CurrentProject.Path
Set db = CurrentDb()
For Each tdf In db.TableDefs
If tdf.Connect <> "" Then
tdf.Connect = ";DATABASE=" & strPath & "\ResumeBuilder_data.mde"
tdf.RefreshLink
End If
Next tdf
Set tdf = Nothing
Set db = Nothing
DoCmd.OpenForm ("frmSplash")
End Function
********************************************

I then created a macro titled "AutoExec". The macro's action I set to
"RunCode", and for the function name I used the function created in module1
"UpdateTableLinks()".

Since I had a startup form titled "frmSplash" being displayed at startup, I
had to remove it and call it within the function using "DoCmd.OpenForm
("frmSplash")".

Thanks again for your time!

Dwight

 

[Aaron Kempf]

Linked Table Manager has been depecrated

you should be using Access Data Projects