Update queries in Front-End file?

[TerraEarth]

I was wondering if it is possible to update a backend's tables via an update-query on linked tables in a front-end file; and if so, if there are any ramifications that should be taken into consideration before doing such?



If the answer to the above is yes, how would you go about restricting users from doing such things with their front-end copies?

[pbaldy]

Update data or structure? Both are possible. I give users the runtime version of Access, which would at least make it harder for them to create a query (I'd say they can't, but I'm sure there's probably a way). It the rare user that would even know how to write a query, particularly one that changes structure.

[TerraEarth]

Update data or structure? Both are possible. I give users the runtime version of Access, which would at least make it harder for them to create a query (I'd say they can't, but I'm sure there's probably a way). It the rare user that would even know how to write a query, particularly one that changes structure.

Data! How would you write the query for such a thing? Exact same way as you would if the tables existed in the file itself? Does there need to be a distinction somewhere, that designates the linked table in the front end as a -linked table-?

[pbaldy]

Yes, same way. Local or linked tables, the query doesn't care, it just uses the table name either way:

UPDATE TableName SET...

You can't have a local table and a linked table with the same name.

[TerraEarth]

Yes, same way. Local or linked tables, the query doesn't care, it just uses the table name either way:

UPDATE TableName SET...

You can't have a local table and a linked table with the same name.

I am actually incredibly surprised that Microsoft implemented this feature on their front-end files. What in the world?

[pbaldy]

I'm not; I think I'd be upset if they took it away. It's a common method of updating data in production apps. You typically wouldn't want users creating their own, but that's on the developer. I'd say the vast majority of users wouldn't even know what an update query was, and certainly couldn't create one.