Search results

  1. J

    Import dynamic internet data

    Hi all, I have been looking for a solution, still without success, for something very useful, but also quite a big challenge. On the internet there are a lot of sites which display a follow up for processes, products bought etc. like e.g. the post office. I want to supply my processes, running...
  2. J

    AccessFE-SQLBE swaps PK for IK

    In my Access(2007) Frontend linked to a SQL Server Backend (2005) application, the SQL Table [SE_MesMatEng] has besides the PK [IdMesMat], a unique indexed column [NumMat]. CONSTRAINT [PK_SE_MatMaq] PRIMARY KEY NONCLUSTERED ( [IdMatMaq] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF...
  3. J

    Access to SQL Server connection mystery

    Our FE/BE Access (mdb)/SQL Server application is doing very well in a corporative environment for months. However last week, when we needed to introduce an upgrade to the system, adding new functions, the swapping of the FE links between the SQL Servers (2000) for testing, homologation and...
  4. J

    Sub-forms and continuous forms

    With normalized tables one always runs into non-updatable queries that don’t let you put the data in the tables. To get around this, the table that needs to be updated is used as form source and sub-forms display the needed additional info of the tables that otherwise would lead to a blocking...
  5. J

    Change the Type of a Table Column from Autonumber to Number ?

    Hi folks, One can manually change the Type of a Table Column from Autonumber to Number (long int). Is it possible to do this with VBA code? Thanks for any hints.
  6. J

    Data transfer between tables with auto numbering PKI.

    Hi, back again with one more trouble. While there is no problem with data transfer between 2 Access tables with auto numbering PKI - Access keeps the key values equal in the 2 tables - when transferring from Access to Sql Server, the latter generates its own values in the PKI column, so you no...
  7. J

    Upgrading to SQL Server generates an IDENTITY col. causing trouble @ uploading.

    Hi, After upgrading the Access backend to a SQL Server backend, running an upload of the data from Access to SQL Server, 2 tables of the total of 72 tables reject the load because of an IDENTITY column and stay empty. Comparing with other tables, I cannot find any reason why this 2 tables were...
  8. J

    Trouble with DoCmd.TransferDatabase acLink, "ODBC Database"

    I am testing my Access application with Access FE / SQL Server BE in my home computer (all SW in the same PC) There is no problem in linking the BE manually to the FE, however when I try this through VBA programming, I get the error 2507 (Db type ODBC Database not installed / doesn’t support...
  9. J

    What happened to the queries after upsizing to SQL Server?

    What happened to the stored queries defined in the FE of our Access FE-BE application, after upsizing the Access BE (just tables) to SQL Server? As an example: [ProjectChances].[PropNum] ç related è [Sales].[PropNum] Below the excerpt of a SQL Server printout showing the relationship...
Back
Top Bottom