Access 2013 - A Potential Security Concern Has Been Identified
May 19, 2015
I have created a new database which i have split using the database splitter creating two files, the front end (.accdb) and the back end (.accdc)
The front end works find it allows me to input data and can be used my multiple users as once,however when i come to add a new table or new field within an existing table i get the following error when opening the .accdc:
currently the database in on my C drive however i have also tested it on the network and i am still having issues?
i have edited the access trust settings and trusted both the c drive and the network directory yet i am still having no luck?
I run a large database using Access for compiling cricket statistics. The database was made by a friend in South Africa. Recently I asked him for an added feature to renumber the files etc, and he send me an e-mail with a file renum.mdb.
For some reason I cannot open this file, the message I get is:
Microsoft Access cannot open this file.
The file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems.
To open the file, copy to your machine or an accessible network location.
I am not too technical when it comes to these issues, is there anyone out there who could help, I would be very grateful.
I have user security level setup with username and password.I have set forms and tables etc to security levels.what i am having trouble with is setting user security levels to command buttons on the switchboard.Example if you sign in Mary Jones and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.
Code: Private Sub Form_Open(Cancel As Integer) If Forms!frmLogin!cboUser.Column(4) <> 2 Then MsgBox "you cant open this form"
[code]...
it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.
I have a form with a subform. The form has 2 controls, Preview and Submit. The submit button moves the records users are entering (Date, Company, Hours) from a Temp table to a ServiceTbl.
The users are allowed to select "?????" in company in case they don't know it at the present time. At the end of the month when all of these records will be 'Submitted' to the ServiceTbl, I need to check the value of each Company ComboBox on the Subform for the "?????" entries.
I tried the code:
If Me.CompanyCbx.Text = "?????" Then MsgBox("Enter correct company.") End If
However, that only works on 1 record, and that record has to be selected on the subform. If a new row is clicked, as in the user is going to enter new data in, but chooses not to, it still doesn't work.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
I have customers, projects and work tables. projects are linked to customer via customerid and work is linked to the project via projectid.
Ok..
What I'm trying to do is make a timesheet so that work done for a specific date for any project can be retrieved and concatenated into a string or put in row by row into a listbox.
As far as I'm aware, Dlookup only returns the first record, so if there was work done on more than one day for a different project, it won't retrieve it. So that leaves Recordsets, I am a complete beginner when it comes to recordsets.
I haven't found any decent tutorials or helpful posts anywhere, so any help that you guys could give would be awesome.
I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.
I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-
Option Compare Database 'Hide Access desktop screen and float Forms on pc desktop Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long
Dim dwReturn As Long Const SW_HIDE = 0
[Code] ....
I then have two buttons on a form coded as below:-
Option Compare Database Private Sub cmd_Hide_dbw_Click() Call fSetAccessWindow("Minimize", False, False) DoCmd.OpenForm "frm_Test", acNormal End Sub
[Code] .....
I have attached a Test Database which demonstrates the problem I am experiencing.
Do the following sequence...............
Open the Test Database. DO NOT ENABLE CONTENT The Access 'Ribbon'Test_Database.accdb is active and usable Open frm_Test in Design View in order to inspect, all should be as shown above. Now click the Enable Content warning Switch frm_Test to Form View
Click button Hide dbw. Closes the Access Window Click button Show dbw. Opens the Access Window...HOWEVER....
Attachment 20252The Access Ribbon is locked and usable !!!
I have created a database that is hosted on our company sharepoint. The database contains subcontracts with resource information by geographic location and status. I have built queries and added them as reports to the web app but I need to figure out a way to sum totals on the queries. For example, one report lists all resources of a particular type by 4 different zones and 3 different status. I need to have the bottom row show the total resources.
I have problem sharing an Access 2013 file from one cumputer and then change the data in the file on another computer, or i can change it but the change wont be made one both computers.
I'm working so i need my secretary to be able to change information or add, but i also need to get the change.
Using MS Access 2013, part of Office 365, I am trying to construct a report that has a different first page footer than the rest of the document. Googling for answers has produced a few options, but none that seem to work. I have virtually no VBA knowledge. I was hoping that there might be some code that I could place in a label in the footer and have it work.
I have an Access 2013 database file with many fields. One of them, I'll call it Field 3, is a box which I would like to either leave blank or put a check mark in it. I would like to be able to create an Iif field for Field 3 where a check mark is automatically inserted in Field 3 IF Field 1 - Field 2 <or= 0, otherwise I'd like Field 3 to remain empty.
I have a database table to which I will be adding multiple records from various other contributors. I would like to build a simple, import-friendly excel table that I can mail out to others, so that they can fill it out and send it back to me. Then I will save import steps as a macro or something similar, so that I can easily import their data.
The hard part is that I would like a way for Access to compare the new records with the existing records, identify potential duplicate records by predetermined criteria (in other words, 'wild-carded' to some level of specificity, since duplicates could be off by just a few characters), and then prompt me to examine each record to be imported alongside however many existing records that have been identified as potential duplicates. Then I as the user could:
1. accept the import record as a new record
2. decline importing that record since it is a duplicate of an existing record, or
3. edit by hand an existing record that is a duplicate of the proposed import, but may require additional information, and then decline to import the new one.After each prompt, I would like the import process to continue to the next potential duplicate, and when there are no duplicates, to complete the import and display a message box that says "Import complete".
Access 2013 ... Is it possible to compact a database to a new name?
(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...
we are moving from Access 2003 to 2013 using Windows 8.1 64bits. We used Leban's code and library to create and merge pdfs. C
Creating pdfs can be done with built-in functionality in Access 2013. But I can't find a way of merging pdfs. I've tried Leban's Dlls files but I am getting run-time error: "File not found:StrStorage.dll" do I need to do something extra to make Leban's code work on Windows 8 64bits ?
I made a new column in a table in access. The table is not linked and linking unfortunately is not an option. In the new column, I want to create a sum for 5 years of funding. There are multiple columns for a different fiscal year.
In excel, it is simply =sum(range), but I am drawing completely blank how to fill in the column with the sum data.
The end result is the data from 4 tables will be displayed in Forms and Reports.
Essentially what I need is an ability to bulk update a column in access table without a need to reupload the entire datasheet (over 100k rows with about 30 columns).
I am setting up a database using Access 2013, and am trying to test downloading files from Excel. For some reason it is not allowing me to have more then 4 columns in the excel file, it gives the error "Subscript out of range". I thought it was the type of variable at first, but when I tried deleting different columns on both files, the transfer always worked with 4 columns. How do I allow more columns to be transferred?Also, is there a way to not include the row numbers of the excel file as an ID column and only include the ID given in the first column?
So I have finished a database and split it which is great. Only issue now is how do I turn the front end into an executable so no access to any parts of the access program or system can happen? I have done this before in a very old version of access but how to do it in Access 2013.
I have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.I know how to do that in MS Excel, but is it possible in MS Access 2013?
My forms work well, but in form view are widely separated from the user tool bar. That is, the form is in the upper top left corner of the screen and the tool bar for choosing records is in the left hand corner at the bottom of the screen. I cannot get the tool bar in a position near the bottom of the form where it would be easier to work with.
Having trouble using .JPG images in Access 2013 reports? I inserted some images (of arrows) onto a label report. Since then, I've had problems with my DB becoming corrupted or "unstable". I can give more detail if wanted, but my main question is do y'all recommend using images in reports and forms. If so, what format?
In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.
1.) pink arrow // I've changed the titel in a diagram with vba ... is there also a methode to move the position of the titel with vba ( left-center or rigth ? )
2.) red arrow // maybe its because of the titel placement.I would like to change the size of a diagram with VBA code to have the diagram fit nicely to a given space best thing would be if there would be a possibility to resize the diagram in the given space