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 strongm 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
Feb 5, 2004
69
US
How can I check whether a table already exist in the current mdb?
 
Sort by date Sort by votes
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

Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
435
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
272
Moss100
Moss100
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
227
Moss100
Moss100
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
148
MattGreer
MattGreer
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
191
Dan Stoica
Dan Stoica

Part and Inventory Search

Sponsor

Back
Top