MULTIPLE INSTANCES OF MSACCESS.EXE RUNNING ON SERVER

I have a Windows 2003 Server that has about 10 instances of MSACCESS.EXE running on it. Employees access a databse on this same server. I would like to know if this is normal for the processes to not close when each employee ends there session.
hcp27Asked:
Who is Participating?
 
0791882310Connect With a Mentor Commented:
sql can't run an access database... that's the whole point of sql to be a more reiable server side database "gateway".... you need to make sure that they are running access directly on their own computer... and where does sql come into the mix??... it would be working like....

access is installed on clients computer...
database is stored on server...
location of folder database is stored on is mapped as a drive on clients computer...
client opens database from access...

nothing should be going on with sql.....

and access shouldn't be running at all on the server....

0
 
0791882310Commented:
weeeeelllll.... are employees using access from their client computer and just connecting to a database on the server??.. if so i'm pretty sure msaccess.exe shouldn't be running at all....
0
 
hcp27Author Commented:
Yes, employees are using access from there own workstation and connecting to the database on the server. I am new to SQL and access databases but didn't think this was normal.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
hcp27Author Commented:
I just ended all processes of MSACCESS.EXE running on our server, which was about 12 total. Immediately after another process of MSACCESS.EXE started.
0
 
jmoss111Commented:
Is the database split into front end and back end and the front end app is on the users workstation like it should be?
0
 
hcp27Author Commented:
Yes, its split into front and and backend and the front end app is on each workstation.
0
 
jmoss111Commented:
What has this got to do with SQL Server?
0
 
jmoss111Commented:
And as 079188... said, there should be no occurences of Access running, unless the front end is a link and not the app itself.
0
 
hcp27Author Commented:
We use SQL to manage our database and needed to know if having so many instances of MSACCESS.EXE running was normal. As i said before I was unfamiliar with both and was looking for a solution to fix this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.