Linked Tables, access security help.

[Karen Hill]

I have a database which is split. The logic is in an MDE file, which
connects to a MDB file via linked tables. Now, since the MDE file is
installed, on one computer and the linked tables reside on another, how
can I programatically create it so they hook up properly?

I was thinking of something like a Form to add to the MDE file which
the user could select the location of the appropriate MDB file which
contains the tables. How would one do something like this? PS. I
know I'd have to program it using and MDB file and then reconvert it to
MDE.

Also, Since I have an MDB file which has the data on a server, how do I
prevent the casual user from deleting it? Is there a permission
setting that allows an MDB file to be opened and and used ,eg the MDE
file can update read write records, without the user being able to use
windows explorer to physically delete the whole MDB database file with
the tables?

Thanks in advance for your help

[Gord]

>Now, since the MDE file is installed, on one computer and the

linked tables reside on another, how can I programatically create
it so they hook up properly?
Look in the "NorthWind" sample database for a module called
[modRefreshTable Links]. That should get you started.

BTW, the process should work for an MDE file as well as an MDB. At
least I know that one can use the "Linked Table Manager" to update
table links in an MDE file.
Is there a permission setting that allows an MDB file to be opened
and and used ,eg the MDE file can update read write records,
without the user being able to use windows explorer to physically
delete the whole MDB database file with the tables?

You can edit the NTFS permissions on a file to allow writes but not
allow deletes. In Win2K it involves right-clicking the file, choosing
Properties, selecting the "Security" tab, clicking the "Advanced.. ."
button, then clicking ""View/Edit...".