chnge loca where .adp creates DB on Sql Server?

  • Thread starter Thread starter BF
  • Start date Start date
B

BF

Hello,

(my appologies for double posting - first posted in the MS
Public Access NG - then I saw this one)

I have been experimenting with creating Sql Server DBs
from the Access .adp files. A problem that I am concerned
with is that there seems to be a default location where
the .adp creates the DB. In my case it creates all the
new DB files on the server computer at C:\Program
Files\Microsoft Sql Server\MSSQL\Data. The problem is
that this drive is pretty small compared to other drives
on the server where the main MDF files are stored. As my
place upgrades to Access 2002 from Access97, I could see
the C drive of the server getting inundated with a bunch
of new DBs from everyone's .adp's and thus choking the C
drive of the server. So, is there a way to change the
location where the .adp creates a new Sql DB? I did not
see any options for that on the create wizard. Maybe
there is a registry setting or something that could be
manipulated on each person's workstation?

Thanks,
BF
..
 
Your best option is to use SQL Server' Enterprise Manager to create the
database. You can buy the Developer Edition of SQL-Server for 50$. A good
choice if your plans are to use SQL-Server for development purposes.

Also, don't forget that the SQL-Server 2005 Express (free) will come out in
a few months (?). You can already play with the Beta version.

There are also other programs on the web that, like Enterprise Manager, will
give you the possibility of creating/editing databases on SQL-Server with
more options than Access.

S. L.
 
Back
Top