A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

access for others



 
 
Thread Tools Display Modes
  #1  
Old December 13th, 2008, 03:12 PM posted to microsoft.public.access.tablesdbdesign
DeanLinCPR
external usenet poster
 
Posts: 4
Default 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  
Old December 13th, 2008, 07:04 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 15th, 2008, 12:24 AM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old December 15th, 2008, 12:52 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 15th, 2008, 06:10 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old December 15th, 2008, 11:01 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 15th, 2008, 11:28 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old December 16th, 2008, 03:07 AM posted to microsoft.public.access.tablesdbdesign
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.