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

ahmedaliazad

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
I don't know what is PM?

because I'm new in access programmers
 

ahmedaliazad

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
how to send you private message?
sorry
 

isladogs

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
I don't have this option like the below
 

Attachments

  • MyAccount.JPG
    MyAccount.JPG
    71.6 KB · Views: 115

isladogs

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
I just need to understand what is wrong if you send me your email?
 

isladogs

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
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:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:25
Joined
May 7, 2009
Messages
19,252
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

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

Nifty Access Guy
Staff member
Local time
Today, 03:25
Joined
Jul 9, 2003
Messages
16,442
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
 

isladogs

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

Registered User.
Local time
Today, 05:25
Joined
Aug 10, 2018
Messages
29
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

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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

MVP / VIP
Local time
Today, 03:25
Joined
Jan 14, 2017
Messages
18,309
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:

Users who are viewing this thread

Top Bottom