Access på hjemmeside med input- og output-filer på pc?

I don't think you will be able to run any code in your Access program if it is on your homepage, you will need to do the code using for example ASP

You can use the Access dB as a database if your homepage supports Access databases.

Your homepage will be able to browse to files on users PC's

I actually think your question will be more relevant in another category now

Just thinking, maybe Office (access) 365 maybe be able to do this but I have no experience with that :-(

Æv. Nu har jeg lige lavet et fantastisk simpelt program, som virker på min pc. Så var jeg sikker på, at jeg kunne "udgive den" på en eller anden måde. Udover at linke inputfilerne til tabeller og eksportere en ny fil er der kun ganske simpel sql-kode og en lille smule if-then-else. Opgaven svarer lidt til at linke to csv-filer, lave en eller anden join og så eksportere som en ny fil. Det må da kunne lade sig gøre.

you can execute access queries but I'm sure you can't execute code...


Why isn't it possible for users to have their own Access dB?
If its because they don't have a license then distribute an Access runtime which doesn't require a license
java script: void(0);

Not sure where java script: void(0); came from!

http://www.microsoft.com/en-us/download/details.aspx?id=10910

Brugerne sidder i et andet system (ikke Access) og skal bare lige hente nogle filer, som først skal gennem min mølle på hjemmesiden. Koden skal ligge hos mig.

hard to say what's the best solution without a better understanding of the full requirement

Terry, here goes:

1. Start the Access database, "MySmartAppl.accdb", predefined linked to 2 existing files: "x:\MySmart1.csv" and "x:\MySmart2.csv".
(Autoexec):
2. Export "MySmartSqlStatement" to "x:\mysmartoutput.txt"
3. End Access.
4. Smile

This is p.o.c. on pc, but I want it to Work, purely on my homesite www.Smartiam.xx.

How to? Can't Access run on a webpage and handle this?

Well, you already answered this ("I don't think you will be able to run any code in your Access program if it is on your homepage, you will need to do the code using for example ASP")

Can't Access run on a webpage and handle this?  > NO

But I still don't think your giving enough information for me to make suggestions.

If it must run on your http://www.smartiam.xx.

then I think you should use Access only as the database where you have your tables. Then the code which inserts data from csv files into tables is in the web pages. Also the code can extract the data to export with a query in the dB.

"the code": ASP? VB?

The job is to merge two csv-files on the user's pc, and then deliver a third one after doing som SQL gymnastics. How would you do this? With Access..

Sorry. *merge..on = read..from

the code": ASP? VB? = That's up to you :-)


The job is to merge two csv-files on the user's pc, and then deliver a third one after doing som SQL gymnastics. How would you do this? With Access..


I thought you had decided it was to run on your homepage!

Skrevet tor. d. 27. februar 2014 kl. 20:57:32| #6  you wrote
Brugerne sidder i et andet system (ikke Access)

Should this have been included with your explanation ? :-)

I'm getting bit sand pieces here and there and its not easy to draw a picture of your requirement.

WHY can ita ll by doe with Access on the users PC?

Well, thinking it all over: I don't want them to have my code :-) I want to run it "by myself" (i.e on the my homepage). The idea was, that they somehow(!) should deliver the files to my program, and then they would get a file in return. I guess, I must reconsider...

I must reconsider > YES :-)

Terry: nice to discuss the matter with you....thnx.

your welcome, hope you found/find a solution

Enjoy the rest of the W/E