Almost there
My next problem is not all the SQL tables I link to ask me to choose the unique record identifier. On the tables that it prompts me to choose the unique record identifier I don't choose one and this makes the table read-only.
A few of the tables I link to its doesn't prompt me and...
I have linked a SQL table to my ms access database. In order to view the SQL table as read-only and still be able to update the access table I have setup a form with a subform.
I know it would be a dublication of data but is there a way thru code of copying the data on the subform to my...
Thanks jmurphy. IT WORKS!!
Linking the subform worked, I'm able to update my tables and have the SQL tables as read-only. I just need to work on how to make the subform look better, but that shouldn't be a problem.
Here is another way of trying to explain what I'm after
I'm trying to link my accounting software to an access database. I have linked the table, which seems to work fine. My problem is I want the table from the accounting program to be read-only. I don't want to corrupt the raw data by...
yes the users have access to a form I have built in which they enter salesperson's commissions. There is really 2 parts to my MS access database.
1. Tables/Forms and Reports that I have built in access that I want the user to have permission to add/delete or change.
2. A linked table that...
I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for...