Call function from another database

[new_2_prog]

I have a function in the back end of my database that deletes and imports tables from MAS90.

I have a front end where all the queries, forms, reports and links to the back end tables. At times I will need to force the deleting and importing of tables through a command button on a form. I am able to call the function in the back end from the front end, it deletes the tables in the back end like it should but then when it goes to import the tables it does it in the front end.

In the front end I went to Tools, References and found the back end database in order to call the function but why the glitch, is there a better or different way to achieve this?

Thanks!

 

[smig]

back end should hold tables only.
queries, forms, reports AND modules should go into the front end.

you should not delete THE table, only the data in it. this can easily be done from the front end.

 

[new_2_prog]

These tables are from an ERP system that I can not link to the tables they can only be imported that is why I have to delete the table then re-import them, I don't like that fact but that is what I have to do for now.

Is there another way?

 

[smig]

you should not delete THE table, only the data in it
and reimport the data INTO the table (the empty table)

I'm sure the ERP system won't change the structure of it's table, only the data in it.

 

[boblarson]

you should not delete THE table, only the data in it
and reimport the data INTO the table (the empty table)

I'm sure the ERP system won't change the structure of it's table, only the data in it.

A big AMEN to that! I totally agree with both of those statements.

 

[new_2_prog]

If I delete the data out of say tbl_Customer and then import again I get tbl_Customer1, it doesn't update the original table I deleted data out of.

 

[smig]

when you import you can choose if you import as new table or into an existing one.put your import code her so we can help

this line of code will import the Excel ImportFileName file INTO tblToUpdate

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, tblToUpdate, ImportFileName, False