Auto Importing & Exporting

[KStringer]

We have an Access-based application that gets populated from our ERP
solution and read by shippers & customer service folks on a pretty much
continuous basis.

We are in the process of migrating from our old ERP solution to SAP. SAP
does not speak to Access directly.

We are told we'll need a small piece of middleware written to pull a
delimited file from Access in order to get that info into SAP and SAP can
push out a delimited file to be imported into Access.

So far, I follow the process, if not the specifics.

My question is - has anyone done anything like this so we're not completely
re-inventing the wheel here and will we run into problems importing &
exporting while users are browsing/viewing? (ok, so that is 2 questions -
but every time I think about this, I come up with more questions & no more
answers...)

Can anyone help? My gratitude in advance!

 

[Guest]

Currently, we use SAP for our finance department. I have requested that the
ABAP Queries in SAP automatically download or FTP to a server at night but I
have not found a fix to a few bugs yet.

In answer to your questions below:

1) I do it so it has been done before. I pull information from SAP and our
legacy system and combine it in MS Access to generate reports.
2) Exporting is no problem in MS Access with users in the database.
Importing is trickier. You can prevent problems by a) creating a frontend
and backend database where you are updating information on the backend and
the users are in the frontend databases or b) kicking out users while you
update the tables or reports and forms.

Hope that helps. If not, email at (e-mail address removed) and put MS ACCESS in
the subject line. Thnx.