SQL Server

S

Sean H

I have a database that is getting too large (around 2.1 gigs), and I am
looking into SQL servers. Is there software/hardware I need to buy from
Microsoft? Also, where is the ODBC driver located so that I can install the
newest one?
 
A

Albert D.Kallal

Sean H said:
I have a database that is getting too large (around 2.1 gigs)
Click to expand...

The above number cannot be correct, as that is already beyond the max size
of a database.

When you do a compact and repair..what is the size of the database?
and I am
looking into SQL servers. Is there software/hardware I need to buy from
Microsoft?
Click to expand...

Microsoft has a number of free sql server databases right now. You can grab
the express edition here:

download:
http://lab.msdn.microsoft.com/express/sql/default.aspx

about:
http://www.microsoft.com/sql/express/
Also, where is the ODBC driver located so that I can install the
newest one?
Click to expand...

Hum, I never updated the one that came with ms-access, but your question,
and idea is good.....I let someone else chime in on this one...
 
A

Arvin Meyer

Have you compacted the database? Make sure you have a copy first, as you
have already exceeded the limits of Access and are likely to damage your
data if you can't compact. You may find that after compacting, the database
is a fraction of its former size.

If you go to SQL-Server, and I recommend that you do if your size is
anywhere near 1 GB, you will need to buy the software from Microsoft, and
the licenses for each computer to connect to it. You probably already have
the ODBC drivers, but if not, you'll get what you need with the SQL-Server
software.

I suggest hiring a local professional to assist with the conversion. You
probably do not need to change the front-end database, so I'd be wary of
anyone who tells you otherwise.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
S

Sean H

I haven't compacted the database yet, but I am sure I can get it much
smaller. We are running a two man operation and I wanted to know what the
proper SQL software might be (workgroup, etc.) to set up an SQL database. My
boss is asking me to help him set up an SQL server and I dont know the first
thing about any of this. I'm not sure what his outlook is on who will be
accessing this database or anything of that nature.
 
A

Arvin Meyer [MVP]

I would follow recommended practices for compacting immediately. You already
have exceeded the limits of an Access database and not doing so make the
chance of corruption virtually 100%. Make sure you have a backup copy first.
You may have to build an empty database and import the tables 1 at a time
because it may be impossible to compact at this point.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top