473,401 Members | 2,068 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

Delete all MS Access Objects

Is there a way to delete all Access objects(tables, queries, forms, etc) using vba?
Dec 20 '10 #1
1 2096
Stewart Ross
2,545 Expert Mod 2GB
It is of course possible to delete items from tabledef, querydef collections and so on. I see no legitimate use of such techniques to remove all tables, forms etc in an Access database.

Even if the circumstances related to a trial database it would be ill-advised to remove tables populated by users, as the data belongs to the user, not to the developer.

We cannot post code which could be used to damage or destroy an Access database for what must surely be malicious purposes, and to prevent further attempts to do so I am closing this thread.

-Stewart
Dec 20 '10 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Curry Snigger | last post by:
Good-day to all, i would like to know if there is any way to use MS Access Objects (i.e. class modules) from Visual Basic 6.0. For example, if i had a class in MS Access such as follows ... ...
3
by: oskar hritz | last post by:
It may sound stupid but I have not found any person able to make multiple deleting of objects in Access 2000. I would like for example to delete all queries (I have 200 of them) and download them...
3
by: Ellen Manning | last post by:
Using A2K. I need syntax to delete all objects from a database other than tables, like with a FOR...LOOP construct. I researched the newsgroup and found suggestions to look thru Access help on...
1
by: Krishnan Thodla | last post by:
How do I enumerate MS Access objects (Forms, reports, macros, modules, tables, queries) from C#? TIA
2
by: Bob | last post by:
How do I program vb.net to copy a query or table from one MS Access database to another? I'd like to accomplish what import does when it copies Access objects (primarily queries but some tables)...
0
by: Olivier Salzgeber | last post by:
Hello everybody I have an application which is grouped in a MainApplication and several Modules (DLL's) The Main Application is basically a Form with a NavigationBar on the Left Side (like in...
5
by: dananrg | last post by:
In PythonWin, is there any way to bulk-delete all objects without using "del object" for each, and without having to exit out of PythonWin?
5
by: i.c.code | last post by:
maybe like: #include "boost/function.hpp" template <typename T> class Do_When_Return { private: Do_When_Return(const Do_When_Return&); Do_When_Return();
6
by: nembo kid | last post by:
I have these classes: Boss, CommissionWorker, PieceWorker, HourlyWorker all directly derived from Employeer. I create a dynamic object (on heap) for each class:
2
by: Mourad | last post by:
I would like to know how to delete one or more database objects programmatically. For example, delete all forms, or all reports, ...etc. I'm using Access 2003 Thanks, Mourad
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.