Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2002/XP

Reply Fri 20 Mar 2009, 16:40Delegate Mark said...

Mark has attended:
Access Advanced course

Access

What's the benefit of using MDEs in a multi user environment?

For upcoming training course dates see: Pricing & availability

Reply Sun 5 Apr 2009, 09:23Trainer Rajeev said...

RE: Access

Dear Mark

Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link. The person who posted the questions has one of the reasons for making the database as .mde for multi user environment.

http://answers.yahoo.com/question/index?qid=20070920120549AA8o0Cn

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 13 Apr 2009: Automatically marked as resolved.

Access articles

· When To Use Access, When To Use Excel
· Find Out All About Microsoft Access Report Sections
· Getting To Grips With Templates In Access 2007
· A Quick Intro On How Access Uses SQL
· How much time could you save with Access?

Please browse our web site to find out more about
microsoft-access-courses and other Microsoft training courses.

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