Update database from network

[RAMESHCPDCL]

How to update the back end database from network front end.

[AlexHedley]

What are you wanting to update?

[June7]

Not much info.

Presume you have links to backend tables and have forms for data entry/edit. So as Alex asked, what do you need to 'update'?

[RAMESHCPDCL]

Thank you for your response.

I have an application in ms access. now it is restricted to one desktop.
i have intranet and i want to use this different users to update database.
i may take the reports against those users updation data.
thank you

[AlexHedley]

So are you going to distribute a FE to other users/machines?

Are you wanting to link to the db using a webpage? (Mention of intranet)

Are you already tracking/logging usage using an Audit Table within the db or is that something you need to know how to do?

[RAMESHCPDCL]

Thank you
Obviously you catch my point. But i am not using webpage.
After post the thread i have liked the tables through menu Database Tools ----> Linked Table Manager.
When this has done i used form to update data base, Enter new Record button i used it shows error not available now.
why?

[AlexHedley]

Can you open the BE db without errors?

[RAMESHCPDCL]

YES.
I am going to take reports from all branches by consolidating or branch wise analysys etc.

[AlexHedley]

Is the 'Enter New Record' button a Macro or VBA?
What does it actually do?
Do any others update buttons work?

[RAMESHCPDCL]

many many thanks u r in right approachI am using Enter new record button directly available in access not using macro or VBA I thin it may not possible without using MACRO OR VBA to update DB from FE.is it correct ?

[AlexHedley]

I'm not quite sure what you mean.

So you are clicking on the >* in the Record Selectors at the bottom of the Form (Navigation) to go to a New Record and typing in your data into a blank Form?

[June7]

It is certainly possible to update BE from FE without use of code. FE links to BE tables. Forms bound to table links. Controls on form bound to fields. Entry/edit of data passes directly to table record.

If you want to provide db for analysis, follow instructions at bottom of my post. Identify object involved.