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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by HowAboutThis
-
HOW TOP COPY TABLE FROM UNPROTECTED DATABASE INTO PROTECTED DATABASE?
Here is the DAO snippet you are looking for. MySql = "Select * INTO [;database=C:\SOURCE\DB2.mdb;pwd=mypassword].[Table2] From [Table1];" 'MyDB1 is an open database connection to DB1 MyDB1.execute mysql, dbfailonerror You can also use this same technique to join tables across different databases.- HowAboutThis
- Post #8
- Forum: Microsoft: Access Tables and Relationships
