Hello,
I need to know is there any way to protect a shortcut on desktop ?
Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.
Any idea..?
With kind regards,
Ashfaque
Hi there,
My problem seems somewhat simple, but I guess since I'm posting this it was quite the contrary. I've completed my form and have linked all queries and reports and created all my macros for the form. Everything looks great but I when I created a .MAF shortcut to access the form directly from my desktop, it opens the form really big and maximized. Every time I open it, I hit the 'restore down' box-in-box button on the top right and it makes it just how I want it. Can I retain this as a default setting when I open it? I've checked in the Form options but no luck.
Richard
I hope this is the right forum for such a question, if not I apologize in advance.
I have an application that is being used by six people. When the newest version of it was built, I altered the desktop shortcut on everyone's PC to point to the newest version. Four of these shortcuts still work, but two are behaving somewhat erratically.
In the case of these two, clicking on the shortcut sometimes opens the older version of the application. I have recreated the shortcuts and they work for a while, before reverting to the older link. Going to the application via Explorer works fine.
While I am getting more comfortable with VBA, this area is outside anything I know. Could someone advise me on what affects whether shortcuts work or not? Do they automatically 'refresh'? If so, when?
In case it's relevant, everyone here is using the same versions of both XP and Access and everyone has access to the same drives.
:rolleyes: I know there is a way of placing a form on a desktop to an icon which only allows the user access to the form only! Help pleeease
View 1 Replies View RelatedHi all,
Today some of my users (primarily Access 9 users from what I can tell) have started experiencing weird Crash to Desktop issues.
The issue occurs when the user clicks a command button, which in turn should open an unbound form.
All other database functionality is working correctly.
The form is unbound, contains a combo, command button, listbox based on a query and several textboxes.
On open code is -
Private Sub Form_Load()
Me.cboType.Value = "Mail"
Me.lstResults.RowSource = "SELECT qryViewMail.ID, qryViewMail.Date_Received, qryViewMail.Customer_Name, qryViewMail.MDL_MVL, qryViewMail.Category, qryViewMail.Type FROM qryViewMail ORDER BY [ID];"
Me.lblStatus.Visible = False
End Sub
This functionality has worked correctly up until now.
Has anyone experienced similar issues before?
Thanks,
Rob
My server provider is telling me that my server is Linux and I would have to upgrade to windows to be able to connect my database to the SQL.so i figured, if there was a middle man who could collect the information and pass it along?Is there an add on of sorts to allow access to behave this way?
View 8 Replies View Relatedi have a users table where i save usernames and paswords. So anyone who has access to the users table and has little know how of access can read the passwords of other users. So I have encrypted these passwords. Now no one can read eachothes passwords but if someone has acess to the database he can copy his encrypted password to someone else's password and login using other people's account.
Any solution ????
one form in my database?
I would like to put a password on one form; all other forms are open to see.
Can this be done?
In my frontend code, I include a table with a version #. In my backend, I also include a version table. The front end will compare wih back end, and if it's different, it will force to get the updated version that it's stored in the LAN.
However, I do not want the user to open the file directly from the LAN because it might cause slow performance problem if multi-user,etc.
So I want to implement a code to force the application to be open only from desktop.
So far, I have a strUsername which detect the user network environ. Then, it will check the application path to determine if it was opened from:
C:Users<strUsername>Desktop
If not, then an error message will prompt to alert the member to copy the file in the LAN and save on their desktop.
It works on my laptop, all fine. Today I didnthe test in my user desktop, but the message saying that the file has to be opened from desktop keep appearing.
I double check the user folder and the Username environ is (cd98) but the user folder was setup as "CD98" capital letter. Does that affect the coding?
How can I make my code to not distinguish between lower or upper case either for username and folder user as well?
I used to have a code that we used to copy data from a folder that was on the desktop using the code below.
Code:
DoCmd.CopyObject "C:Documents and SettingsAll UsersDesktopWetcleans
This does not work with windows7. I have tried the C:USERSPUBLICDESSKTOPWetcleans but that does not seem to work either. How to access a folder on the desktop ?
I'd like to have a custom icon for the accdb file for the users. I recall doing it for pre-2007 databases, but I can't figure out how to change the 2007 db. Is it possible with 2007?
View 7 Replies View RelatedI have a very simple database using the MS template 'desktop time and billing' for MS Access 2007.
[URL] .....
Any new template with the option for VAT or Sales Tax for each Billable Hour and each Billable Expense?
If this is selected or overwritten at time /expense input stage and then automatically added to the invoice.
Not sure why MS omitted Sales Tax from their design?!
Can Access Master add Sales Tax /VAT and then post as a new template?
I have a split database. BE located at a server and FE on each users workstation. There are 8 concurrent users at the most. This runs smoothly over the LAN.
Now I'm adding a new feature to the database. I'm using a wheel loader to weigh products on a weight scale. The operator in the wheel loader is going to use a laptop with wireless LAN to connect to the network.
In risk of loosing the connection which in worst case might corrupt the database, I want to make a new database with a BE/FE setup. The BE will be placed on the same server as the current db. The FE in the wheel loader. I can then link from the current db (BE) to the new db (BE).The new db will only require two linked tables from the current db.
If worst case happens, would my current db be more protected against corruption than if I linked directly to the BE on the current db. I know there's no 'right answer' to this one, but I'd really like some opinions on it though.
Thanks in advance.
I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password.
Any ideas?
Thanks,
Jim
Hi,
Is the password property in Access secure enough to protect VBA code?
Regards,
B
Hi
i am wondering if it is possible to password protect a form?
I am building a DB which will hold personal information, all this info will be held in a table and displayed on a form, but I would like it so that the user has to enter their user name and password and only the form which relates to their details opens ( so like an open form and display specific field but passworded)
Any ideas?
hi,
Is it possible to password Protect a table in Access 97?
I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.
any ideas?
How I can protect the tables in a database and force the users to access them only through 'forms'. In other words the user will not be able to view or change the data in any table except through a form, when loading a form, the protection is diabled.
I need a total solution, I am not a powerful programmer. :confused:
Is there a way to password protect a form.
This is due to me having to send a mdb file, because i use A97 and the other end use A2000.
I tried sending the mde file but they could not convert it etc.
But i want to stop them getting into the code, you know how protective we are.
I want to hard code the password if thats any help.
Could some one please help me, thanks
Can someone point me in the right direction of how to protect a button using a password please
cheers
Andy
How can i simply prompt the user for a password when they click a button, if the password does not match the form will not open?
View 1 Replies View RelatedAs you can tell, I am trying to password protect a report.
This works great, but if you don't type anything in, all the employees names come up. How can you prevent that.
Like [Enter Employee Name Only] & "*"
Any Ideas
Can someone point me in the right direction of how to protect a button using a password please
cheers
Andy
is there *any* way to lock down a db so that a user can't import your tables and queries? i know an .mde prevents the importing of forms, but i don't want ANYTHING to be able to be exported. i'm thinking this may not be possible.
View 1 Replies View Related1. How to protect my access database. That is can i only let my boss to use ONLY and not see the struture / table relationship?
2. That i can use access table to call file form my computer desktop outside folder. Can i set the limit time for outside folder?(for example 3 days, after 3 days then the folder will damage or not exist? can i do that?
3. can i set the password and after some days(for example 2days). they cannot go into my access database?
4. can i make my access database only for use only, cannot copy and can i set the life time for my access database (for example maybe 2 days,
the access database cannot open. )
I built a database application, and I need for more than just myself to use it at the same time. I have just learned that I should have built a project instead. Can I change my application "Maintenance.mdb" to a project or do I have to start over?
View 5 Replies View Related