How to protect my tables and queries in access from importing

I don't know what is PM?

because I'm new in access programmers
 
how to send you private message?
sorry
 
ahmedaliazad said:
I can't send you private message because my account is new
Click to expand...

I'm sure you can if you switch on the option:
User Control Panel ... Settings & Options ... Edit Options ... then tick Enable Private Messaging
 
I don't have this option like the below
 

Attachments

  • MyAccount.JPG
    MyAccount.JPG
    71.6 KB · Views: 135
OK - I don't have the admin rights to modify your account.

Suggest you contact the site admins about that using the Contact Us button at bottom right of the screen
 
I get a lot of requests to fix user databases.
Often these have been sent to me by email without asking first.
For that reason, I've stopped accepting all requests to help via email.

I've already reported your problem to the other moderators.
If you do what I suggested as well, it may speed things up.
 
Dear Ridders,

It seems you don't want to help me for the following reasons:
1. you didn't send me your email
2. You didn't send me the code or any information about my question. You think if you send me the code I will share your code on the internet "which is not do it".
3. You sent me link that discuss how to convert accdb to accde which is I already know and this is not my question.
4. You sent me accde file which is not editable.

Thanks,
 
Last edited:
Your last resort then is to delete all linked tables and all queries.
Use form for data entries.
On each forms open event, use code to assign recordsource, eg.

"Select * from table1 in ' backend path';"

Since all request to tables are hard coded, you also need to ensure to put the backend to exact path that you have on your code. And using same mapped drive letter.
 
ahmedaliazad said:
Dear Ridders,

It seems you don't want to help me for the following reasons:
1. you didn't send me your email
2. You didn't send me the code or any information about my question. You think if you send me the code I will share your code on the internet "which is not do it".
3. You sent me link that discuss how to convert accdb to accde which is I already know and this is not my question.
4. You sent me accde file which is not editable.

Thanks,
Click to expand...

I'm sorry if it seems like that to you.

In fact I've spent quite a lot of time replying to you this afternoon and supplying links, all of which were relevant. If you had read the thread fully on another forum, you would have realised it went far beyond creating ACCDE files. I have also given you several hints which you don't appear to have acted upon.

The ACCDE file I supplied was partly to prove it can be done and to give you something to use in testing

I've explained why I've not supplied my email. It's nothing personal.

I have also explained why I'm not going to supply the code by PM / email or any other method. Again it's not personal. I haven't passed it on to anyone else either, not even to other very experienced forum users who I have worked with for some time and know to be trustworthy.

I have also tried to help you get PMs working by reporting this to forum leaders. Hopefully they will respond in the near future.

In the meantime, start with the links i provided and do some thorough research and testing of your own...as I had to do.

I would also suggest you re-read some of the earlier replies e.g. from the DocMan. He asked who you were trying to protect your data against. Authorised users? Outside hackers?

Either way, I'd be very surprised if you have completed all other security measures mentioned in my replies and those of others
 
I'm with Ridders on this one. Exchanging emails is a complete no no!

Everything must be kept public within a forum so that your exchange can help others. That's best for everyone. Also you have natural oversight from other members. This helps cut down on mistakes and missinformation. Also, you will often get different ideas which offer an alternative view.

If Ridders has some code he has developed, then he is perfectly within his rights not to share it if he doesn't want to.

Sent from my SM-G925F using Tapatalk
 
As I've already said, the link I provided is another lengthy thread with 31 posts & it covers other security related issues as well as ACCDE files.
It also contains several other useful links both to information and example databases.

I can only assume for your responses that you've still not read that thread properly or clicked on any of its links. In fact have you read any of it?

How's your own research going?

Good luck with your project
 
I read all posts on link that you sent it to me,
I found some information on db file that you sent it to me how to hide the tables, but the problem is you said not post on public, my private message is not working so what should I do?
 
Be patient re PMs.

If you've found out how to hide the tables, then test it out on a dummy database.

Otherwise work on other things in the meantime
 
Ah that's easy.
I didn't - Access created the record automatically for that table
But the other deep hidden table doesn't have a record whether made visible or deep hidden.

To be honest, I hadn't noticed that before.
I think the datatype used for each table explains that
You will also find 'traces' of all tables in other system tables.

NOTE: Most system tables such as MSysObjects cannot be directly edited.

That's another reason hiding the nav pane/ribbon/taskbar/app window as well as for password protecting the FE to make it harder for people to view system tables

Here's a link to another recent thread of mine you might find useful:
Purpose of System Tables
 
Last edited:
You must log in or register to reply here.

Similar threads

B
How to remove password protected from VBA modules
Replies
5
Views
173
theDBguy
theDBguy
M
Solved Can I access the user passwords in the MDW file?
Replies
13
Views
270
gemma-the-husky
gemma-the-husky
D
Solved Change password using tempvar not passing to following form
Replies
4
Views
147
Gasman
Gasman
N
Password Manager
Replies
8
Views
332
nobby
N
B
Importing from Excel
Replies
7
Views
314
AndT
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom