Populating Data from SAP to MSACCESS

[Former Member]

Hi Friends,

I have the coding for downloading the data from SAP to MSACCESS. It is working fine in foreground mode but when I run it in background mode its not working. How to check whether this program has the fesability to populate data in background mode? can anyone suggest me how to proceed?

Thanks & Regards,

Inder.

[Former Member]

Hi Friends,

I have the coding for downloading the data from SAP to MSACCESS. It is working fine in foreground mode but when I run it in background mode its not working. How to check whether this program has the fesability to populate data in background mode? can anyone suggest me how to proceed?

Thanks & Regards,

Inder.

[Former Member]

Hello,

In foreground, your computeur disk are avalaible.

In background, is the server disk that are availaible.

Thierry

[Former Member]

Hi Thierry,

Can you please explain briefly. I could not understand.

Thanks,

Inder.

[Former Member]

Hello,

Where is your database access ?

If it is on your computer, you can access it in foreground. the SAP server can't acces it in background.

If it is on a folder server, perhaps, the SAP server can't access to that folder.

Thierry

[Former Member]

Hi,

Did you get solution for this? I have a similar requirement wherein I want to generate data into MS Access file into background.

Is it possible to create MS Access file (.mdb) in background?

Thanks,

Falguni

[Former Member]

Hi Falguni,

As far as my knowledge there is no possibility to download the .MDB file in background. It is only possible to download it in foreground. I can suggest you a solution which was rejected from my client .

Since, it was taking a long time in foreground to retrieve data from SAP into .MDB they wanted a work around so, I proposed them to download the data into either application server or presentation server as a TXT file and then to write a separate program to upload the TXT file and convert the file into .MDB in foreground which will reduce a considerable amount of time since reading from application server is much faster than reading from database.

Thanks & Regards,

R.Indirajit.

[Former Member]

Hi R.Indirajit,

Yes, we are going with similar solution but I've figured out way to download this in background.

Thanks,

Falguni

[Former Member]

Hi Falguni,

Can you please let me know how you downloaded this in background????? Since, i have done a lot of R&D and couldnt find any solution im very much curious to know the solution.

Thanks & Regards,

Inder.

[Former Member]

Hi Inder,

Sorry for late reply.

I created the file on Application Server in background mode.

For this, I created 2 new RFC destinations which points to the App server path where wdpsastr.exe & wdpsatab.exe files will be stored (similar to PS_ACCESS1 & PS_ACCESS2 RFC destinations which points to wdpsastr.exe & wdpsatab.exe files on our PC).

Now use these new RFC destinations to create MS Access file on App Server in background on mode.

Regards,

Falguni

[Former Member]

Dear All,

     I had requirememt to create mdb file in application server.Is it possible through setting RFC Detination.Pls suggest.