When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.You can select multiple tables by holding down the Update Query from the popup menu. Ole Db Command("DELETE * FROM [Catlog]", Access Conn) Access Command. Command Text = "INSERT INTO [Table1] SELECT * FROM [MS Access; DATABASE=C:\Test Files\database.mdb;].[Table1]" Access Command. Close() Sub Update Public Database() Dim con As Object Set con = Create Object("ADODB. Print "Done." Exit Sub Update Public Database_Open Error: Debug. Quitting." Exit Sub End Sub Your solution appears to be sound. Print "Completed" Exit Label: Exit Sub Error Label: Debug. This is simplified version without my special-case when_not_to_copy_based_on_month_and_day rules. Add("tbl_data5") ' ..tablenames Set con = Create Object("ADODB. Connection String = "Driver=;" & _ "Dbq=C:\data\DESTDB.accdb;" & _ "Exclusive=1;" & _ "Uid=;" & _ "Pwd=;" con. The Enterprise Services BI team (ESBI) provides a unified reporting platform for over 20,000 Premier Support and Microsoft Consulting Services (MCS) resources.ESBI helps Premier Support and MCS build credible relationships with customers by providing consultants in the field with critical, real-time data about customers’ product and services purchases, transactions, accounts, billing, usage, compliance, issues, and risks.
Connection") On Error Go To Update Public Database_Open Error con. We're still in the dark ages at work (A2003) so I'm not sure about this; is there no locking file in A2007?
In the following procedure, you set up a new database and then use the Table Wizard to build the first table in the database.
If you have Power Point slides that report regularly updated financial or numeric data that comes from an Excel spreadsheet, you can save a lot of time by linking the data instead of retyping it.
Drag the corner handles to make the table as large as you want it to be.
I have an Access 2007 database on my local PC, and another one out on the network. Not all table data should be copied each time this function is run.