Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refreshing tables in Access Db: Front Page doesn't follow

Status
Not open for further replies.

Quehay

Programmer
Feb 6, 2000
804
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top