|
Home > Archive > MS Access project with SQL Server > April 2005 > chnge loca where .adp creates DB on Sql Server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
chnge loca where .adp creates DB on Sql Server?
|
|
|
| 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
..
| |
| Sylvain Lafontaine 2005-04-06, 8:06 pm |
| 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.
"BF" < anonymous@discussion
s.microsoft.com> wrote in message
news:73d901c52661$2c
0b2be0$a601280a@phx.gbl...
> 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
> .
>
>
| |
| Jess Martyn 2005-04-19, 7:24 am |
| Dear Friend,
Make Money online by filling out simple surveys. Check out
http://www.extremedesigners.5u.com and look for "Make Money" link there and
get going.
Best of luck.
"BF" < anonymous@discussion
s.microsoft.com> wrote in message
news:73d901c52661$2c
0b2be0$a601280a@phx.gbl...
> 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
> .
>
>
|
|
|
|
|