If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
access for others
I am running Access 2k--as part of Office 2k pro. I work in a church
leadership and am designinga database to help us manage the day to day of the congregation. we all have laptops but not all have access. Is there a way to put it on a server without access and let them all beable to use it even w/o having to buy access? |
#2
|
|||
|
|||
access for others
On Sat, 13 Dec 2008 06:12:00 -0800, DeanLinCPR
wrote: I am running Access 2k--as part of Office 2k pro. I work in a church leadership and am designinga database to help us manage the day to day of the congregation. we all have laptops but not all have access. Is there a way to put it on a server without access and let them all beable to use it even w/o having to buy access? Well... only partially. You will need to purchase the appropriate "Runtime" license; there are different way sto do this depending on version. See http://www.granite.ab.ca/access/developereditionfaq.htm for details. This might be one reason to upgrade to 2007 - the runtime is free. The Developer's Edition for 2000 (if it's still available at all, that's four generations back) was pretty pricey. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
access for others
Hi,
The Access 2007 runtime is free to download from Microsoft (http://www.microsoft.com/downloads/d...displaylang=en) and can open/use older database versions. Clifford Bass "John W. Vinson" wrote: On Sat, 13 Dec 2008 06:12:00 -0800, DeanLinCPR wrote: I am running Access 2k--as part of Office 2k pro. I work in a church leadership and am designinga database to help us manage the day to day of the congregation. we all have laptops but not all have access. Is there a way to put it on a server without access and let them all beable to use it even w/o having to buy access? Well... only partially. You will need to purchase the appropriate "Runtime" license; there are different way sto do this depending on version. See http://www.granite.ab.ca/access/developereditionfaq.htm for details. This might be one reason to upgrade to 2007 - the runtime is free. The Developer's Edition for 2000 (if it's still available at all, that's four generations back) was pretty pricey. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
access for others
On Sun, 14 Dec 2008 15:24:01 -0800, Clifford Bass
wrote: Hi, The Access 2007 runtime is free to download from Microsoft (http://www.microsoft.com/downloads/d...displaylang=en) and can open/use older database versions. That's what I said, Clifford: This might be one reason to upgrade to 2007 - the runtime is free. The Developer's Edition for 2000 (if it's still available at all, that's four generations back) was pretty pricey. You'll need to develop the app in 2007 full version in order to use it with the runtime, though, I'm pretty sure. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
access for others
Hi John,
Actually, what you wrote and what I wrote were slightly different. You were saying he had to upgrade. I was saying he did not. However, since I don't always double-check something before I post, I did a quick test. On a machine with Office 2003 and Access 2007 Runtime (Office 2007 never installled) I was able to do this: Create a 2003 database with a table and a form. Converted it to Access 97. Yes, I know he did not specify as old as 97, but I was curious. Opened it and added a record using the Access 2007 Runtime. Interestingly, the runtime asked / recommended I convert the database. I chose not to the first time. The second time I chose to do so, and it converted it to a 2007 database, with an "error" about Access 2007 databases no longer supporting user-level security. Opening a 2000 or later database does not seem to invoke the prompting to convert. One annoying thing that I have not attempted to deal with: When you jump back and forth between Access 2003 and Access 2007 Runtime, they both go through their "installing" process. Clifford Bass "John W. Vinson" wrote: On Sun, 14 Dec 2008 15:24:01 -0800, Clifford Bass wrote: Hi, The Access 2007 runtime is free to download from Microsoft (http://www.microsoft.com/downloads/d...displaylang=en) and can open/use older database versions. That's what I said, Clifford: This might be one reason to upgrade to 2007 - the runtime is free. The Developer's Edition for 2000 (if it's still available at all, that's four generations back) was pretty pricey. You'll need to develop the app in 2007 full version in order to use it with the runtime, though, I'm pretty sure. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
access for others
On Mon, 15 Dec 2008 09:10:01 -0800, Clifford Bass
wrote: Create a 2003 database with a table and a form. Converted it to Access 97. Yes, I know he did not specify as old as 97, but I was curious. Opened it and added a record using the Access 2007 Runtime. VERRY interesting. I'm glad to know that! One annoying thing that I have not attempted to deal with: When you jump back and forth between Access 2003 and Access 2007 Runtime, they both go through their "installing" process. One reason I've been putting off installing 2007. Need to get that done soon though... once I get my second machine rebuilt. Thanks for the correction, Clifford! -- John W. Vinson [MVP] |
#7
|
|||
|
|||
access for others
You are welcome John!
Clifford Bass "John W. Vinson" wrote: On Mon, 15 Dec 2008 09:10:01 -0800, Clifford Bass wrote: Create a 2003 database with a table and a form. Converted it to Access 97. Yes, I know he did not specify as old as 97, but I was curious. Opened it and added a record using the Access 2007 Runtime. VERRY interesting. I'm glad to know that! One annoying thing that I have not attempted to deal with: When you jump back and forth between Access 2003 and Access 2007 Runtime, they both go through their "installing" process. One reason I've been putting off installing 2007. Need to get that done soon though... once I get my second machine rebuilt. Thanks for the correction, Clifford! -- John W. Vinson [MVP] |
#8
|
|||
|
|||
access for others
Yes, users can install Access2007 runtime. You can use Access2000 to deploy
your application. 1. You’ll need to edit the users registry to enable the macro warning message. 2. Do not use ActiveX. 3. Do note of windows updates as sometimes it can cause problems. 4. Or use Access2007 with Developer Extension to deploy on a secure/trusted location. Usually there’s no problem with a machine on windows xp and A2K7 runtime, sometimes windows update can cause problem, which I had decovered. All you need to do is just recompile, compact and repair, make the mde again or sometime a little code change does wonders. However, if the users are using Vista, you may need to do more work. On my early deployment, I did not encounter problems until vista updates. Example, it will failed to read a filter condition like ItemID Like ‘” & Me.ItemID & “*’” It will read text like “ACCExxx”, “ACCBxxx” but not “ACCSxxx”. This problem varies, sometimes it can sometime it can’t. Or it simply failed to read a control value. To avoid these errors, make sure you have proper error handling to trap where the errors came from. Like.. MsgBox “Error No: “ & Err.Number & “ – “ & Err.Description , “VbCritical”, “TitleWhereEventFailedNamed” Hope this will help. DeanLinCPR wrote: I am running Access 2k--as part of Office 2k pro. I work in a church leadership and am designinga database to help us manage the day to day of the congregation. we all have laptops but not all have access. Is there a way to put it on a server without access and let them all beable to use it even w/o having to buy access? -- Please Rate the posting if helps you Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200812/1 |
Thread Tools | |
Display Modes | |
|
|