Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Unanswered: Access linked tables, problem.

    Hi All!

    I have a problem with my access database. I linked a datatable from mssql server. If i open the linked table (the name of this "rgp"), then i see in all columns "#DELETED". It is #8114 error code. The access cannot convert any datatypes. But if i would like to modify the column in access, then i can't because it's linked tables and read only. How can i do mend this?

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably the best solution is to use either ADO or DAO recordsets rather than linked tables. thats certainly the most preferable route as it leverages the power of your server db and the Access RAD. however it does require a rethink about who you retrieve and process data.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Can you post the script of the table? To do this go into enterprise manager\ management studio, right click the table and select "Script Table As CREATE...". This might vary a little in enterprise manager but is broadly the same. Please post the output here.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Apr 2007
    Posts
    6
    Hi pootle flump!

    This is the output of the script. The problem (i think so...) is with the bigint datatype... Have you any idea?

    USE [RadAgain]
    GO
    /****** Object: Table [dbo].[rad_CDR] Script Date: 04/19/2007 12:52:05 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[rad_CDR](
    [id] [bigint] IDENTITY(1,1) NOT NULL,
    [entry] [datetime] NULL CONSTRAINT [DF_rad_CDR__entry] DEFAULT (getdate()),
    [serialNo] [numeric](18, 0) NOT NULL,
    [NAS_IP_Address] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Tenor_NAS_Port] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NAS_Port_Type] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [User_Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_call_origin] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Called_Station_Id] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Calling_Station_Id] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Status_Type] [char](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Delay_Time] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Input_Octets] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Output_Octets] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Session_Id] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Session_Time] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Input_Packets] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Acct_Output_Packets] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Service_Type] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_ivr_out] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_conf_id] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_remote_id_1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_remote_id_2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_gw_id] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_call_type] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_setup_time] [datetime] NULL,
    [h323_connect_time] [datetime] NULL,
    [h323_disconnect_time] [datetime] NULL,
    [h323_disconnect_cause] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_voice_quality] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Quintum_trunkid_in] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Quintum_trunkid_out] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [rate] [decimal](12, 4) NULL,
    [rate_group] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [rateTable] [numeric](18, 0) NULL,
    [billing_chunks] [int] NULL,
    [ballance_before] [decimal](13, 4) NULL,
    [connection_charge] [decimal](12, 4) NULL,
    [compensation] [int] NULL,
    [cost] [decimal](12, 4) NULL,
    [source] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [h323_remote_address] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [InvoicingDate] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    CONSTRAINT [PK_rad_CDR_] PRIMARY KEY CLUSTERED
    (
    [id] ASC
    )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
    ) ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF

  5. #5
    Join Date
    Apr 2007
    Posts
    6
    Hi healdem! I understand, but how can i make a linked tables with ado (in access)? And - very interresting-, the problem is with just this table... Any other tables working well...

  6. #6
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    FWIW.... I am able to duplicate this problem with a few tables I have that have BIGINT data types. Looks like Access doesn't know how to convert that one.
    Inspiration Through Fermentation

  7. #7
    Join Date
    Apr 2007
    Posts
    6
    Hi RedNeckGeek!

    Have you any idea? How can i do mend this?

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    How many inserts are you ever likely to make into the table? You can insert half a million rows a day for ten years before you will get close to needing to use a bigint.

    My suggestion - change to int
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Apr 2007
    Posts
    6
    I made an archive table from the cdr, and the new cdr table have 4000-5000 records. In the old cdr table is 38743 records.

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    defo change to int
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Apr 2007
    Posts
    6
    HI pootle flump!

    Thank you for the reply! It's working well! Thanks!

Posting Permissions

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