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?
View Replies
ADVERTISEMENT
Oct 6, 2006
Hello,
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.
Victor
View 2 Replies
View Related
Aug 3, 2015
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.
View 5 Replies
View Related
Sep 30, 2013
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.
View 14 Replies
View Related
Mar 26, 2007
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)
View 4 Replies
View Related
Jul 26, 2006
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.
Thanks
Bob
View 1 Replies
View Related
Apr 6, 2015
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 cannot find a way to re-activate the Ribbon
View 2 Replies
View Related
May 5, 2015
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.
View 6 Replies
View Related
Jul 4, 2014
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.
View 2 Replies
View Related
Apr 7, 2015
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.
View 1 Replies
View Related
Oct 26, 2013
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.
View 9 Replies
View Related
Jun 28, 2013
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".
View 6 Replies
View Related
Jan 30, 2015
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)...
I can't see where to do this in Access 2013!
View 1 Replies
View Related
Nov 17, 2014
I want to do multiple regression in Access 2013. with the VB code?
View 3 Replies
View Related
Mar 11, 2014
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 ?
View 8 Replies
View Related
Nov 28, 2014
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).
View 2 Replies
View Related
Jun 18, 2013
I'm currently working on a project which requires integration of sms feature in ms access 2013.
The sms provider which i use for sending sms is smsglobal.
View 1 Replies
View Related
Mar 27, 2014
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?
View 4 Replies
View Related
Dec 18, 2013
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.
View 2 Replies
View Related
Feb 11, 2014
I need to copy all text from all textbox to one text box.
View 14 Replies
View Related
Nov 4, 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?
View 3 Replies
View Related
Sep 16, 2015
I often get revised versions of a record and make a duplicate and edit as needed.
In 13 my memo fields do not keep line structure
line 1
line 2
line3
Instead they be come one big continuous string of text.
line 1 line 2 line3
At least a space is added before each line.
Is there a fix or is this just something we have to live with?
Of note I am using my office's Dell laptop that was just "upgraded" to Win8.1 why not 10 beats me... 7 was so much better that 8 or 8.1.
View 9 Replies
View Related
Nov 6, 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.
View 9 Replies
View Related
Apr 29, 2015
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?
View 2 Replies
View Related
Feb 21, 2013
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.
View 6 Replies
View Related
Oct 17, 2014
I would like to do two things
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 ? )
Private Sub Form_Current()
' KostenHinweis im Diagram
Me!Dia_WS.Object.ChartTitle.Text = _
"Preis: " & Me.[Roh-Preis] & "€/kg " & _
" Mindestbestand =" & Round(Me.MindestBestand * Me.[Roh-Preis], 0) & "€ ; " & _
" Maximalbestand =" & Round(Me.MindestBestand_Max * Me.[Roh-Preis], 0) & "€"
'Me!Dia_WS.Object.ChartTitle.Left ???
End Sub
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
View 3 Replies
View Related
