Search results

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...

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...

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...

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...

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.

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...

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...

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...

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...