RE: MSDE - where are data/index files?

2002-05-29 Thread Dave Watts
> Just installed MSDE (2000) and its working nicely. But I > can't find the database I created. It doesn't appear to be > in c:\program files\Microsoft SQL Server\MSSQL\Data\ > although there are four data files in there (master, model, > msdbdata, tempdb). None appear to be the one I created

RE: MSDE - where are data/index files?

2002-05-29 Thread Matt Robertson
Dave wrote, > When you create a database, it's up to you to specify where > the data and log files will be created. Depending on how you > created the database Well, now I'm doubly mystified. I ran the MSDE install off my Office XP CD. Of course there was no enterprise manager, so my next st

Re: MSDE - where are data/index files?

2002-05-29 Thread Joseph Thompson
Try searching for .adp files. You can open Access, and then choose "new project". This will give you a new "blank" database with support for triggers stored procs etc. When I installed MSDE I had to also install some "visual design" components off the Office CD that where not installed at the s

RE: MSDE - where are data/index files?

2002-05-29 Thread Dave Watts
> > When you create a database, it's up to you to specify where > > the data and log files will be created. Depending on how you > > created the database ... > > Well, now I'm doubly mystified. I ran the MSDE install off > my Office XP CD. Of course there was no enterprise manager, > so my

RE: MSDE - where are data/index files?

2002-05-29 Thread Matt Robertson
Dave wrote, > Well, in that case, you didn't create a database at all > - you just created tables in the default database. I suspected as much. Fortunately I'm only playing on a dev box so no permanent damage is done. I see now the place where I select the db - the ''change the default datab

Re: MSDE - where are data/index files?

2002-05-29 Thread Joseph Thompson
Digging around turned up this link to the Maryland CFUG site. If you are still having trouble (or just want a quick read) http://www.cfug-md.org/articles/upsizefrommsaccesstosqlserver.cfm __ This list and all House of Fusion re