Web Wiz - Green Windows Web Hosting

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

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


Joined: 12 May 2003
Status: Offline
Points: 3937
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: Bournemouth
Status: Offline
Points: 9844
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

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.