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
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 and am
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 and
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 step
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 same
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 step
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
7 matches
Mail list logo