Help Needed with code

[mahie]

Hi friends....
Need some urgent help with a functionality that have been breaking my head on since past 2 days.. :banghead:

I have a front end (.adp) and my backend is in SQL Server 2008 but along with this have a local temp access table (.accdb/.mdb) which will store my data temporarily while it is being processed..

After the processing is done I need to copy the all the records from this temp table and copy it to my SQL table..

1) I tried creating a SP in backend but that seems to give me some linked server error..
2) I have created a DSN and have linked the SQL table in my temp access table but I am not able to access this linked table via my front end code..

Need your help and support in this code..

Any help is really appreciated.

Regards,
Mahie

 

[Guus2005]

[qoute]2) I have created a DSN and have linked the SQL table in my temp access table but I am not able to access this linked table via my front end code..[/quote]
So the table is linked in Access but you unable to access the records?
Are you sure there are records in the table?
Do you have enough privileges to access the SQL Server data?

HTH