Got some related links but does not answer my question; Is it possible to prevent users from link the table in FrontendDb? Which is linked to MainDb?

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Hi, I am wanting to disable/hide the table in front [Which is linked to MainDb] from being linked. Is it possible to prevent users from doing that?

Thanks in Advance.
 
Xen, like always...you've been a great help again....Thank you very much! for the link the code and everything.

I was thinking of vice versa actualy. Macro to run VBA code;
this seems to work out "RunCode"

Thanks agian.;)


Here's a better article on what I generally employ:
http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552

If you want to become an expert you can read:
Real World Microsoft Access Database Protection and Security

I'm not sure what you mean by your other question. A form load event can trigger a macro:
Code:
[/FONT]
[FONT=Courier New]Sub Form1_Load()[/FONT]
[FONT=Courier New]    Call Macro1[/FONT]
[FONT=Courier New]End Sub

Where Macro1 is either a public procedure in a standard module or a procedure in the same form.

 
Upvote 0

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Only from inexperienced users.

Hi Boyd. Lastnight, as i was reseaching i found the thread you answered on the same... you guys are right..the experienced programmers can always do something...:)

Just of out curiousity, let us say I have very hidden all the table and the local tables are not visible when manually tried to link it to other db. and the front end file is .accde with no navigation pane on [that too is hidden, and will be hidden even if settings are changed manually by vba]...
How will you link or extarct the data from the front end from another database?:)


Thanks again all!
 
Upvote 0
I'm not sure offhand. If I were curious about your database, I might try seeing if I could find a way to unhide the tables. If I was really malicious I might look for weaknesses in your form design that would allow for sql injection attacks. Also, I might just try to find your backend. This might be as easy as scanning the network for mdb files to see if it turns up. Viewing your mde in a hex file can also provide some clues. I created an mde with a linked table and it wasn't very hard to find the back end just by looking at the file in a binary editor:

<img src="http://northernocean.net/etc/mrexcel/20110906.png" />

And I really don't know much about these things ...

ξ
 
Upvote 0
Hi Boyd. Lastnight, as i was reseaching i found the thread you answered on the same... you guys are right..the experienced programmers can always do something...:)

Just of out curiousity, let us say I have very hidden all the table and the local tables are not visible when manually tried to link it to other db. and the front end file is .accde with no navigation pane on [that too is hidden, and will be hidden even if settings are changed manually by vba]...
How will you link or extarct the data from the front end from another database?:)

Yes it is possible. I am not going to publicly post how to crack an Access database.

What I see is an even a bigger question of why are you having to worry so much about locking down Access. Sounds like you have much large issues with overall security if you have to try to work so hard to secure a software app , like Access, that can't be secured by itself.

I would work with your Network Security Specialist on how what additional security measures you should to use.
 
Upvote 0
Thanks Xen, thanks Boyd. I just am happy if there is no very easy way other users with very less knowledge [at least less then me:biggrin: then]...:)

Thanks
 
Upvote 0

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top