Prevent User from editing record directly in the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I have an application connected to SQL via ODBC.
When I link the tables, user can open the table and edit the records
directly without using the form.
Is there any trick to prevent it happen?

Rgds,
Agus Budianto
 
Agus,

No tricks required, just routine programming. You would need to use the
Access user interface objects to do this (i.e. forms, subforms, queries,
menus, submenus, etc). So essentially, the first basic step is to create
forms, menus, submenus for your application. These objects would be the ONLY
interface between users and the tables. You can design your Access database
so that users go directly to menus, and menus will determine which forms the
users will be presented with. No user will be able to see tables directly.

As you can see, your seemingly simple question is actually a fundamental
question in application building. Basically, what I'm saying is the answer
to your question is really what access user interface programming is all
about (i.e. desining a form, binding a query/recordset to a form, validating
user data entry, designing menu/submenu system so that users can manuever
through your application). There are plenty of books and website references
that cover this topic.

Post back if you need further help.


HTH,
Immanuel Sibero


PS. are you Indonesian?
 
Back
Top