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 SkipVought 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
0
0
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
287
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
137
Moss100
Moss100
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
139
Moss100
Moss100
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
69
MattGreer
MattGreer
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
74
Dan Stoica
Dan Stoica

Part and Inventory Search

Sponsor

Back
Top