Search results

I did some of steps for securing my database like: stop bypassing shift key hide navigation pane and some other security, I tried to hide my query is working but when check the shw hidden objects on new access database then is show all queries to import, are there anyway to secure my db...

I make an access application for sell (market management system), I need to secure the tables that contain login information by deleting the link of it in front end and make login form reading the username and password from backend table by using dlookup, this is all I need, To move the...

so as you mentioned it is not a good idea if I convert the select queries into vba?

Dear jdraw, I already did the same way that steve did at the beginning of creating my application and this is not my problem, my problem is how use dlookup to check the value of table in backend db while there is no link table in frontend, can you help me

its give me the error, if I convert all select queries into vba code then I can remove the queries on my database to prevent users from importing it can you help bro

Hello, How I can convert the select queries to vba code in my access application, I already converted the update and append queries to vba by using code: docmd.runsql "SQL script for query", but for select query this way is not working, are there any other way I can convert the select...

Hello, Dear all, I have a database application with frontend and backend access, when I use linked table of users in frontend file the program is working well but for security reason I don't need to link the table which include username and password for each users in frontend because anyone...

Thanks for your reply, I used microsoft access as BE? I will put the BE on sharing folder that all clients can access over the network so I need your suggestion about connection between them, The FE include Forms and Reports, The BE include Tables and Queries and encrypted with password

Thanks, but what is the difference if I write the path of linked query in record source at open form event and default record source field under Data tab?

Dear ridders I did the linked query, But I have three problems which are: 1. the textbox that I putted to count the record on form is #Error, before using linked query I wrote in control source of textbox "=DCount("*","QueryName")" , but now what should I write because I deleted the query in...

Dear ridders, which connection shall I use between FE and BE? I mean which one has the high speed, by default I used linked table and I don't know is good way or not

Thanks, It is the great way to secure the table and query of my database, I have another question by using link table and query the speed of opening form and report is like before "when the query is in frontend file"? If I share the backend file on network on server and the frontend on clients...

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?

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

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...

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

I don't have this option like the below

can you send me your email if possible?

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

how to send you private message? sorry