MS access content change notification

MS access content change notification

• John Bailey

  Yes, that's a simple data import function with the Studio Console Manager. I'think noticed the SQLE version doesn't import as one of it's task, but tour database could easily be imported by someone who has SQL 2005. Once that's done you'll have full capabilities to do queries, write stored procedures and then to have your process notified.

  
  
  

• Kumm

  when there are more than 2 users accessing the database, if one user change the content of the database, a notification is required to inform the other users and the content will be updated.
  
  

• Leo H

  thank you.That mean it is impossible to implement it in the access database whatever I do,right
  

• aspfun

  So is there anyway to accomplish it that does not utilize the function of access
  

• Morten Nielsen

  If may be mistaken, but I believe that's one of the things that Access doesn't do. However, SQL Express has triggers and it's implementable in SQLE.

  
  
  

• kaimerachin

  Noting is impossible. At a minimun you need interpocess communications and that's something people don;t do alot in VB anyway. I think you'd be well advised to think about SQL.

  
  
  

• AndrewSeven

  I think you need to carefully describe the scenario including who is reading and who is writing so the question can be answered.

  
  
  

• LORDTEK

  yup I am using access database. As you said before, SQLE is inside the SQL express. That means I need to change database from access to SQL
  

• blackpenny15

   

  If I understand you correctly, you are using an access database, which is not the same as  Access itself.

  If I had multiple users like you do, I'd run, not walk to import your data to SQLE with advanced services. With SQLE you can define trigger conditions that will notify your process and cause a process update to occur. It's complicated but to be honest, I think you will need it.

  
  
  
• MS access content change notification