Web Wiz
Home
Home
Hosting Services
Hosting Services
Knowledgebase
Knowledgebase
Community and Support Forums
Support Forums
Customer Login
Customer Login

  New Posts New Posts RSS Feed - Working db offline
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Web Wiz Web Hosting 30 Day Free Trial

Windows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.

For moreĀ informationĀ see our Windows Hosting 30 Day Free Trial page.

Working db offline

 Post Reply Post Reply Page  <12
Author
Duffy View Drop Down
Newbie
Newbie


Joined: 26 March 2010
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duffy Quote  Post ReplyReply Direct Link To This Post Posted: 26 March 2010 at 4:19pm
I'm probably making life difficult for myself here, but then really the remote database is only of use for the one table that will be collecting the form results as everything else I do on the local db will never get published then? I was told I had to 'drag it offline' then do the mail merge then drag back online (which I would have thought would overwrite the new form results).
The whole problem is that this is coursework and the specification says the web site has to be linked to a relational database. Well mine is, but teacher is insisting on this dragging offline (to desktop and opening with Access I think)  business. Can't ask her to explain as school now closed for two weeks and I have only just realised all the problems this might entail. My idea was to export the table from the database on the remote site to a table in my local db (say table A) and copy the contents into another table (table B) where I could do queries etc, then each time I exported the data again, it wouldn't matter that it was overwriting table A as the data would then be stored in table B. This would mean that only the db on the local site would be up to date but I can't see any other way round it.
Sorry for rabbiting on but you are the first person who has grasped my problem and knows what you are talking about. Thanks!!
Back to Top
dpyers View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 May 2003
Status: Offline
Points: 3941
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 26 March 2010 at 4:50pm
Frankly, I think the easiest thing for you to do in this situation would be to crate a page that contains a link to the online data base. Call up the page, and right-click the link to select "Save As".

It's not particularly safe and secure, but for classroom purposes, it'll get a copy to your local drive with a minimum of hassle. Once there, you can open it with access and have your way with it in whatever manner the instructor prefers.

EDIT: Because my damn keyboard keys are sticking - don't ask!



Lead me not into temptation... I know the short cut, follow me.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole, England
Status: Offline
Points: 8039
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 26 March 2010 at 4:57pm
Why are you using Access and Frontpage anyway? Is your teacher still stuck in the 1990's? Seems like a bit of a waste of time learning things which are out of date or in the case of Frontpage have been issued with an End Of Life with FP Extensions no longer working at all in Windows 2008 R2.
Back to Top
Duffy View Drop Down
Newbie
Newbie


Joined: 26 March 2010
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duffy Quote  Post ReplyReply Direct Link To This Post Posted: 26 March 2010 at 6:28pm
Thanks to both of you!
Re FP and Access - couldn't agree with you more!! They are sooo out of date but school wont stump up for new software.
If I never see either of then again it will be too soon.
Back to Top
 Post Reply Post Reply Page  <12
  Share Topic   

Forum Jump Forum Permissions View Drop Down



Become a Fan on Facebook Follow us on Twitter Web Wiz on Google+ Community Forums Web Wiz Blogs Web Wiz News
Company Information | Contact Web Wiz | Terms & Conditions | Privacy Policy

Prices exclude VAT unless otherwise stated - $, € prices shown as a guideline only
Web Wiz Ltd, Unit 10E Dawkins Road Ind. Est, Poole, Dorset, UK, BH15 4JD
Copyright ©2001-2012 Web Wiz - All rights reserved