469,621 Members | 1,823 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Linked Tables, access security help.

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

Nov 13 '05 #1
1 1709
>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
[modRefreshTableLinks]. 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...".

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Matthew Wells | last post: by
4 posts views Thread by Neil Ginsberg | last post: by
10 posts views Thread by Jim Devenish | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.