update tables between two access db's

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

update tables between two access db's

Logged in as: Guest

arrSession:exec spGetSession 2,3,35294

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> update tables between two access db's
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

update tables between two access db's - 6/9/2006 1:38:09 AM

mrhayscom

Posts: 2
Score: 0
Joined: 6/9/2006
Status: offline

I need some help trying to solve an issue, and I am not sure how to do it. I am a moderate VBScript programmer. I was hoping someone could lead me towards the right path. I have a site that is based on an access 2000 db. I have done the site in VBScript for the server side. I have a local database with matching tables. What I am trying to do is upload an updated db, and replace certain tables in the db my site is based on. I can't just replace the db on the site. The local db has only tables, and is exported automatically from a CRM application, and I can't customize it. I need to be able through the control panel in my website to upload the updated db exported from the crm application, and replace/update only corresponding tables in my website database. Can anyone help point me in the right direction? I am not sure if stored procedures in vbscript can be coded to perform this function. I did not know if I could do it with a pre-defined query in access. Or possibly point the tables in question in my web db to link to the tables in question from the exported db, and just overwrite on upload. Any guidance is much appreciated.

Thanks,
Mike

_____________________________

Mike Hays