Results 1 to 2 of 2

Thread: From MDB TO ADP

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unhappy Unanswered: From MDB TO ADP

    I am trying to move a database from an MDB to an ADP, but I'm getting some errors. For example

    Code:
    SELECT MachineList.[Machine Number], MachineList.[Serial Number], MachineList.Location, MachineList.[Manuf ID], MachineList.[Game Theme], MachineList.Class, MachineList.Installed, MachineList.Certified, MachineList.[EZ-Pay]
    FROM MachineList
    WHERE (((MachineList.[Machine Number])=[Please enter the machine number]))
    ORDER BY MachineList.Location;
    Now I know there is a difference between Jet SQL and MS SQL, I guess I just need to revert this to MSSQL

    Heres the Error Message I'm getting

    Server: Msg 207, Level 16, State 3, Line 1
    Invalid column name 'Enter the installation date'.
    Last edited by desireemm; 04-15-09 at 17:23.

  2. #2
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Woohoooo

    Never Mind I Figured It Out Its A Function....hoooorrraaaayyyyyyyy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •