Read/Write in a Query

[TMorrison]

I have a Query that combines the columns that I need to access in a form from 2 different tables; one is local to the system and I can change any value in it, the other table comes from an online database and only has read privileges. When I make the query I can't edit any of the columns that come from the table that I have write privileges to. Is there a way that I can edit just these values? I don't need to change the read only table.

Thanks,
Tim

[JConsulting]

I have a Query that combines the columns that I need to access in a form from 2 different tables; one is local to the system and I can change any value in it, the other table comes from an online database and only has read privileges. When I make the query I can't edit any of the columns that come from the table that I have write privileges to. Is there a way that I can edit just these values? I don't need to change the read only table.

Thanks,
Tim

Hi Tim,
There's a couple of approaches to take here. You'll have to choose which works best for you.

Separate your form into a form/subform...or main form and 2 subforms. Since we haven't been told how the records interlace, you may be able to arrange the fields so that they can sit side by side, then you can update one subform...and just create a dynamic link to the read only one so that the records still coincide.

Another option is to use DLookup and VBA to populate the Read Only fields, and set them to Locked on your form. The current record ID is used I assume to link your tables, so it would be used as the key to looking up the REad Only Data.

The other option is to create a "temp" table from the linked table so that it's local to your database. Not sure how often you might want to refresh it..maybe when the form opens? However, it can be cleared out once the form closes.

Let us know what you think...and we'll help you further.

J

[TMorrison]

Thank you for the response, sorry I haven't been around to reply to you sooner. This project of mine got put on hold and ended up getting redefined a little. Unfortunately I have no Access experience, and no one on my team really knows how to program in it either.

Here's what I need it to do: I have an online database that will periodically have new entries added to it, I figured out how to get this data into a table but you can only have read privileges for it. The trick with this is that I want to be able to add extra info that will be kept offline, and I also want to be able to add a new entry even if I don't have access to the online database. The way I was thinking about doing this is to create a new table and have the online database table copy over to this if the entry doesn't already exist (each entry will have a specific case number so you'd only need to check if that number is in the table).

Problem is I have absolutely no idea how to do that. I've been trying to go through some online tutorials of Access but they don't seem to be helping me much. Could you possibly help me out with this, or at least give me a starting point? I'd appreciate any help offered.


Thanks,
Tim