Question regarding MS Access and Licensing (Full Version)

All Forums >> [Community] >> Computer Software and Hardware issues



Message

dzirkelb1 -> 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.



bobby -> RE: Question regarding MS Access and Licensing (6/3/2005 12:08:41)

If your program requires MS-Access to run then each machine will need a licensed copy to run it.

They don't need a license to have an Access database running the "back-end" of a program, however...




Reflect -> 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 -> 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?



dzirkelb1 -> 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 -> 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 :(



bobby -> RE: Question regarding MS Access and Licensing (6/3/2005 13:21:45)

Yes, if they have to use Access to do the writing, then they'll need a licensed copy of it to do so.





dzirkelb1 -> RE: Question regarding MS Access and Licensing (6/3/2005 13:24:29)

Man, money hungry microsoft.....garble garble......210 a license.....ugh



Spooky -> RE: Question regarding MS Access and Licensing (6/3/2005 13:25:50)

Make it an intranet application? [&:]



dzirkelb1 -> 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 :(



bobby -> RE: Question regarding MS Access and Licensing (6/3/2005 13:38:31)

In that case you'd have to have a server app that could run ASP on each machine (IIS comes in XP-Pro) and then make it a web app that can run from localhost..?

Or you might be able to do something in Visual Basic that could work..?



dzirkelb1 -> 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 -> 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.



rdouglass -> 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.)



dzirkelb1 -> 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 -> 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 -> RE: Question regarding MS Access and Licensing (6/3/2005 14:26:22)

These might help:

http://office.microsoft.com/en-us/assistance/HA011208861033.aspx

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx



rdouglass -> 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



dzirkelb1 -> 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 -> 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



dzirkelb1 -> 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 -> 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?



dzirkelb1 -> 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!!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125