Refreshing Tables Collection In An Access Project

H

Howard Brody

I have an Access project in which I use stored procedures to programatically
create tables. My problem is the tables can't be used until the database is
refreshed and I can't find the syntax - in SQL or VBA - to do this.

It's easy in a database - append them to the database's tables collection -
but a project (CurrentProject) doesn't support the same methods that a
database (CurrentDb) does so I can't use this code/method.

Does any have any suggestions?

Thanks!

Howard
 
Top