• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Access 2007

My OS is windows 7 and I am trying to build a small access app for a friend.  But I just want this app to be used only on one pc, which is the one he has at home.  Is there a way to tie in the code  the IP address of the pc, so that it will not be recycled.  thank u.
1 Solution
You could place a file (perhaps in the System 32 folder) that you specifically look for in order for the application to run.  Title it so it doesn't reflect your application.  For instance "x2gt.dll" or something.

In the startup of the app, look for it.  If it doesn't exist, the program quits.

function CheckForFile()
dim verror as boolean
dim f as long
on error goto NoFile
f = freefile
open "YourPath and file name" for input as #f.
if verror = true then
    '--- can't open the file - it doesn't exist --
    msgbox "Illegal copy",vbcritical
    on error resume next
    close f
end if

'---- to get here meant the file exists and all is good -----
close f

exit function

 verror = true
 resume next

end Function

Scott C
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have to ask - if this is for a friend, why would you care if it's used on other machines? Just curious, really ...
As you have Acess 2007, you have access to Extensions from which you can build a RunTime app and password protect it.  Tying it to the IP address is not a good idea.  What if he moves?
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

jegajothyAuthor Commented:
In response to LSMConsulting, as it is going to take me lots of time and energy and I have to build it from scratch and since he is running a successful home business and the ability to pay but as usual with humans, they will try to short change u.  He wants me to build it for 4 pcs,but knowing him he will deploy to other pcs when he expands.  Just do not want to be a made a fool.   Thus, the idea to make sure that I hard code the IP address for the 4 pcs.  Any other ideas will be welcome.
Armen Stein - Microsoft Access MVP since 2006Commented:
Is your "friend" paying you for your time?  Why not let him move it to other PCs later?  It's the same effort for you either way, right?

If I paid for your development time and after receiving your software found out that you had restricted it to 4 particular PCs, preventing me from updgrading them, moving the software to other hardware, etc., I would be very upset.  Especially if you were no longer available to change the code for me.

We've built hundreds of applications for clients.  We bill for our time and we get paid.  Our clients get the source code.  We don't lock it down with draconian measures.

When our clients are successful and need to use our software even more, if they're happy they come back to us for enhancements.  And happy customers are referenceable customers.  Putting handcuffs on a customer tends to make them less happy.

jegajothyAuthor Commented:
In response to ArmenStein, I never thought to look at that way.  I was looking at the licenses we buy for our software, where it is for one user one pc.  And I will not be surprised if he resells my application to others, thus the reason to put handcuffs on him.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I agree 100% with Armen.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now