Updating Access runtime DB

[huk49]

Hi all
I have created an access 2010 application for our cooking club. It is being used by all members, the majority of them with the runtime version of access.
The DB updates, new recipes aso, are downloaded regularly from our homepage and thus are limited in size. I am therefore looking for some sort of a batch interface that also works with the limited capabilities of the runtime version.
Any help or new ideas are highly appreciated.
Thanks in advance and all the best for 2015.
ueli

 

[pbaldy]

It appears that nobody really understands the question, or what you're trying to accomplish. If you're looking to send out data, Access can import from Excel, text files, etc.

 

[huk49]

Hi Paul
Thanks for your reply.
Can the runtime version of access also import from excel or text files? If yes, then my issue is solved? If not, I was thinking of programming an interface using the DoCmd.TransferText Method or some equivalent. Is there an easier way?
Ueli

 

[CJ_London]

Can the runtime version of access also import from excel or text files?

Not in the sense of a function available on the standard ribbon - however you can in VBA using transfertext or similar method

 

[pbaldy]

Yes, those methods still work in a runtime environment. What you can't do generally is change the design of forms or reports.

 

[huk49]

Hi Paul and CJ

Many thanks for your replies. I understand that the access runtime version can import data from text and excel files but you have to program it yourself using VBA.

Ueli

 

[pbaldy]

That may be true, though I've never tried to do it manually with the runtime version.