Hi
I am using MS SQL server 2008 Analisys Services where I have a Stage Database. From MS Access I want to make a Linked table but the result is that all data is marked #Deleted. It is not possible to make a new Primary Key to the table because is generated from a program that uses this key. The datatype is bigInt.
Is there any way around this problem? :banghead:
When i make the Linked table to a local table, all data is allRight but then there is no longer a way of updating data to these tables.
Has anyone a suggestion what to do?
Thank you
Best regards
Lars Bo
I am using MS SQL server 2008 Analisys Services where I have a Stage Database. From MS Access I want to make a Linked table but the result is that all data is marked #Deleted. It is not possible to make a new Primary Key to the table because is generated from a program that uses this key. The datatype is bigInt.
Is there any way around this problem? :banghead:
When i make the Linked table to a local table, all data is allRight but then there is no longer a way of updating data to these tables.
Has anyone a suggestion what to do?
Thank you
Best regards
Lars Bo