Security Question..after Reading Many Posts..

Jun 16, 2005

I didnt find answer to my question!..
Hope someone here can help..

I just added security to my access application...
I have added a new user and gave all admin rights. Removed all permissions from Admin and Admins group. When I log on as this new user who is equivalent of Admin,

I am able to doubleclick the table(linked table) and modify/delete the data..but when I the form is executing, it says, "Records cannot be read, no read permission on <Table>"

Hope someone can answer my question.

Thanks very much.

View Replies


ADVERTISEMENT

Barcode Reading And Security

Jan 30, 2007

Hi Guys,

This might be pretty simple, but I haven't found anything on it (might not have looked hard enough!). What I am trying to do is scan a barcode label that I created in Access, when this is scanned, it goes to a table and opens the record that contains this ID and allows me to enter further data in this record. The further data will be data capture from a balance, which works fine if you select the location where the data is to go (using the mouse), what I need is for this location to be automatically accessed when I scan the barcode, hope that makes sense.
Also, is there any way in Access to either prevent data in a table from being changed once it is entered, or alternatively to mark the data as changed/edited from the original input?

Any help would be greatly appreciated.

Nigel

View 1 Replies View Related

92, 000 Posts??? But I Am Only New

Sep 15, 2005

Can anyone tell me why I have 92,000 posts when I have only just joind today?
I am fast but not that fast.....

View 14 Replies View Related

Old Posts

Jun 5, 2005

I'm really afraid to ask this question. I was working on a database for our LawFirm about a year ago but it was a longterm project and low priority. For reasons beyond my control I got away from it and am just getting to back to it. Miles and many of you were very helpful to me in answering my questions. I can't remember the user name I chose and my dob is not listed so I can't find it that way. I have searched what I thought was the user name and every combination thereof. I'm wondering if I got deleted after so long for inactivity? I certainly don't to waste people's time by asking the same questions a second time. Anyone have any ideas how I can find my old posts?

View 2 Replies View Related

Duplicate Posts

Jul 11, 2005

i have a table with 3 fields: ID, line_item, and pay_app.

line_item and pay_app are linked to other tables in a one-to-many.

For every pay_app, there can be up to 100 line_items. However, I only want each line item to appear once (at most) in each pay_app. I want to prevent the same line item from showing up multiple times in the same pay_app. Essentially, I want to prevent duplicate entries, but with a stipulation, if that makes sense.

View 1 Replies View Related

How Do I Find My Posts?

Sep 27, 2005

I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?

Thanks in advance to whoever replies :D

View 2 Replies View Related

Finding My Posts

Sep 4, 2006

Is there a way to find all my old posts except looking at all 381 pages?

View 4 Replies View Related

Adding Links To Posts

Feb 28, 2008

Sorry, cant find this in help, and cant do it by trial and error

How do I add a link to a post/thread in a reply

View 4 Replies View Related

Congrats To Rural Guy - 2000 Posts

Jan 3, 2006

Congratulations on your 2000th post since July 2005.

That is indeed impressive.

Best wishes,

Bob

View 3 Replies View Related

Limited Posts In Access DB Forum

May 2, 2007

Hi there!

I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-).

The reason for this is that the db want accept more posts unless I do so.

My question is how do I "extend" the db to accept more posts?


Thx in advance,
Sarre

View 5 Replies View Related

General :: Not Receiving Email Notifications Of Posts

Apr 9, 2013

I don't appear to be getting any email notifications of posts in threads to which I have subscribed.I have Instant in my profile/userCP, but have not been receiving emails for some time. I edited my preferences today again -- I set it to daily, saved, then reset to instant, and saved. Thought that the edit may tweak some anomaly???

View 3 Replies View Related

Advice For Security & Question On Built In Access Security

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

Reading A Table From Within Another Database

May 19, 2005

I'm fairly new to access (now using for work purposes) and i've become a bit stumped...

I have a database set up and running fine, however I want to be able to generate a form in one database from a table within another. Is this possible?

Thanks for your input, It will all be apreaciated.

skelmer

View 2 Replies View Related

Reading A .txt File Using Access

Nov 16, 2004

Here's my situation. I have a .txt file that I need to bring into Access. This .txt file is set up with records that are separated by semicolons.

I need to pull this information into Access and separate the data by the semicolons. I can open the file in Excel and separate the information by using Data --> Text to Columns --> semicolon (as the separator).

Does anyone have an idea how I can do this into Access.

View 2 Replies View Related

Reading Combo.column(1)

Dec 24, 2006

on the audit trail modul

when the field is combo box I need to capture the combo's column(1) to my audit trail table

i used the code :

If TypeOf ctl Is ComboBox Then
rst("OldValue") = ctl.OldValue.Column(1)
End If

but it's not working

can any one help me with that

many thanks in advance

View 1 Replies View Related

Issue Reading # In The Recordsets

Nov 19, 2004

I am working on searching my customer number in my billing table and finding the appropriate customer and then pass the customer number onto my shipping table to find the corresponding shipping data to go with my billing data. My problem is this :

When I find my customer in my Billing table ( searching through field0 = CustomerNumber)and then select it, it won't pass the customer number to continue to search field0 in the shipping table for customers that have a # in any of the cell values of the recordset.

Is there a work around for special characters in cell data ie) #

Any sugestions or comments would be greatly appreciated.

View 4 Replies View Related

Reading Data From Spreadsheet

Nov 23, 2004

I have a linked spreadsheet. Access is not pulling certain records from the field DOD. The code I used is as followsSELECT final.[SSN P ], final.TXPD, final.[TC-530], final.[TC-150], final.[ DOD ], final.[ DOB ], final.[SSN S ], final.[TC-421], final.[TC-420], final.[TC-424], final.[TC-540], final.[LFRZ-RFRZ], final.[TC-590], final.[TC-591], final.[TC-594], final.[TC-599], final.[TC-290], final.[TC-291], final.[TC-300], final.[TC-301], final.[TC-976], final.[TC-977]
FROM final
WHERE (((final.[TC-530])="TC-530")) OR (((final.[TC-150])="TC-150")) OR (((final.[ DOD ])="dead")) OR (((final.[ DOB ])>1929 And (final.[ DOB ])<1986)) OR (((final.[SSN S ]) Is Not Null)) OR (((final.[TC-421])="TC-421")) OR (((final.[TC-420])="TC-420")) OR (((final.[TC-424])="TC-424")) OR (((final.[TC-540])="TC-540")) OR (((final.[LFRZ-RFRZ])="-AL")) OR (((final.[TC-590])="TC-590")) OR (((final.[TC-591])="TC-591")) OR (((final.[TC-594])="TC-594")) OR (((final.[TC-599])="TC-599")) OR (((final.[TC-290])="TC-290")) OR (((final.[TC-291])="TC-291")) OR (((final.[TC-300])="TC-300")) OR (((final.[TC-301])="TC-301")) OR (((final.[TC-976])="TC-976")) OR (((final.[TC-977])="TC-977")) OR (((final.[LFRZ-RFRZ])="-ALR")) OR (((final.[LFRZ-RFRZ])="-L")) OR (((final.[LFRZ-RFRZ])="-LBR")) OR (((final.[LFRZ-RFRZ])="-LBRK")) OR (((final.[LFRZ-RFRZ])="-LR")) OR (((final.[LFRZ-RFRZ])="-LRF")) OR (((final.[LFRZ-RFRZ])="-LRKF")) OR (((final.[LFRZ-RFRZ])="-LW")) OR (((final.[LFRZ-RFRZ])="-O")) OR (((final.[LFRZ-RFRZ])="-OLR")) OR (((final.[LFRZ-RFRZ])="-V")) OR (((final.[LFRZ-RFRZ])="-VL")) OR (((final.[LFRZ-RFRZ])="-VW")) OR (((final.[LFRZ-RFRZ])="-W"));


For some reason the DOB and DOD fields are not being recognized. Please help.

View 2 Replies View Related

Reading File Names

Dec 9, 2004

Is there a way for a access to read the filenames of files contained in a folder on the local machine and paste
those filenames in a database field?

View 1 Replies View Related

Reading Values From A SubForm

Jan 4, 2006

Hi guys, Im working on a DatABase at the mo that is heavily featured around forms - the problem is I dont have a clue about how the code side of it is structured in access. I know a lot about visual basic, and I've been having pot shots at how to do this, but with no success...

How do I read the value of an object from a subform with macros? Lets say on my main form I have a textbox called 'ExampleTXT' - to read a value from the text box would be simple...

Code:msgbox Me.ExampleTXT

but on this form I also have a subform, which contains an array of textboxes (they link to a seperate table, so there can be any number of these textboxes) and they have the name 'ExampleARR'. How do I read the values from these? I have tried the following code (like I siad, these are random stabs in the dark) but I have had no success...

Code:msgbox Me.ExampleARR--msgbox Me.ExampleARR(0)--msgbox Me.SubFrm.ExampleARR(0)

PLEASE HELP!

View 3 Replies View Related

Tables :: Fields Not Reading The Same?

Jul 22, 2013

I am very new to Access and I am not a programmer at all. Something in my program changed and I am stuck on how to correct it. When I look at the front end everthing looks fine. When I look at the back end one of my fields are no longer reading correctly. I get the message error code 2465

View 14 Replies View Related

Modules & VBA :: DLookup Only Reading Top Row

Jun 26, 2015

I have a command button on a Access 2010 form that i am using as my switchboard. On this form i have a hidden unbound text box that captures the users environ"username". When the user hits a command button on the form the code looks at the name in the hidden textbox that captures the environ"username" and then DLooks up a table to see if there is a match. If yes then it will open the next form and if not then a message box appears.

Code:
Private Sub Command6_Click()
Dim TxtUsername As String
If Me.TxtUsername = DLookup("[OneLondon Login]", "TblAccessUsers") Then
DoCmd.OpenForm "Bakerloo_Main_Form"
Exit Sub
Else
MsgBox "You do not have permission to access this database"
End If
End Sub

This works fine apart from the fact it will only read the first name entered in the table. This table(TblAccessUsers) could have up to 50 names in it and possibly have names removed and re added at a later date. Is there a way i can get the code to look up every name in the table ??

View 3 Replies View Related

Apply 'save Formatted' To Reading?

Jul 2, 2007

I have a DB with tables where the primary key fields are autoincremented, but with formatting applied.

Formatting is for example "CC"000000 so record 1 will be CC000001.
(each table has a different alpha prefix)

This works fine, except the database content is being read by another application, and it sees only the 1, 2, 3 etc.
Exporting the data to Excel format proves that this is due to Access not the other application.

However, if I export to Excel format, and tick the "Save Formatted" option, the data exported is as I require, CC000001, CC000002 etc.

Is there a setting or way to make Access present the data when it is read by another application to be the 'formatted' version of the data?

View 2 Replies View Related

Problem With Reading Values Between Forms

May 18, 2005

I´m new to to Access databases, so if you experties who write a solution back will keep that in mind :o

I have a mainform "frmBygninger_input" and in that form a combobox "cboParent".

In the mainform is a subformular "ufrmlDFMnøgletal", with a textbox "cboChild"

When I have choosen a value from that "cboParent", I want "cboChild" to read that values from "cboParent"

What is that I have to do?



With greetings :p

Alrun

View 1 Replies View Related

Reading Excel Spreadsheet From Access??

Sep 14, 2004

I am trying to connect to an excel spreadsheet and read it from access. What is the object naming scheme in excel?? I am trying to read "Sheet1" but I am getting an error. My final goal is to export a list of forms and queries list in the excel spreadsheet from one database to another. How do I know if I have "Excel 8.0"?? Here is my code:

Sub ImportForms()
Dim cnn1 As New ADODB.Connection
Dim rst1 As ADODB.Recordset
Dim strExcelPath As String

strExcelPath = "C:ModificationRequest.xls"
'Open and set recordset
cnn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strExcelPath & ";" & _
"Extended Properties=Excel 8.0;"

Set rst1 = New ADODB.Recordset
rst1.CursorType = adOpenKeyset
rst1.LockType = adLockOptimistic
rst1.Open "Sheet1", cnn1, , , adCmdTable

'Open Recordset and print test record
Debug.Print rst1.Fields(0).Value, rst1.Fields(1).Value
'Clean up objects
rst1.Close
Set rst1 = Nothing
cnn1.Close
Set cnn1 = Nothing

End Sub

View 1 Replies View Related

General :: Reading DB File Information?

Sep 29, 2013

I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Any all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs. The only thing I ever see though are files with [.db] as the extension.

If I open the one I have with notepad on a windows machine I see some of the info but some of it is not there and is garbled.

[URL]....

View 4 Replies View Related

Reading Appending To A Table, From A Manipulated Input

Apr 1, 2007

Hi,
I need to grab a record from an input table/record set and de-concatenate it based on the underscore and append each instance to an output table. I know this must be possilbe, we do simular things in GIS programming all the time. Below is my "logic"/psuedo code :)

'loop until end of file
strColumnA = tblNewRelationships.PLACE
strColumnBin = tblNewRelationships.NAMES
'loop until strColumnBout is ""
strColumnBout = Left(strColumnBin, Find("_", strColumnBin, 1) - 1)
strColumnBchop = Right(strColumnBin, Len(strColumnBin) - Len(strColumnBout) - 1)
strSQL = "" 'put strColumnA into tblRelationships_2.PLACE and strColumnBout into tblNewRelationships.NAME
DoCmd.RunSQL strSQL
strColumnBin = strColumnBchop
'end field loop
'end row loop

Any help is seriously appreciated.
Thanks,
C

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved