J
John Bigelow
Hi.
My colleagues and I at a small consulting firm have been
using Access for some time now to analyze large data sets
provided by our clients. Each person working on the data
has one or more Access mdb applications with the data in
tables on their computer and works on the data locally.
We have been frustrated by the slow performance of Access
so we're looking for alternatives. One such alternative
that occurred to me, was that perhaps we should install
the desktop SQL server engine, use the upsizing wizard,
and work in adp projects instead of mdb.
To experiment with this I've installed the desktop engine
on one computer and tried out the upsizing wizard. I
haven't gotten very far because of the spectacularly poor
quality of the documentation for this process that is
available - at least where I can find it - within Access
help or on-line.
Having created the SQL Server database using the upsizing
wizard, I'm not even sure where on my computer this set of
data is storred. I can use the adp project to look at it
and work with it, but I can not even do something as
simple as open a second mdb file and get the table from
the second mdb file into the SQL Server database created
by the first use of the upsizing wizard. Additionally,
the use of user names, passwords, and etc for accessing
SQL Server data is extremely unclear.
So, my question is this: Where can I find a clear
straight-forward explanation of how to set up sql server
databases, add and delete data from them, move them from
one computer to another, and work with them generally
through adp projects? All the documentation I have reads
like what you see when you open a book in the middle. It
seems like it's trying to be clear, but assumes that you
already know a whole set of things that you don't know.
My colleagues and I at a small consulting firm have been
using Access for some time now to analyze large data sets
provided by our clients. Each person working on the data
has one or more Access mdb applications with the data in
tables on their computer and works on the data locally.
We have been frustrated by the slow performance of Access
so we're looking for alternatives. One such alternative
that occurred to me, was that perhaps we should install
the desktop SQL server engine, use the upsizing wizard,
and work in adp projects instead of mdb.
To experiment with this I've installed the desktop engine
on one computer and tried out the upsizing wizard. I
haven't gotten very far because of the spectacularly poor
quality of the documentation for this process that is
available - at least where I can find it - within Access
help or on-line.
Having created the SQL Server database using the upsizing
wizard, I'm not even sure where on my computer this set of
data is storred. I can use the adp project to look at it
and work with it, but I can not even do something as
simple as open a second mdb file and get the table from
the second mdb file into the SQL Server database created
by the first use of the upsizing wizard. Additionally,
the use of user names, passwords, and etc for accessing
SQL Server data is extremely unclear.
So, my question is this: Where can I find a clear
straight-forward explanation of how to set up sql server
databases, add and delete data from them, move them from
one computer to another, and work with them generally
through adp projects? All the documentation I have reads
like what you see when you open a book in the middle. It
seems like it's trying to be clear, but assumes that you
already know a whole set of things that you don't know.