Results 1 to 2 of 2
  1. #1
    sklim is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    2

    Mysql backend - linked tables missing unique indexes

    Hello,


    I am working on an MS Access 2010 database. I need to put the backend of the database on a web server, but apparently it is not possible to connect an MS Access frontend to an MS Access backend on a web server, so I exported the backend tables to a mysql database on the webserver. I was able then to create a dsn and link the tables to the Access frontend.

    PROBLEM: The linked tables do not have the same attributes as the tables in the Mysql backend. Required fields are not marked required in the linked tables, and unique indexes are also missing.

    I really need to use composite (multi-column) keys for processing, so the missing attributes are a shot in the heart.

    HELP!

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Things like this can be lost when upgrading.

    Suggest you get MySQL correct and forget about the linked table. The attributes of MySqQL should apply.

    Have you tried to enter data.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. lookup database name on MYsql backend
    By russ0670 in forum Access
    Replies: 3
    Last Post: 01-05-2012, 11:23 AM
  2. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  3. Replies: 2
    Last Post: 03-21-2011, 12:55 PM
  4. access split DB to mySQL (backend only)
    By rnbwkat in forum Access
    Replies: 1
    Last Post: 05-31-2010, 07:19 PM
  5. MySQL Linked Tables - Carriage Return
    By warrenk in forum Access
    Replies: 1
    Last Post: 03-28-2010, 01:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums