creating database

R

ronreggin

I am thinking about purchasing Access. I would like to know if I create a
database in Access on my computer, would I need Access on another computer to
use the database or view it? I know it may seem like an easy question but I
have never used Access.

Thank you for the help,
Joe
 
R

Roger Carlson

Access is a desktop database system, so you can use it on a single computer
with no problem. However, it is also a multi-user database, so if you need
to extend it to more than one person, you can do that as well. In a
multi-user environment, it is recommended to split the database into two, a
Back-End (containing just the tables) and a Front-End (containing the forms,
reports, queries, macros, and code). If you're interested, search the
newsgroup on "split database", Front end, Back end, etc.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
D

Dodo

I am thinking about purchasing Access. I would like to know if I
create a database in Access on my computer, would I need Access on
another computer to use the database or view it? I know it may seem
like an easy question but I have never used Access.

Thank you for the help,
Joe
Click to expand...

To use it: yes.
To view it: there are viewers available.
 
J

James Arnold

Yes, Access is required on any machines you wish to view the database
with. If you are storing a backend on a network drive I do not think you
need it installed on that, so long as the JET drivers are installed. It
would be required for anyone wanting to access it, however. Need someone
to clarify this.
 
D

Douglas J Steele

Dodo said:
To use it: yes.
To view it: there are viewers available.
Click to expand...

What kind of viewer are you talking about? Unlike Word or Excel, there isn't
an Access Viewer. You must have Access installed (either the full version or
the runtime version) to use an Access application.
 
D

Dodo

What kind of viewer are you talking about? Unlike Word or Excel, there
isn't an Access Viewer. You must have Access installed (either the
full version or the runtime version) to use an Access application.
Click to expand...

Just for viewing!
Actually I thought there were more and easier to use.

So, apart from the SnapShot viewer?

http://www.microsoft.com/downloads/details.aspx?FamilyId=B73DF33F-6D74-
423D-8274-8B7E6313EDFB&displaylang=en
Or TinyURLed: http://heh.pl/&15V


I haven't tried any of them, but have a look here:

http://www.shareware.de/Windows/Datei__Datenverwaltung/Organisation/Sonstig
es/Detail_Access_Viewer_18679.html
Or TinyURLed: http://heh.pl/&15S

http://www.totalcmd.net/plugring/mdb.html

http://www.db-review.com/one/25.htm

http://www.db-review.com/one/2.htm


Plus plenty tools to view on PDAs and SmartPhones.
 
D

Douglas J Steele

Dodo said:
Just for viewing!
Actually I thought there were more and easier to use.

So, apart from the SnapShot viewer?

http://www.microsoft.com/downloads/details.aspx?FamilyId=B73DF33F-6D74-
423D-8274-8B7E6313EDFB&displaylang=en
Or TinyURLed: http://heh.pl/&15V
Click to expand...

I think calling SnapShot viewer an "Access Viewer" is very misleading. All
the SnapShot viewer can view is snapshots: reports saved in the special
snapshot format (akin to .PDF). You can't give an MDB file to someone and
expect them to be able to use the file with the SnapShot viewer.
I haven't tried any of them, but have a look here:

http://www.shareware.de/Windows/Datei__Datenverwaltung/Organisation/Sonstig
es/Detail_Access_Viewer_18679.html
Or TinyURLed: http://heh.pl/&15S

http://www.totalcmd.net/plugring/mdb.html

http://www.db-review.com/one/25.htm

http://www.db-review.com/one/2.htm
Click to expand...

From what I can see, all these products do is let you look at the data
within the tables in the database. (Presumably you can also look at the data
using queries defined within the database.)

An Access MDB is far more than that: it's forms, reports, macros and
modules. Just giving someone the ability to extract the raw data, without
any context, doesn't strike me as that useful. You can extract the data into
any ODBC- or OleDB-compliant client: Excel or Word, for instance, but that
isn't the same as being able to "view" the application.
 
D

Dodo

From what I can see, all these products do is let you look at the data
within the tables in the database. (Presumably you can also look at
the data using queries defined within the database.)

An Access MDB is far more than that: it's forms, reports, macros and
modules. Just giving someone the ability to extract the raw data,
without any context, doesn't strike me as that useful. You can extract
the data into any ODBC- or OleDB-compliant client: Excel or Word, for
instance, but that isn't the same as being able to "view" the
application.
Click to expand...

Right!
Probably there is no and never will be an exact "viewer" equivalent of
Access to view all components inside an MDB.
Or is OpenOffice an alternative? Version 2 has the Base module added.

Do you know these tools:

http://www.softpedia.com/get/Internet/Servers/Database-Utils/MDB-View.shtml

http://www.softpedia.com/get/Internet/Servers/Database-Utils/Munin.shtml

If I find additional ones, I will report them here.
 
Top