Find Jobs
Hire Freelancers

Access DB to update data in a table including audit trail

$100-500 USD

Terminado
Publicado hace alrededor de 13 años

$100-500 USD

Pagado a la entrega
Need an access DB having one table which can be edited grid view or detail view. Each change must be logged in an audit trail (user, datetime, field, old value, new value). Audit trail must be shown in the "detail view" for information for the currently edited record. As I want a user it must be possible to log-in with a password. So I need an admin user to administer the users. I need the DB protected (as good as possible but not total paranoia). I will need two more tables for code values that I can extend as need. I do not need a form for this but a separate table. Also I do not need a form for the users. I can edit tables this is ok. I work on Access DB 2007 but because my end-client only has 2003 it need to work on both (hence you produce a 2003 mdb). ## Deliverables The fields I need in the main table (call the main table "BM") - ext_ID Textfield 10 (Unique Key). Field can be changed but if user tries to change it a warning should pop up (except for new entries). - XML_Name Textfield 200 - XML_Category Combo Box values 1,2,3,4,5 plus a text I want to choose for the moment use text1,text2 etc. I will change myself when it is done - XML_Imp Numeric Value - XML_LID Numeric Value - XML_OL Boolean - XML_Street Text 200 - XML_City Text 200 - XML_Postal_Code Text 10 - XML_Telephone Text 200 - XML_Hours Text 200 - XML_Latitude Numeric with highest possible precision - XML_Longitude Numeric with highest possible precision - ST1 Text 200 - ST2 Text 200 - ST3 Text 200 - ST4 Text 200 - ST5 Text 200 I know this 5 fields are not normalized but we want it like this. - Record_Deleted Boolean (Delete must not be allowed, only flag as deleted) is a checkbox - Delete Reason Combo Box Values 1,2,3 - If Record_Deleted is flagged this field becomes mandatory otherwise it must be empty. Needs to show the code value and text. The text I will enter for the moment do del1, del2, del3 Following fields are shown in the form but must be protected (not editable, except when adding, this constraint is only true for the form not in the DB in general): - date_added timestamp (each record added needs to get this) - filedate timestamp - ext_company text 200 - ext_address text 200 - ext_zip text 10 - ext_city text 200 - ext_entrance text 200 - ext_betreiber_item7 text 200 - ext_zip2_item8 text 10 - ext_address2_item9 text 200 - ext_bankname_item10 text 200 - ext_dcc_aktiviert_item11 text 1 - ext_ms_erlaubt_item12 text 1
ID del proyecto: 3175838

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 13 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$153 USD en 4 días
5,0 (21 comentarios)
4,2
4,2
2 freelancers están ofertando un promedio de $308 USD por este trabajo
Avatar del usuario
See private message.
$463,25 USD en 4 días
4,8 (25 comentarios)
4,7
4,7

Sobre este cliente

Bandera de GERMANY
Stuttgart, Germany
5,0
32
Forma de pago verificada
Miembro desde jul 8, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.