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

Stop importing

P: n/a
Is there a way to stop importing tables from an mde database to a newly
created database. I wish to protect the data in the mde so that it can only
be accessed through a particular front end database. I know you can prevent
import of queries and modules etc but cant seem to acheive same for tables

Any help appreciated
Thanks
Ian
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.821 / Virus Database: 559 - Release Date: 21/12/2004
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
One possible solution is to use a custom toolbar and disable the builtin
toolbars. You can right-click on any existing menu/toolbar. On the
dialog box that appears select "Customize", then select "Toolbars" on
the next window, then in that window select "New". Create a new toolbar
and give it a name. Then click OK. Right-click on your new toolbar and
go to "Customize" again. Select "Commands" tab. There are several
options here of stuff you can add to your new toolbar. The easiest
thing to work with is the "New Menu" option which is at the bottom of
the scroll list. Click on that. Then in the window to the right you
drage the "New Menu" label to your new toolbar. You will get a + (plus)
symbol. That means you can drop the "New Menu" object there - usually
at the edge of the toolbar. Then Right-Click on your "New Menu" object
and select "Customize" again, and go to "Commands". You need to
re-click on the "New Menu" object to highlight the "Modify Selection"
button in the "Commands" tab. Click on "Modify Selection" and select
"Begin a group". You can add more "New Menu" items to the one you just
added right underneath it by dragging more "New Menu" objects to the
left bottom of the original "New Menu". You can also rename these
objects/items by going to "Customize", "Commands", re-click on the item
you want to modify to highlight then "Modify Selection" button. At the
top of that dialog is the rename window. Then, again on the "Modify
Selection" button click on "Properties". Here you can invoke custom
function in the "On Action" combobox that is in the middle of the
properties list. Here is the syntax for that:

On Action =someCustomFunction()

In the window of the combobox you would type

=someCustomFunction()

where some custom function is like

Function TestMsg()
MsgBox "testing"
End Function

On Action =TestMsg()

You write your test function in a standard module first. You have to
include the Parentheses in the On Action call of the properties of your
"New Menu" object.

Anyway, then you can write other custom functions for performing other
tasks. The list goes on, but hopefully you get the idea. This is how
you can really customize your front end app.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #2

P: n/a
On Tue, 28 Dec 2004 22:12:12 -0000, "Ian Davies"
<ia*******@hotmail.com> wrote:
Is there a way to stop importing tables from an mde database to a newly
created database. I wish to protect the data in the mde so that it can only
be accessed through a particular front end database. I know you can prevent
import of queries and modules etc but cant seem to acheive same for tables


Read up on RWOP queries and Access security.

mike
Nov 13 '05 #3

P: n/a
Rich P wrote:
One possible solution is to use a custom toolbar and disable the
builtin toolbars. <snip>

I don't quite understand this. How would this prevent someone
importing the tables to a new database?

The only way I know of to prevent this is Access security or setting a
database password (not very secure but something is better than
nothing).

Nov 13 '05 #4

P: n/a
I misread the question. Access Security is the only way to prevent the
importing of tables. I just never use Access security since I don't use
Access for data storage (sql server). But if you want to keep users
from modify an Access App, using custom command bars and an mde is
simpler than using Access Security.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.