Problem

  • Thread starter Thread starter Kelbert via AccessMonster.com
  • Start date Start date
K

Kelbert via AccessMonster.com

I have an interesting problem. I am not aware that Microsoft installed Excel
ontu my computer. I'm trying to run Microsoft Access and maek a database,
but my consultant sid that because Excel is on my computer, I can't run
Access. I have to choose either Excel (a scale-down version of Access) or the
full blown version of Access (Access). I know how to create a database, and
How to use Excel, too.

Here'se the problem. On all of our computers (we have 12 of them now), there
are emails, letters, and dataabases inside of them on the computer. How do I
use Excel and Access to bring in all the information from all the computers,
into 1 database?
 
Kelbert,

Microsoft Office Professional includes both Access, and Excel. I can tell
you first hand that both will run on one machine. I am not sure why someone
would tell you differently. If you want to make one database and have all
the other PC access the database? If that is what you want to do then you
need to have a network setup and make sure that there is an area where all
12 PCs can get to the database.

Rodger
 
Kelbert

I'm not aware of a technical reason why your computer couldn't have both
Excel and Access installed. This is a very common configuration.

Perhaps your consultant is referring to some licensing restrictions specific
to your installation?

By the way, Excel is not a "scaled down version of Access". The two
applications operate in different ways, and require different ways of
thinking about data and organization of data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Fire your consultant. Excel is not a scale-down version of Access. They are
two separate and different applications that are both part of the Microsoft
Office Suite.

Excel is a spreadsheet program and Access is a database program. They serve
two different purposes. It is possible to share data between them. It is
done all the time.

If it is possible you have a runtime version of Access installed along with
a complete version of Access, there are some issues that have to be addressed
so they don't conflict, but anyone who says you can't install Access if you
have Excel is very incompetent.

Find someone who knows what they are doing.
 
Back
Top