Clarification about databases please.

On Wed, 26 Sep 2007 14:49:18 -0400, "Pat Hartman \(MVP\)" please no
wrote:

Hi Armen,
What do you recommend as a management tool for the Express version of SQL
Server? or does it come with SQL Management Studio?
Pat


There is an Express version of SQL Server Management Studio. It does
all the basic things you would need it to do with SQL Server Express.

It's free.

http://www.microsoft.com/downloads/d...DisplayLang=en


Armen Stein
Microsoft Access MVP
www.JStreetTech.com

On Wed, 26 Sep 2007 17:31:04 -0500, "Susan" wrote:

Thank you for your information. I am still trying to understand Access as
it relates to a website package. For instance

One package has this:

WINDOWS SERVER 2003 0.75Gb Space / 15Gb Traffic 3 Domains + Sub Domains
ASP.NET, PHP, PERL MySQL, MS Access, ODBC UNLIMITED Email Boxes H-Sphere
Control Panel $5.00/mo or $50.00/yr

The other package has the following:

UNIX LINUX 0.75Gb Space / 15Gb Traffic 3 Domains + Sub Domains PHP, PERL,
CGI, SSI MySQL Database UNLIMITED Email Boxes H-Sphere Control Panel
$5.00/mo or $50.00/yr

What is the MS Access when it is on a server? Does it mean with the other
package you could not use MS Access to connect to the MySQL database?


Typically it means that you will be allowed to place an Access MDB
file on the server, and use an ODBC driver to link to it for data. It
may also include a DSN to help web pages to link to the MDB. It does
NOT include running the Microsoft Access application on the server.

I know, it's confusing. "Access" is commonly known as both:

1) a Windows application that runs on your PC and comes with Office
Pro. It can be used to build forms, reports, etc. with data from any
modern database. It also includes a database engine called Jet right
in the box.

2) a file that contains data and other Access objects. This file
usually has an MDB extension. It can be used by web pages and other
programs without the Microsoft Access application.

The server package above is using the 2nd definition.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Thank you very much. I think this will help me now.
http://www.ucl.ac.uk/is/mysql/access/
I have Office 2007 which does have the Access like you said.


"Armen Stein" wrote in message
...
On Wed, 26 Sep 2007 17:31:04 -0500, "Susan" wrote:

Thank you for your information. I am still trying to understand Access as
it relates to a website package. For instance

One package has this:

WINDOWS SERVER 2003 0.75Gb Space / 15Gb Traffic 3 Domains + Sub Domains
ASP.NET, PHP, PERL MySQL, MS Access, ODBC UNLIMITED Email Boxes H-Sphere
Control Panel $5.00/mo or $50.00/yr

The other package has the following:

UNIX LINUX 0.75Gb Space / 15Gb Traffic 3 Domains + Sub Domains PHP, PERL,
CGI, SSI MySQL Database UNLIMITED Email Boxes H-Sphere Control Panel
$5.00/mo or $50.00/yr

What is the MS Access when it is on a server? Does it mean with the other
package you could not use MS Access to connect to the MySQL database?


Typically it means that you will be allowed to place an Access MDB
file on the server, and use an ODBC driver to link to it for data. It
may also include a DSN to help web pages to link to the MDB. It does
NOT include running the Microsoft Access application on the server.

I know, it's confusing. "Access" is commonly known as both:

1) a Windows application that runs on your PC and comes with Office
Pro. It can be used to build forms, reports, etc. with data from any
modern database. It also includes a database engine called Jet right
in the box.

2) a file that contains data and other Access objects. This file
usually has an MDB extension. It can be used by web pages and other
programs without the Microsoft Access application.

The server package above is using the 2nd definition.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Armen Stein wrote in
:

I know, it's confusing. "Access" is commonly known as both:

1) a Windows application that runs on your PC and comes with
Office Pro. It can be used to build forms, reports, etc. with
data from any modern database. It also includes a database engine
called Jet right in the box.

2) a file that contains data and other Access objects. This file
usually has an MDB extension. It can be used by web pages and
other programs without the Microsoft Access application.

The server package above is using the 2nd definition.

That is, what they mean is:

You can use a Jet MDB to store your data.

Access is simply not involved in any way, shape or form on the
server.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Thank you very much! I downloaded the mysql-connector-odbc-3.51.20 driver.
Set up the DSN and connected to the MySQL database on the website. I was
able to open MS Access and import a table and now have the table in Access.
I did have problems with an Access is denied error #1044 but it cleared up
after I downloaded the driver from a different source and repeated the
steps. This opens a whole new world for working with data. Now to learn
about forms, and reports.

Yes I have problems with terminology since words have multiple definitions.
Access with mentioned in website package and forms (which after working with
form tags) made me think of website. I believe "form" in Access must mean
form like a paper form. I will learn but am so grateful to newsgroups and
the internet for obtaining answers. Now to buy a book on Access!

Thanks,
Susan

"David W. Fenton" wrote in message
. 97.142...
Armen Stein wrote in
:

I know, it's confusing. "Access" is commonly known as both:

1) a Windows application that runs on your PC and comes with
Office Pro. It can be used to build forms, reports, etc. with
data from any modern database. It also includes a database engine
called Jet right in the box.

2) a file that contains data and other Access objects. This file
usually has an MDB extension. It can be used by web pages and
other programs without the Microsoft Access application.

The server package above is using the 2nd definition.

That is, what they mean is:

You can use a Jet MDB to store your data.

Access is simply not involved in any way, shape or form on the
server.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/