there is not much more to explain. You need to search this forum or a search engine on how to access, Accesses hidden databases. Then you need to figure out where in those tables you find existing user tables and write a query to check if it exists.
So, first to check what tables DO Exist something like:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));
Then if the output table contains the name you want to create it alreadt exists otherwise it does not... It's much simpler in SQL Server and there may be a better way in Access but don't know of it.
Topic Options
Post Options
Thanks(0)
