General Questions

[Guest]

I have a couple of questions that I could use some help on. I have been
hired to fix up Access Databases 2003 as a contractor. Apparently they are
running quite slow. Most of my database experience has been with SQL sever.
I have been reading, reading and reading to try to learn as much as possible
on Access 2003. I was planning at starting by getting a full database
schematic together to see if it is a true relational database but I am always
open to suggetions. I was hoping people can help me with some questions I
have.

1) What size is an access database capable of handling before it starts
having performance issue and you need to start thinking of moving to SQL
server

2) How many people can log onto an shared Access Database before you run
into problems.

3) Are there any monitoring tools that can help me annalize preformance issues

 

[Tony Toews]

I have a couple of questions that I could use some help on. I have been
hired to fix up Access Databases 2003 as a contractor. Apparently they are
running quite slow.

Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Most of my database experience has been with SQL sever.

Then I have to ask if you are the right person for the job? Or do you
have the proverbial hidden agenda to get them over to SQL Server.
Which may or may not be appropriate depending on the circumstances.

I was planning at starting by getting a full database
schematic together to see if it is a true relational database

You probably meant to say normalized rather than true relational
database. Or did you?

1) What size is an access database capable of handling before it starts
having performance issue and you need to start thinking of moving to SQL
server

1.99 Gb. Seriously though if the database is properly indexed you
can go a long ways.

How big is your current BE?

2) How many people can log onto an shared Access Database before you run
into problems.

Updating is somewhere between 10 and 25. That's just an educated
guess. Read only reporting up to 255.

So how many users are using it on a regular basis?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm


Then I have to ask if you are the right person for the job? Or do you
have the proverbial hidden agenda to get them over to SQL Server.
Which may or may not be appropriate depending on the circumstances.


You probably meant to say normalized rather than true relational
database. Or did you?

1.99 Gb. Seriously though if the database is properly indexed you
can go a long ways.

How big is your current BE?


Updating is somewhere between 10 and 25. That's just an educated
guess. Read only reporting up to 255.

So how many users are using it on a regular basis?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Tony,

I appreciate the feedback. To answer a couple of your questions is No I do
not know if I am the right person for the job but I love challenges and they
offered me the position knowing my backround.

2 Yes I meant to say normalized instead of relational database

3) I knew that there are limitations on Access 2003 databases and were
wondering what they were before performance issues.

But yes you bet I will recomend SQL server if I walk into the shop and they
are running a database of 3 Ghz and have 25 to 30 people using it. I do not
know if this is true since I start on Monday 2/13 that is why they are
general questions.

I do not know how many users there are but do know that Access is an desktop database application. I am just gathering information so I know where I can start.

That is also why I was wondering if there were any tools out there that can
help determine performance problems like in SLQ server like the SQL profiler
or Windows Monitoring Tool.