I am using the Do.cmd TransferDatabase command in a split Access 97 database to copy a single table to another database. I trigger the command from a button on a form. What is happening is that the front-end link is being exported not the actual back data so if I email the exported item or copy it to a zip drive I cannot actually open it as what I am trying to open is a broken link.
My current command is:
Docmd TransferDatabase, acExport, "Microsoft Access", "C:\My Docs\MyDatabaseFolder\MyDataName.mdb", acTable, "tbl ErrorLog", "tbl EventLog"
where tbl ErrorLog is the table I am trying to copy over and rename as tbl EventLog.
How do I make the reference to 'tbl ErrorLog' point to the backend table, not the fornt end link? If someone has an alternative method I would be glad to switch approaches - I am not married to this one. Thanks in advance.
My current command is:
Docmd TransferDatabase, acExport, "Microsoft Access", "C:\My Docs\MyDatabaseFolder\MyDataName.mdb", acTable, "tbl ErrorLog", "tbl EventLog"
where tbl ErrorLog is the table I am trying to copy over and rename as tbl EventLog.
How do I make the reference to 'tbl ErrorLog' point to the backend table, not the fornt end link? If someone has an alternative method I would be glad to switch approaches - I am not married to this one. Thanks in advance.