access for others

  • Thread starter Thread starter DeanLinCPR
  • Start date Start date
D

DeanLinCPR

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?
 
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?
Click to expand...

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.
 
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
 
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.
Click to expand...

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.
Click to expand...

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!
 
You are welcome John!

Clifford Bass

John W. Vinson said:
VERRY interesting. I'm glad to know that!


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!
Click to expand...
 
Back
Top