How to store data in Separate Table or...

[Dragon108]

Hello

I have many tables for my application, and one table in whic I want to store
data. Is ther a way to make something that user can enter data in form which
is not conected to main table. I have relations set, and I want to make
something to store data in main table with one click on a button.
Actually I need that my user can enter data but he cannot delete or modify
old data. Only admin can change data or delete it. I'm confused. Please
help. THNX

Darie

 

[Tim Ferguson]

I have many tables for my application, and one table in whic I want to
store data.

What are you doing with all the other table then?

Is ther a way to make something that user can enter data
in form which is not conected to main table. I have relations set, and
I want to make something to store data in main table with one click on
a button.

Ummm: I am not quite sure what to make of this, except the usual advice
about one job = one form, and always to base forms on queries not tables.
But this question is so vague, I don't know how to be more help.

Actually I need that my user can enter data but he cannot
delete or modify old data. Only admin can change data or delete it.

If you are really severe about this, let the user add records to a
temporary table (so he can go back and correct errors within a batch or
session, for example). Remove all User permissions from the real table, but
provide an Append query that will transfer records from the temp table to
the real table WITH OWNER ACCESS option. It would be up to you to handle
any duplicates with existing records - the user does not want to know that
the last three hours work was all errors!

If you need a less secure method, you can simply set the form DataEntry
=True and hope the user never bothers to read the help files.

Hope that helps


Tim F

 

[Dragon108]

THNX this helped

The simplest way to do this is to set the Allow Additions property of
the form to True, and the Allow Edits property to False. Having many
tables for the same data is probably not a good idea! You really want
to avoid storing data redundantly.