I have an Access db that lives in a web. Due to firewall/security concerns we can't have a connection to the live db and copy tables into existing db copy in web instead.
The problem: Using the same .mdb file and deleting existing tables & importing new copies of same tables, Frontpage returns an error. This requires recreating the original steps to recognize the db.
What would be a good way to automate table refresh without this problem? Create a DSN instead of the the native FrontPage functionality?
TIA
The problem: Using the same .mdb file and deleting existing tables & importing new copies of same tables, Frontpage returns an error. This requires recreating the original steps to recognize the db.
What would be a good way to automate table refresh without this problem? Create a DSN instead of the the native FrontPage functionality?
TIA