Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

force unlock DB

Status
Not open for further replies.
micky500970

micky500970

Programmer
Jul 9, 2004
81
0
0
GB


I have created a program to back up our Access DB at 20:00 and 7:00. The only problem is that if somebody has left their computer logged in while the access program is open my program does not back it up.(this is how I want it)

Is there a way to force an unlock of the DB using VB.

If fso.FileExists("d:\db1.ldb") and time <7:00 and > 20:00 Then force unlock DB else goto blah

Thanks in advance

Mick
 
Status
Not open for further replies.

Similar threads

mjassalina
  • Locked
  • Question
Force closed when saving Userform Excel VBA 1
Replies
2
Views
72
mjassalina
mjassalina
2009luca
  • Locked
  • Question
Old project vb6. Colorize RAW of Dbgrid, possibile?
Replies
4
Views
83
sal21
sal21
madsstiig
  • Locked
  • Question
Linking DBs in CR 11
Replies
2
Views
46
madsstiig
madsstiig
VicM
  • Locked
  • Question
Enter formula in Excel cell from Access DB code, copy down, then replace original col with mod data
Replies
3
Views
36
VicM
VicM
Andrzejek
  • Locked
  • Question
Show DB data in MaksEdBox
Replies
6
Views
50
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top