Networking And Licensing Question
Dec 15, 2006
First off, I'm a total newbie at Access. I've had it for a few weeks now and am trying to develop an order entry system for our church (we have a discounted food ministry). I've gotten pretty far with it.
Anyway, once this app is complete, how can we have 2 computers updating one database or do we have to use just one computer exclusively and to do more than that, we'd have to go to sql server?
Also, can we install access on more than one pc? We have access 2003. We don't have any problems with buying another copy, but if we buy it, we need to know we can have 2 computers, accessing one access database. Is this possible?
Thanks for any help at all,
Ken
View Replies
Jun 27, 2006
I am trying to make sense of the different type of Access licences. I want to be able to distribute the access database with my application. Can anyone tell me how I can do this? My VB application needs to store & access data from a database and I was wondering if I can use Access and distribute the database - is it legal and if yes, how can I do it? What sort of license do I need. Thank you.
View 3 Replies
View Related
Dec 26, 2005
Hello All,
I have created a management system for small home builders and contractors.
Typically these customers will have less than 25 users. So far I have installed it in a single customer’s site, but I want to expand.
I basically have two questions.
1. What is the best way to deliver this product without the end user needing Access?
2. How can I ensure they don’t make illegal copies and give to their friends or add user without purchasing more licenses?
Thank you all,
Joe
View 5 Replies
View Related
Aug 15, 2007
Hi
I'm building a Software Licensing Database & I have come across this particular problem and i am not 100% sure which way would be the best way for me to solve it. So far I have created the database so that a user/software/license can be added to the system. The main form display's users information and below in a tabbed subform it displays the installed software on the machine. On the second tab it displays the license's attached to that machine. On each of these subforms its provides the user to add/delete software/license's however my problem is with error handling within the system. I have managed to make it so that a user can only selelct license's that are specific
Each License can cover anywhere from 1 to <x-amount> of pc's. What I want to be able to do is the user can select a license if their is 1 available and a small text box which denote's how many license's are available. So i know im going to need a license count which is easy enough using a SUM within a query. It is the error handling that im stuck on. I need to create a statement using the 'equal to or greater than' operator if possible saying
If NumberofLicenses >= then add license
Else If vbOKonly message - "Insufficient License's to cover this piece of software please purchase & add the new license to the system then try again"
Something along those lines.. I just dont know where this would go or how to write it! If anyone has a better way of achieving this.. fire away im open to ideas!
cheers
Ally
View 1 Replies
View Related
Jan 29, 2007
I'm hoping that someone can help me with this.
I have 5 computers on a network and have designed a form which needs to be accessible by every computer on the network. When I do try to open the form from a different computer other than the one it was created on, I get a security warning message that Microsoft Access will not open the file due to security reasons as the computer I am accessing is not a trusted source or not part of my intranet. I've tried everything. Can someone please help?
View 7 Replies
View Related
Aug 1, 2007
hello,
how is it that I make a table "updatable". That's the error ACCESS 2007 gives me when running the runtime version (front end) on a computer. The program has to update the tables on the back end which are on a different computer (on the same network).
Also, I just saw a thread with some code included to open the database, and then to close it. Do I need any connection code in ACCESS for this case?
This is my configuration:
- Main Machine (which has an shared external hard drive E: where the back
end file resides)
- Other Machines (they contain the front end file which is supposed to be
linked to hard drive E on Main machine)
Everything is shared and the path to link the front and back ends is working well.
View 2 Replies
View Related
Apr 9, 2006
Hi there...
I have splited my database... the table parts in the network (server) other part in some different computers...
I did this to allow others to enter data that ultimately will be gathered in the table-part of the database.
The problems is, when i linked the tables (using my computer) in the splited database it took the address as W:mydatabase.mdb, where W is the logical drive of the server...
when i try to operate it from other computer it can't get the link because the logical drive is defined differently in other computers...
but the actual link is follows:
\vbsrsdatabasemydatabase.mdb
I can hyperlink any document puting this address which are accessible from different computer...
is there any way to link the tables using the actual link in my database?
Thanks and regards
MPB
View 3 Replies
View Related
Mar 19, 2008
I have a split database. I hope I can explain this well....
I have a network mapped drive on all computers (win xp pro) of G: I have obviously a front end that was created when it was split.
I keep that fornt end file in same folder of the backend side of things, and I simply copy that exact tile (the front end) and place it on to the desktops of the workstation PC's and my database seemed to work, obviously I do rename the front end file on all PC's to Workstation 1, Workstation 2 and so on.
The front ends on workstations all do connect to the backend and the data does appear in the front ends and new records can be added and edited.
However I have a few issues:
1) If Workstation 1 was editing record 1 and workstation 2 was on another record say '232' and workstation 2 wanted to view the changes made to record 1 then he/she would have to wait till the the user edits the edited record and wait 5 seconds to see any changes. It would appear there is a slight delay in seeing the updated data.
2) If for example the user on workstation 1 adds a new record then it does update it in the table on the backend no problem at all, but it doesn't appear in the other front end databases form until the users exit the form and go back into it - it doesn't update live.
Is there a soloution to this.
View 8 Replies
View Related
Aug 22, 2006
I would like to have a back-end Database on a host server and link a
front-end Database to the tables several hundred miles away. The problem is I have no experience whatsoever in doing this.
My questions are:
(1) Can tables be linked via the Internet?
(2) If they can, is this the best way to link the tables?
(3) If it is possible to link the tables by the internet or by some other way; how do I do it?
I really would appreciate any help you can give.
Kind regards
Eddie
View 1 Replies
View Related
