|
| |
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
 |
Question regarding MS Access and Licensing - 6/3/2005 11:27:18
I am in the need to get a access program I wrote (basically a bunch of forms all bundled together and storing data in tables) to 50 different cpu's; however, they do not have microsoft access installed on them. I looked into the license agreement and they are 210 each! Is there a way I can get just this program to work on a cpu? Thats all I want, is that individual one to work. I know I can get excel and word readers for the rest of office...but, what about access? The snapshot thing I dont' think will work.
|
|
|
|
Reflect
Posts: 4767
From: USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 12:08:58
If they are not modifying you have more than several choices to choose from...
http://www.google.com/search?hl=en&q=access+viewer
Take care,
Brian
_____________________________
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:05:24
If you have Visual Studio (or some other products I'm not sure which), you can get runtime redistribution licenses. Access is Access except with design features removed.
Is there some specific reason they need to run actual Access at the PC? No net connection perhaps?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:08:48
Ya, they will be running the program (I shouldnt' call it a program, but for all intensive purposes) from a labtop with no connection all across the nation. I guess the best would be to learn vb more and export the data into a comma delimated txt file for uploads and what not...however, that is beyond my head at the moment...still learning vb.net :)
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:09:52
They don't need to change anything in access itself, but, they will have to write data to tables...which, unfortunately, requires access on every cpu I spose :(
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:24:29
Man, money hungry microsoft.....garble garble......210 a license.....ugh
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:30:13
They will have no inet access and be using the file on a labtop in their car...so, its real limited :(
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:48:59
Each machine will have IIS installed on it as there are other asp applications I run for it... however, I need to store the data that is sent to them so they can look at it. And, the data will update often (they download an xls file currently that is generated from teh web and it puts it into their database)
I could change all that to be strickly asp oriented, but, how would I store all the data?
Also, for troubleshooting purposes, it would be difficult navigating through a text file with them online to find the problem :(
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 13:58:15
quote:
ORIGINAL: dzirkelb1
They don't need to change anything in access itself, but, they will have to write data to tables...which, unfortunately, requires access on every cpu I spose :(
No, that is what the runtime license is for - working/editing the table data. They can't edit the *design* of the tables, forms, etc. but they can edit the data. It looks and acts just like Access but without the design features.
If you really want it to look like Access, check into it. I just haven't found all that much that can't be done via a web page that can be done with Access runtime.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 14:03:02
quote:
(they download an xls file currently that is generated from teh web and it puts it into their database)
Is this a remnant of other posts from before? I hate to throw any wrenches, but have you tried just sending an .mdb file instead of a .xls file? Or do they need to see the data in Excel format first (or am I just way out in left field.)
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 14:03:06
I'm confused rdouglas...is it a kind of access that this is? All the users need to be able to do is click buttons which runs background vb code...that runs queries / moves data around, updates it, deletes it...they don't need to change design at all (like you mentioned above)
I don't care if its access or not, but it has to be compatiable with access as thats the database driving everything on the entire application as a whole.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 14:08:43
ya, they are from the posts a while back.
They download an xls file that is linked and updates their database. I could send a database everytime, but I'd like to avoid doing that as I loose runtime (meaning, if they want it at 8pm, I can't provide it.)
Also, the file would be too big.
If you would like, I can write up an entire walkthrough of what they do..it may help :)
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 14:27:46
quote:
ORIGINAL: dzirkelb1
ya, they are from the posts a while back.
They download an xls file that is linked and updates their database. I could send a database everytime, but I'd like to avoid doing that as I loose runtime (meaning, if they want it at 8pm, I can't provide it.)
Also, the file would be too big.
If you would like, I can write up an entire walkthrough of what they do..it may help :)
You can export an .mdb file at "runtime" just like you're now doing the .xls and you can export only the records you want just like .xls
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 14:41:43
From what I understand of the access 2003 developer extenstions, it sort of takes my mdb file I created, adn turns it into an executable file which can be run on any cpu regardless if it has access installed on it or not...is that so? If it is, where do I buy this? :)
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 15:47:09
It retailss for $499 and you already have to have Access but if you're lookng at it vs. $210 per seat, this may be cost effective since it includes royalty-free runtime for Access.
Just an option that you might consider if you want to give them regular Access forms, reports, etc. at the local level.
EDIT: Oh yeah, here's the link:
http://msdn.microsoft.com/howtobuy/vsto/default.aspx
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 15:53:35
O.K....to recap (and, since I can never understand a word Microsoft says on theri website)
If I buy this 500 dollar program, I will be able to, in a sense, convert my current access database made into, in a sense, an executable file. The user will still be able to do everything before (enter data, manipulate data, etc); however, they will not be able to create queries, change the table format, etc etc? Also, I would only need one copy and I could copy my new program to each cpu then, correct?
If this is the case, then I'm buying it !!!
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 16:10:53
That's the way it has worked in the past. However, I personally no longer distribute Access runtime applications and haven't since Access '97. However, I'm sure that there are folks still out there that do. Maybe check a few Access developer forums to confirm?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1296
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Question regarding MS Access and Licensing - 6/3/2005 16:13:23
I think I'm going to...thanks for all of your help...again!!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 