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.