#Deleted (1 Viewer)

Lars Bo

New member
Local time
Today, 12:58
Joined
Jul 23, 2013
Messages
4
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
 

SOS

Registered Lunatic
Local time
Today, 04:58
Joined
Aug 27, 2008
Messages
3,517
The problem is Access doesn't like BigInt. Have you tried using the SQL Native Client 10 ODBC driver?
 

Lars Bo

New member
Local time
Today, 12:58
Joined
Jul 23, 2013
Messages
4
Hi SOS
Yes I have tried the Native Client ODBC driver without any luck :-(
 

Users who are viewing this thread

Top Bottom