How to open Access without having MS Access installed

[chep123]

Hi

I need to distribute some access programs files to my users, but they don't have it installed on their machine. Due to licensing problem, i can't install a copy on their machine. How can i distribute the program to them? Any way? How bout MDE? Hope can help. Thanks.

 

[ArkM]

You must have Access (Office) Developer Edition to distribute your Access applications legally. See, for example:

http://www.granite.ab.ca/access/developereditionversions.htm

 

[chep123]

Hi ArkM,

Beside this, is there any other way to do this? I don't have the developer version and i dont think the company will ever purchase it. Thanks.

 

[willybgw]

Do you have Office 2000 Small Business Edition installed on the user machines? If disk 2 is installed it has an access runtime that will allow your programs to run. I don't know about other versions.

willybgw

 

[evalesthy]

You can search these fora for discussions of Access Runtimes. The ability to create a runtime version has evolved over the Access Versions. In Access 97 you needed the Developer Edition. Now, in Access 2003 you need the Developer Extensions and I believe Visual Studio. Again, check the discussions here under 'Advanced Search'.

 

[psemianonymous]

If your company isn't willing to pay for a single developer copy of Access, build a terrible version of the application in Excel, or better: Word. You get what you (fail to) pay for.

 

[chep123]

oh, it will just ruin my reputation. However i manage to solve this issue. Many thanks to all of you. cheers...

 

[psemianonymous]

I guess you're already in trouble for this project. The point is that you should expect more support. If they don't spend the $800 on the tool, they'll end up paying you $800 more, one hour at a time, as you try to work around the constraint.

Anyway, the next time someone asks for someone, just tell them "that's not possible with the tools I have".

 

[BackStageJim]

This might seem odd, but how does one write from Excel to SQL? I have not seen that, and it might help in an goofy little app we would like to retire.
Where could I look? Perhaps the proper serach term here?

This is why Artemis slew Orion ERP

 

[PHV]

Look at ADODB

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886