refreshing the Database

Question

Hi there I have connected my program to a MS Access database and i have added into the database in the 3rd form..And i have a timer in the first form that compares the data in the database with the system's timeeach and every second.Hence the timer runs every minute... the problem now is that the timer do not include my new data that i have added in the 3rd form Can any one please hepl me?

Abhimanyu K Vatsa · Answer

very confusing question? refine your question first to get right answer.

rusdy rip · Answer

i think i have same problem with him but if using timer or button i can show updated database on datagrid. the problem is when A is viewing database from datagrid. then B inserting a new data to database. A still looking datagrid from database before updated if he don't click refresh or using timer how can the datagrid automatically refresh the data from database without using button or timer. i don't like using timer cause it eat resources a lot. thx sorry bad english

Vijaya Kadiyala · Answer

Hi I mean are you using any Commit or Rollback?? Thanks -- Vijaya Kaidyala www.DotNetVJ.com

Sriram Ramani · Answer

are you issuing any transaction properties when you are inserting data from 3rd form?? I cant understand wat u mean sir.

Vijaya Kadiyala · Answer

Hi It is not reading those datails.. means you are querying the database but you are not seeing the chages made in Form3. One quick question..are you issuing any transaction properties when you are inserting data from 3rd form?? Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Sriram Ramani · Answer

Here's wat i mean I have a timer(interval 1 minute) in my program's 1st form that compares the current time with the date in my databese each minute and plays an audio file if they match. Now i have an insert command to insert into the database in 3rd form.So the problem now is that when the timer finishing running for 1 minute and then starts the next 1 minuteit must also read the data that i have added from the 3rd form... It is not reading those datails i have checked it...Is it more explanatory Please anyone help me

Vijaya Kadiyala · Answer

Hi Your question is little confusing. Could u please walk-us-thru with some example. Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com