access courses in london - Publishing workbooks to the web

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Publishing workbooks to the web

Iain has attended:
Excel Advanced course

by - delegate Iain [1 post] (2007 Jul 30 Mon, 16:09) Reply

When a user changes data on the spreadsheet publsihed, are the changes saved?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£110	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Publishing workbooks to the web

by - trainer Richard platinum contributer [788 posts] (2007 Aug 7 Tue, 11:41) Reply

Only if the AUTO-REPUBLISH feature has been used to save the file. Make sure the box is ticked on the PUBLISH interface, and then the file iwll be updated automatically.

Regards

Richard

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Take an Access Course to Learn About Relational Databases
· Microsoft Access Training Opens Doors
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips