check table/query exist help - ASP / Active Server Pages

Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??

Jul 19 '05 #1

Subscribe Reply

3733

Bob Barrows

g wrote:

Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??

You can use ADOX:
http://www.aspfaq.com/show.asp?id=2178
http://www.aspfaq.com/show.asp?id=2350
http://www.aspfaq.com/show.asp?id=2037

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 19 '05 #2

the examples u show me are only tables.....how about queries in my database

Bob Barrows wrote:

g wrote:
Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??

You can use ADOX:
http://www.aspfaq.com/show.asp?id=2178
http://www.aspfaq.com/show.asp?id=2350
http://www.aspfaq.com/show.asp?id=2037

HTH,
Bob Barrows

Jul 19 '05 #3

Bob Barrows

g wrote:

the examples u show me are only tables.....how about queries in my
database

:-)
Well, you do need to do some research on your own ... a simple Google search
for ADOX and query (better yet, go to the source:
msdn.microsoft. com/library ) ...

In ADOX, saved queries show up as either stored procedures or views,
depending on what they do. You will find plenty of examples at msdn to get
you going.

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 19 '05 #4

Thanks alot... i finally found a solution ....Thanks again

Bob Barrows wrote:

g wrote:
the examples u show me are only tables.....how about queries in my
database

:-)
Well, you do need to do some research on your own ... a simple Google search
for ADOX and query (better yet, go to the source:
msdn.microsoft. com/library ) ...

In ADOX, saved queries show up as either stored procedures or views,
depending on what they do. You will find plenty of examples at msdn to get
you going.

HTH,
Bob Barrows

Jul 19 '05 #5

Similar topics

10163

query to check if a certain value does exist in a field

by: | last post by:

If I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?

ASP / Active Server Pages

11860

How can I check if a Database Table exists?

by: Jonathan | last post by:

I am looking for a simple way to check if a database table exists. I keep getting advice to use "Try.. Catch" and other error handling methods, but I obviously don't want to have to display an error message and stop the process every time someone loads the script after the table is created because that would mean the page could only ever run once which of course not the solution I was looking for. I simply want to know how I can check...

ASP / Active Server Pages

17899

how to check does some database exist ?

by: adam | last post by:

hello What query shoul I send to SQL serwer ( in transact SQL language ) to check does some database exist on serwer ? It similar to problem "does some table exist in database" - resolve to it is query: use db_silnik IF EXISTS (SELECT * FROM prad) PRINT 'table exist'

Microsoft SQL Server

2858

Access 2003: Request help on pivot table query

by: Alan Lane | last post by:

Hello world: I'm including both code and examples of query output. I appologize if that makes this message longer than it should be. Anyway, I need to change the query below into a pivot table query. I'm having trouble doing it. Help! Here is my code so far: Sub OldRegionQuery()

Microsoft Access / VBA

21927

How to check Eof in VB.Net ?

by: ItsMe | last post by:

Hi, I want to check whether the record exist or not based on my query, so i'll be using OleDbCommand. What is the best way to check on a huge table ? I used to write like this in VB6.0... --------------------------------------------------- Public Function SaveOrUpdate() As Boolean sSQL = "SELECT * FROM AdmAllergy WHERE " & _

Visual Basic .NET

2589

Efficient Uniqueness Check

by: Alan Little | last post by:

I have affiliates submitting batches of anywhere from 10 to several hundred orders. Each order in the batch must include an order ID, originated by the affiliate, which must be unique across all orders in all batches ever submitted by that affiliate. I'm trying to figure out the most efficient way to check the uniqueness of the order ID. Order data is being submitted to Zen Cart, and also stored in custom tables. I have created a unique...

PHP

2152

how to check existance of a table in sql server?

by: Dan | last post by:

Hello, we have an intranet application using Windows Integrated Authentification. When an user starts the application, he gets a form for inputting data. The first time he does that, the application creates in a specific database a table with the name of his account (read with Request.ServerVariables("remote_user") and creates in that table the records he enters. From the second time the user starts the application, still the same form...

ASP.NET

6673

SQL query failed: "Table doesn't exist."

by: kilo | last post by:

Hey.. I need someone hwo can help me making my sql table.. I have no php skills. I have payed for a php program that shoud make dictation for people that have some problems reading danish.. with sound and text.. When I'm making the dictation with PHP I'm getting an error like this.: Query failed (SELECT word FROM repository): Table 'test_dig_dk.repository' doesn't exist the first one of the php, that I soud use for makeing the text is.. ...

PHP

2641

Check if table exits before delete query

by: Dan2kx | last post by:

Hello, me again i am creating tables (and deleting them) based on the Public variable StaffID the reason for this is the information used in these tables is used to display staffing information and needs to be viewable on multiple terminals, so i am creating the tables with " & LogStaffID & " infront of the table/query name, but as to not clutter up the database i am deleting the tables on unload of the form, but to avoid errors i wonder if...

Microsoft Access / VBA

9515

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10426

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9993

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9029

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7537

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6776

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5558

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3713

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2913

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General