Solved

Delete database ???

Posted on 1998-07-14
3
130 Views
Last Modified: 2010-05-03
How do i delete a .mdb file which has record locking infomation file  .ldb ???

0
Comment
Question by:netcool
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
web_crusher earned 10 total points
Comment Utility
no need to relate to the ldb
the way to delete mdb is:

data1.recordset.movefirst
do until not data1.recordset.eof
  data1.recordset.delete
  data1.recordset.movenext
loop
0
 
LVL 5

Author Comment

by:netcool
Comment Utility
Web_crusher,

Rearding your example it is to delete records right ? WHat if i want to delete th whole database file ...=>northwind.mdb


netcool
0
 
LVL 1

Expert Comment

by:web_crusher
Comment Utility
if u want to delete a file no matter the extansion use
kill(filename)

IF YOU just want to reset the mdb - open all tables as u seen before and do the
same procedure to all tables!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now