How to protect my tables and queries in access from importing (1 Viewer)

[ahmedaliazad]

I don't know what is PM?

because I'm new in access programmers

 

[isladogs]

Sorry. PM = private message

 

[ahmedaliazad]

how to send you private message?
sorry

 

[isladogs]

Its explained in the FAQ section:
https://www.access-programmers.co.uk/forums/faq.php?faq=vb3_user_profile#faq_vb3_private_messages

 

[ahmedaliazad]

I can't send you private message because my account is new

 

[ahmedaliazad]

can you send me your email if possible?

 

[isladogs]

I can't send you private message because my account is new

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

 

[ahmedaliazad]

I don't have this option like the below

 

[isladogs]

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

 

[ahmedaliazad]

I just need to understand what is wrong if you send me your email?

 

[isladogs]

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.

 

[ahmedaliazad]

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,

 

[arnelgp]

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.

 

[isladogs]

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,

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

 

[Uncle Gizmo]

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

 

[ahmedaliazad]

Dear ridders thanks for your reply,

but you sent me only one link which is convert accdb to accde,
http://www.accessforums.net/showthread.php?t=73182


The other links in signature is not shown

 

[isladogs]

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

 

[ahmedaliazad]

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?

 

[isladogs]

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

 

[isladogs]

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