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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check if table exist

Status
Not open for further replies.
gundie

gundie

Programmer
Joined
Feb 5, 2004
Messages
69
Location
US
How can I check whether a table already exist in the current mdb?
 
Sort by date Sort by votes
You can use DlookUp on MSysObjects.
 
Upvote 0 Downvote
Didn't know we can use dlookup in msysobjects. Works perfectly! Thanks, Remou!
 
Upvote 0 Downvote
It is 'not supported' but has turned up in the last few issues of Access, so a lot of people use it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Helpful tip Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
879
strongm
strongm
Moss100
  • Locked
  • Question Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
2K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Vba adding record to table when field is integer
Replies
8
Views
885
Moss100
Moss100
Moss100
  • Locked
  • Question Question
Add multiple contacts to outlook - from access table
Replies
12
Views
1K
Moss100
Moss100
btamsgn
  • Locked
  • Question Question
How to add lines from textbox to table
Replies
8
Views
795
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top