Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    17

    Unhappy Unanswered: Pls help me!! I will loose job!!!!!!!

    I fall into a hell of MSDE.PLs somebody help me!!!!!!

    If I create sub-form using a join query or Stored procedure, MSDE shows strange errors when I try to insert a record in subform. The following example for reference

    Table Name : TestTable1

    EID_1 INT PRIMARY KEY IDENTITY 1
    FULLNAME VARCHAR(40)
    ETypeID INT INDEXED

    Table Name : TestTable2

    EID_2 PRIMARY KEY
    FirstName VARCHAR(40)
    LastName VARCHAR(40)

    Table Name : TestTable3

    EID_3 PRIMARY KEY
    Address1 VARCHAR(40)
    Address2 VARCHAR(40)

    RELATIONSHIP (TestTable1.EID_1 = TestTable2.EID_2)
    X Columns related Enforce relationship for replication
    X Enforce relationships for INSERTs and UPDATEs
    X Cascade Delete related records
    RELATIONSHIP (TestTable1.EID_1 = TestTable3.EID_3)
    X Columns related Enforce relationship for replication
    X Enforce relationships for INSERTs and UPDATEs
    X Cascade Delete related records

    Query : TestQuery2 - Join
    SELECT TestTable2.EID_2,
    TestTable2.FirstName,
    TestTable2.LastName,
    TestTable3.EID_3,
    TestTable3.Address1,
    TestTable3.Address2
    FROM TestTable2
    LEFT OUTER JOIN TestTable3
    ON TestTable2.EID_2 = dbo.TestTable3.EID_3

    Form : TestForm1
    RecordSource : TestTable1
    Unique Table : TestTable1

    Sub Form: TestForm2
    RecordSource : TestQuery1
    Unique Table : TestTable1

    Can anybody help to fix , is it bug? I cant compromise with database design because it is upsizing project from Access. What are the possible workarrounds for this ?


    Another bug I found
    if we creat a subform with storedprocedure as its record source. Subform creating Wizard shows different datatypes (I used INT datatype and wizard showed it as as REAL) thus, it makes impossible to synchronise the main form with subform

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    This may be a work around.

    Copy your existing Access file to a test folder. Create an ODBC source to your new MSDE database. Delete the tables in your copied Access file.
    Now link all the tables using ODBC. It will be transparent to the Queries that you changed the tables if the tables are exactly the same as in the original Access File.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Feb 2003
    Posts
    24
    I think you should show the error messages which popped up, it could be helpful for us to get a clearer idea...

    And that's "funny": we had a meeting about a MSSQL administrator training course this morning and one of the blokes there told us that it wasn't a good idea to make an upsize of an Access Project because the stored procedures it generates to replace the queries were a bit dodgy, the datatypes wrongly "translated" and so on... Thanks Mocrosoft!!

    Anyway if you have a look to my the post I've started and you've replied to you may find some leads to help you... I'll let you know if I have some news.

    Good Luck,

  4. #4
    Join Date
    Feb 2003
    Posts
    24
    I might just have saved your job!!!
    Apparently, if in your select clause you select every field from every table, it seems to work fine...

  5. #5
    Join Date
    Apr 2003
    Posts
    17
    Hi Buddy

    Thanks a lot for your reply. sorry for the delay

    The error message was "Invaild object Project1"
    The funny thing is "Project1" is the name of the project

    You got the same error there when u created something with my example ?

    What a strange thing it is ? I dont, I had a work arround, that all the queries (means join queries) used in the sub form are splitted inot different subforms and which uses queries based on only one table.
    That was a hell....... my form looks like a messy work by a naughty child
    thats all, thanks a lot microsoft!.

    To select every field in every table i use.. ohhh... there, i haven't tried, how much i have to compromise with to select two or three fields which contais more than 4000 records.. Let me check, write to you soon.
    thanks a lot again
    My Job still is in '??????????'

    Jos

Posting Permissions

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