I want to be able to open a Table as Read Only, so that a user can browse etc., but neither alter nor enter data - I want them to use the Forms for that. How then, using VBA code, do you open a Table as Read Only?
View RepliesWas wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data.
For example in the file attached, the first four characters represent a data like 'ticket number' and maybe the third line 6 to 10 charcaters represent 'name of a passenger'.
Now how do i import these data to a table into respective fields in a table.
I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.
I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?
Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?
I want to "lock" a record in a table so that it is read only and cannot be accessed/edited/deleted. Is it possible to lock a single record in this way on a permanent basis? It's actually the first record in the table.
View 5 Replies View RelatedOK, I tried to see if this was possible but not finding much of an answer. So I figured I'd check with our merry band of experts if it even is.
I'm using Access 2013 and I have a database I would like everyone to be able to see but only those that have a password to be able to change data.
Is there a way to even to do this? A code somewhere maybe?
I've been able to find the option to make the whole database password protected but that's not what I'm looking for.
I have a database with hyperlinks to open word documents on my network. If someone else has that word document open it will ask me if I want to notify or open in read only. However since upgrading to Access 2013, (from Access 2003), this sometimes freezes the database.
I am wandering is there a way to tell Access (or Word) to open the document in read only if there is someone using it already?
I would like to be able to check if a db is open and if it is to prevent the user from proceeding.
I use the Access 2013 Runtime. I can check if a db is open by trying to open Exclusively, using something like
Code: [URL] ....
But if the db is already open Not exclusively and I try to open it exclusively it does not raise an error and it allows the user to open the db in Read Only mode.
I would like to be able to prevent this, because careless and/or inexperienced users may open several instances of the db.
Of course, if the db is already open exclusively it does not allow you to open it exclusively another time.
I have a query that lists all tables within my access database.what i want it to be able to click the table name from the query list.for example my query list is:
Rawdata
Outcomes
Reporter
Tracker
how would I click on Tracker and open in up the tracker table? is it something like
stdocname = "tablename"
docmd.opentable, stdocname, opentable, acnormal , ," [tablename] = " & me.tablename?
I have a query that I dump into a table...via Macro. I made changes in the table (User Input in some fields) ..can I requery and not overwrite the inputs? I am new to Access not sure if this is possible?
View 4 Replies View RelatedI believe I may have asked this question before but…
I have a FE/BE database. Is there a way to set the tables as “read only”? I’d like the FE to be read only, but allow users to see all the tables, not just forms etc. However, if they open the BE, they would have full control.
Thanks,
SKK
Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:
If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF
Any Help Please
Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin,
how can i go about doing this/.
thanks!
can anyone plz tell me how to make a table read only to prevent users from changing the records in the table?
View 2 Replies View RelatedOk, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:
If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF
Any Help Please
I have a Workorder table and a Workorder form. I would like to be able to make a Workorder closed when it is finished so that it is read only. I have a finished date field so maybe by entering a date there could be a way to accomplish this?
View 4 Replies View RelatedI define one Field in Table with 3 different Values form another Table. But now I dont know how to extract that values.
View 4 Replies View RelatedHello! My Small access aplication has a tables appended from dbf database program. I am coping with an issue to set access to this tables as read only.For me its very vital that source dbf application won't be changed from MS Access.Thanks for help!
View 3 Replies View RelatedI have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only.
How do you link to tables accross the network so you can read and writ e to them?
I am new to Access, so bear with me.
I am using Access 2007.
I have 4 tables created, and they are breaking out information for recording files that are being created from a PBX.
The tables are created as thus:
tbl_1
Key:ext_id | extension
tbl_2
Key:loc_id | location
tbl_3
Key:f-type_id | filetype
tbl_4
Key: mass_id | filename | date | loc_id | ext_id | f-type_id
Now I have created the relationships between the tables for the various ID's. My issue is the following:
I will be automating this process, so when the data is imported to the various tables, I need the relevant keys from tbl_1 tbl_2 and tbl_3 to be added to tbl_4 when the new data is brought into the tables.
As to the process of importing the data, I was looking at using PHP to facilitate this. Any ideas, help or direction would be greatly appreciated. I have looked around the net for an idea of how to solve this, but, being so new, I am not exactly sure how to word the question.
Thanks!
Is it possible to create a table link that is read only. I realize that there a a number of work-arounds, but I'm curious about this functionality specifically.
View 3 Replies View RelatedIs there a way to link MS Access tables as "read only" in Access2000?
Thanks,
SKK
Any way in MS Access to read the TOC data from an Audio CD? It is I believe in the lead-in part. I have a music database, and would like to be able to read the track data directly from the CD (Title, artist, timing), without having to type it all in again.
I know this can be done, because my CD labelling software extract the data automatically - but can Access do it?
Hello,
I wasn't sure which area to post this question in...since it involves queries, tables, and forms :)
There is a read-only table in my company's data warehouse that stores a lot of records. I wish to set up a form that will allow users to add or relate data (fields) to each of those records.
Updating the data warehouse table structure is not an option.
How can I best do this...
1. set up my own table somewhere, that will automatically append any new data warehouse records every night, so basically I'll always have a copy of the DW table, but with additional fields that can be updated?
2. set up another table/query that are linked to the DW table via unique identifier...but if I do this, how do I display the DW records alongside the new fields in a way that makes sense? another query? will I be able to write in data in this fashion?
3. ...some other way?
Any assistance will be very much appreciated!
if there's a way to apply a list of items as criteria in the order listed? Say I've got a list of sales reps and I want a macro to run a query repeatedly, populating one rep from the list at a time in a field called Sales Rep.
View 8 Replies View RelatedHi,
I have a query which uses manual input on two fields. I would like to automate this query by pulling the input values from another table.
How do I read the input values from the other table instead of having the users type them in ?
Al
I am interested, is it possible to read currently selected (highlighted) row in table?
I know that this is possible to move cursor on concrete field in table via VBA but is it possible to read record number when we move cursor manually (via arrows)?