Access server name?

P

Polaris

Hi Experts:



I have been using SQL Server 2005 and I'm now trying to move to Access
(Microsoft Office Access 2007).



One question, with SQL Server 2005, there is a Windows Service called "SQL
Server" which is running all the time and ready to be connected from a
database application. In the case of Access, what is the equivalent program?
I do not see any Access program in the Windows Service List.



Thanks in advance!

Polaris
 
D

Dirk Goldgar

In
Polaris said:
Hi Experts:

I have been using SQL Server 2005 and I'm now trying to move to Access
(Microsoft Office Access 2007).

One question, with SQL Server 2005, there is a Windows Service called
"SQL Server" which is running all the time and ready to be connected
from a database application. In the case of Access, what is the
equivalent program? I do not see any Access program in the Windows
Service List.
Click to expand...

Access doesn't work like that, because it isn't a client/server
database. Access runs as an application, not a service. If you
double-click on an .mdb or .accdb file, that starts the Access
application and it opens the file, simlarly to how you might
double-click a .doc file to open Word to edit that file. Or you can
start Access directly and then choose what database file to open. Each
instance of Access can operate on only one "current" database at a time.
 
6

'69 Camaro

Hi.
I do not see any Access program in the Windows Service List.
Click to expand...

Access/Jet isn't a Windows service. It's a file-based database, not a
client/server database.
In the case of Access, what is the equivalent program?
Click to expand...

In _very_ loose terms (since it's not a Windows service), I suppose one
could say Jet is the equivalent program, because as soon as your database
application connects to the database file, the Jet database engine starts
running and controlling the database operations of the database file. You
may connect to the database file with a connection string if you're
programming the front end in another development environment, such as VB,
..Net, Java, et cetera. Otherwise, if you're using Access as the front end,
link to the tables in the back end (if this is a multiuser database), or use
the tables stored in the Access database file (if this is a single user
database).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
D

David W. Fenton

I have been using SQL Server 2005 and I'm now trying to move to
Access (Microsoft Office Access 2007).
Click to expand...

Don't you mean you are using Jet or the ACE, rather than Access?
 
A

aaron.kempf

ACCESS IS A CLIENT SERVER DATABASE




In




Access doesn't work like that, because it isn't a client/server
database. Access runs as an application, not a service. If you
double-click on an .mdb or .accdb file, that starts the Access
application and it opens the file, simlarly to how you might
double-click a .doc file to open Word to edit that file. Or you can
start Access directly and then choose what database file to open. Each
instance of Access can operate on only one "current" database at a time.
Click to expand...
 
Top