WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

database exclusive used

 
   Home -> Office -> Query DAO RSS
Next:  Query DAO: Database query  
Author Message
Souris

External


Since: Mar 26, 2005
Posts: 20



(Msg. 1) Posted: Mon Jan 07, 2008 11:18 am
Post subject: database exclusive used Add to elertz
Archived from groups: microsoft>public>excel>querydao (more info?)

Set A = CreateObject("Access.Application")
A.Visible = False
A.OpenCurrentDatabase (C:\MyDatabase\MyDatabase/mdb")

strMYSQL = "INSERT INTO tblLOG (MyField1) Values " & _
"(" & Mycontrol.Value & ")"


A.DoCmd.runSQL strMYSQL
A.Application.Quit
Set A = Nothing

My Excel application has a update log function. It works, but I got database
exclusive uses message.

It seems that the database locked by first uses. I close and quit the
application.

Can you please help me how to close and unlock the database using VBA?

Your information is great appreciated,
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Query DAO All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET