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  

Is it possible to run a MS Access database without having Access .



 
 
Thread Tools Display Modes
  #1  
Old January 31st, 2005, 08:17 PM
Christina
external usenet poster
 
Posts: n/a
Default Is it possible to run a MS Access database without having Access .

My boss wants me to create a MS Access database but he wants our client to be
able to use the database without having Access installed. "Shall execute
requiring only the MS ACCESS run time software provided by the MS Office tool
suite". I have no clue what so ever how to do this. Any suggestions would
be a great help.
  #2  
Old January 31st, 2005, 09:06 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

You have to get a copy of the Access Developer's Version (Developer's
Extensions in A2003) to do this.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Christina" wrote in message
...
My boss wants me to create a MS Access database but he wants our client to
be
able to use the database without having Access installed. "Shall execute
requiring only the MS ACCESS run time software provided by the MS Office
tool
suite". I have no clue what so ever how to do this. Any suggestions
would
be a great help.



  #3  
Old February 1st, 2005, 01:51 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

Christina

In addition to Lynn's response, "yes" ... and "no"!

Behind the scenes, after you've gotten the Developer Edition and created an
application for distribution, what will have to be installed on each
client's PC is a crippled version of Access. The installation process
handles this, and the Developer Edition provides the legitimate licensing.

But it still takes up as much room (nearly) as the full-blown copy of
Access!

Does your boss wish the client not to have a way to alter the application,
or does your boss not wish to add the cost of Access? If the former, you
could create an .MDE file and distribute that to folks who had Access
installed. They would not be able to modify the application this way (and
you would not need to buy the Developer Edition).

--
Good luck

Jeff Boyce
Access MVP

"Christina" wrote in message
...
My boss wants me to create a MS Access database but he wants our client to

be
able to use the database without having Access installed. "Shall execute
requiring only the MS ACCESS run time software provided by the MS Office

tool
suite". I have no clue what so ever how to do this. Any suggestions

would
be a great help.


  #4  
Old February 1st, 2005, 02:15 PM
onedaywhen
external usenet poster
 
Posts: n/a
Default


Jeff Boyce wrote:
My boss wants me to create a MS Access database but he wants our

client to
be
able to use the database without having Access installed.


In addition to Lynn's response, "yes" ... and "no"!


When I look at a .mdb in Windows Explorer, it is described as
'Microsoft Access Database Application'. I see two elements the a
'Microsoft Access Database' a.k.a. a Jet database, and an Application.
You don't need MS Access to create, maintain and use a MS Access/Jet
database but you do require MS Access to run a MS Access application.
Which do you have, database or application?

Jamie.

--

  #5  
Old February 1st, 2005, 02:16 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

Does your boss wish the client not to have a way to alter the application,
or does your boss not wish to add the cost of Access?


Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people. We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


  #6  
Old February 1st, 2005, 07:39 PM
Sam
external usenet poster
 
Posts: n/a
Default

I need help on an issue similar to this. I have a replica of my database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the application,
or does your boss not wish to add the cost of Access?


Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people. We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



  #7  
Old February 1st, 2005, 08:00 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

Sam,
You can either provide those 2 people with a separate front-end with the 2
forms and reports that they need or, else, you can implement User Level
security and only give them permission to use the forms and reports that you
want them to. To follow the second approach is pretty difficult. You will
need to get a copy of the Security FAQ (there's a link on the Security page
of my website), read it several times, and follow it TO THE LETTER.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I need help on an issue similar to this. I have a replica of my database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the
application,
or does your boss not wish to add the cost of Access?


Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people.
We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and
the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees
came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





  #8  
Old February 1st, 2005, 09:11 PM
Sam
external usenet poster
 
Posts: n/a
Default

Thank you for replying. I'm not sure what you mean by "front-end". I prefer
the simplest method. I tried setting-up Groups and got into a real mess. I
will read the link on your web site.

"Lynn Trapp" wrote:

Sam,
You can either provide those 2 people with a separate front-end with the 2
forms and reports that they need or, else, you can implement User Level
security and only give them permission to use the forms and reports that you
want them to. To follow the second approach is pretty difficult. You will
need to get a copy of the Security FAQ (there's a link on the Security page
of my website), read it several times, and follow it TO THE LETTER.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I need help on an issue similar to this. I have a replica of my database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the
application,
or does your boss not wish to add the cost of Access?

Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people.
We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and
the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees
came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm






  #9  
Old February 1st, 2005, 10:01 PM
Sam
external usenet poster
 
Posts: n/a
Default

Hey Lynn, I can't get to your web site. Whatsup? I entered
www.Itcomputerdesigns.com and it wasn't recognized.

"Lynn Trapp" wrote:

Sam,
You can either provide those 2 people with a separate front-end with the 2
forms and reports that they need or, else, you can implement User Level
security and only give them permission to use the forms and reports that you
want them to. To follow the second approach is pretty difficult. You will
need to get a copy of the Security FAQ (there's a link on the Security page
of my website), read it several times, and follow it TO THE LETTER.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I need help on an issue similar to this. I have a replica of my database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the
application,
or does your boss not wish to add the cost of Access?

Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people.
We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and
the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees
came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm






  #10  
Old February 2nd, 2005, 01:13 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

It's not Itcomputerdesigns, but Ltcomputerdesigns.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
Hey Lynn, I can't get to your web site. Whatsup? I entered
www.Itcomputerdesigns.com and it wasn't recognized.

"Lynn Trapp" wrote:

Sam,
You can either provide those 2 people with a separate front-end with the
2
forms and reports that they need or, else, you can implement User Level
security and only give them permission to use the forms and reports that
you
want them to. To follow the second approach is pretty difficult. You will
need to get a copy of the Security FAQ (there's a link on the Security
page
of my website), read it several times, and follow it TO THE LETTER.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
...
I need help on an issue similar to this. I have a replica of my
database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get
there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the
application,
or does your boss not wish to add the cost of Access?

Jeff,
In my experience, clients typically are looking for some combination
of
those 2 things. When I first started working where I do now, we took
the
full version of Access off of all computers except for a few key
people.
We
were trying to prevent to seemingly constant proliferation of new
Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers
opened
Access and created a DB1.mdb) and to reduce the cost of purchasing
full
licenses. Obviously, the financial types wanted to reduce the cost and
the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees
came
on board or when anyone got a new computer, it seems they were given
the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm








 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 -vs- Access 2003? Mark General Discussion 5 November 30th, 2004 07:36 AM
is Access 2003 any better than XP? Gorb General Discussion 4 November 11th, 2004 10:44 PM
is Access 2003 any better than XP? Gorb Using Forms 2 November 11th, 2004 10:20 AM
Images in a database Franz General Discussion 10 October 7th, 2004 09:35 AM
Database Window Gone DaveB General Discussion 2 July 29th, 2004 12:24 AM


All times are GMT +1. The time now is 05:02 PM.


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