I think I know how to do this manually - by cutting and pasting the back-end data tables to the front-end table database, but I was wondering if their is an
automated way to do it, or an easier method. Please let me know. Thank you!
I think I know how to do this manually - by cutting and pasting the back-end data tables to the front-end table database, but I was wondering if their is an
automated way to do it, or an easier method. Please let me know. Thank you!
You can import the tables with the External Data tool.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you June7! I did know that way also, but I was wondering if there was another automated way? Thanks for your speedy reply!
Other than writing a VBA procedure that runs a bunch of SQL statements, what could be more automated? Is this a one-time event?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.