How to find table in Access databse???
-
Hi all... I want to find whether a table exists in Access Database or not. I know how to do it in MS SQL Server, we can see the result using Select query from sysobjects table and we have the list of all Tables, SPs, Views, functions...etc. But if my program gets .mdb file i.e. Access Database, my program must find whether a perticular table is created in that database or not. Is there any way to do it??? Thanx in advance....:)
-
Hi all... I want to find whether a table exists in Access Database or not. I know how to do it in MS SQL Server, we can see the result using Select query from sysobjects table and we have the list of all Tables, SPs, Views, functions...etc. But if my program gets .mdb file i.e. Access Database, my program must find whether a perticular table is created in that database or not. Is there any way to do it??? Thanx in advance....:)
Rohan_bhat_31 wrote:
want to find whether a table exists in Access Database or not.
Try this. SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name = "tbl_name"
DEBUGGING : Removing the needles from the haystack.
-
Rohan_bhat_31 wrote:
want to find whether a table exists in Access Database or not.
Try this. SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name = "tbl_name"
DEBUGGING : Removing the needles from the haystack.
Hey..thanx buddy.... but where this table is stored??? and there must be some log files also generated behind the scene...like SQL Server...???:doh: looking 4ward 2 see ur reply...
-
Hey..thanx buddy.... but where this table is stored??? and there must be some log files also generated behind the scene...like SQL Server...???:doh: looking 4ward 2 see ur reply...
Rohan_bhat_31 wrote:
but where this table is stored??? and there must be some log files also generated behind the scene...like SQL Server...???
Access is completely different than SQL Server. An Access database is basically a binary file, so there is no real "table". There are no log files. No transaction nothing. I guess the question becomes what are you attempting to do?
DEBUGGING : Removing the needles from the haystack.