Hello! 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!
how can i make a custom counter in a table where records are appended from another table.
i have already used custom counter method in my database before by using this technique.
[URL]
but i want to make counter in a appended table.
I 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
I appended multiple tables to one table by using the copy, paste, append data to existing table. I now have 1,691 line items in one table. However, when I run a report off this new table and export it into Excel I only receive 1,300 line items.
View 3 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
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 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 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 14 Replies View RelatedHi,
I hope someone can help.
I have a macro that appends and deletes records to a new table once the the record has been closed. I need to record the date this was done in my original table and the new table and have had brain freeze as to how to achieve this.
Any suggestions??
Hi,
I have a form that runs a parameter query to search for university name and then displays 2 fields, university name and course name.
I am having difficulty with a search button that i have on the form called search_command; it is supposed to run the exact query as when you enter the form, it does this but displays the result in a dataheet, i want it to repopulate my 2 text label fields as mentioned above.
In addition i want then to be able to go to a specific record, select it and then press a button to append it to another table. i ahve not started this part yet
Can anyone please help ?
I have a database that is used by managers to log activity of staff. We wanted to allow staff to write to the DB, but not allow them full access. We decided to accomplish this by adding a VBA function to an Excel sheet that they already use every day. It allows them to select a description, start time and end time and writes records to a database containing just 1 table.
The database used by the managers periodically runs an append query, and then a delete query to update with details of entries made by staff, and then clear the table to avoid duplicates during the next append.
I'm sure those of you with experience can already guess what's been happening and are shaking your head right now. It seems like entries made while the append query is running are being deleted when the delete query runs. So potentially I append 4 records, but delete 6 as 2 new entries were made before the delete query ran.
Is there a way to delete only the records that have just been appended? Or is there a more acceptable way of achieving this without using a delete query?
After running an append query, the form created displays a blank/new record. How can I make the form display and ready to edit the appended record.
View 3 Replies View RelatedI 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!
Was 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 have an append query that appends records to a table, and I have a form based on that table.
Users will click a button that will run the append query and then open a form for users to fill in remaining empty cells. How can I filter the form to show only the newly appended records?
My Access database is situated in a folder which has permissions to only let some people write into it.
The problem is that we would like users with read access to open the database to view but get the following error:
Couldnt use ...path... File already in use.
The database always has more than one user in it so this may be the root of the error message.
Solutions which cannot be implemented are moving the DB to a higher folder or giving write access to this folder to the read-only users.
Thanks in advance for any ideas.
Hello All,
I have a ASP Page which reads data from an Access database. I Have and Access Database and a Excel Spreadsheet. The spreadsheet contains all of the up to date data whilst the Access Database contains old data. Is there a way that i can get Access to Update its data with the data from the Spreadsheet? As the spreadsheet is updated all of the time. I do not have much knowledge in Access.
Regards
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 RelatedI am using windows XP SP2, Office 2003.
I have created a database to store information from a mine site. I have set up a switch board and most users will just view reports or graphs that have already been designed.
I want the general users to open the file read only without having to open access and use the open read only command. I also don't want to go down the path of database security if it can be helped.
I read in the help page that there is a read only prompt that can be flashed up when the file is opened. Unfortunatly the help page suggests, Tools > Options > Security Tab (tick read only prompt). In office 2003 this option no longer exists (if it ever did)
Any ideas, would be good if i could add something to the shortcut and then have some uses use this shortcut.
Thankyou
I want to make an Access database of my collection of antique swords that I can put on a CD. This DB would also include as many as 5 digital images for each record.
Some of my friends may not have Access 2007 on their PC. Is there a viewer that I can put on the CD with my database so they can view it without them having to buy the Access program??
hi,
my question is:
in access, how can I read data from two different tables and show the result in another table? in details:
i have two tables named hydraulics and mechanics. i want to read the data "reliablility" from table "hydraulics" and "reliablility" from "mechanics". and then i want to multiply these values and show in a newly created table as "results".
thanks for visiting and answering.
p.s: my file is attached, everything in german, sorry.