How to link MySQL Databases?

The UK's most regular instructor-led training courses.
Training information: microsoft access training uk · Access course microsoft training · VBA courses London UK

Resolved · High Priority · Version 2007

Farhad has attended:
Access Introduction course

by - delegate Farhad [3 posts] (2008 Apr 23 Wed, 16:11) Reply

How do I link a MySQL Database to an Access database, also being able to alter the information (records, tables) from a website?

Thank you

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 8 Tue	Southwark	4	book now	£207	£215
2003/XP	2008 Jul 15 Tue	Bayswater	6	book now	£195	£205
2003/XP	2008 Jul 18 Fri	Bloomsbury	5	book now	£198	£215
2007	2008 Jul 24 Thu	Bloomsbury	4	book now	£224	£224
2003/XP	2008 Jul 29 Tue	Bloomsbury	5	book now	£198	£215
2003/XP	2008 Jul 30 Wed	Tooting	0	FULL
Full Schedule: See all 77 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: How to link MySQL Databases?

by - trainer Jacob silver contributer [83 posts] (2008 May 12 Mon, 17:20) Reply

Hi Farhad

Thanks for your post, it looks like consultancy may be the best way to assist.

3 steps to organising consultancy

1) email us some examples of your work, and list your key objectives). we will then profile & review your requirements

2) We will then send you a proposal
- Scope of work
- Timeframes
- Pricing

3) Secure the work by signing our consultancy agreement

If you would like to discuss this further then please let me know.

Regards

Jacob

· Access Database Optimization: First Normal Form
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Access VBA Training Adds Power to your Databases
· Microsoft Access Tighten your Security Controls
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

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

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips