Mich-
What you need to keep in mind is that MSDE is - for all intents and
purposes - the same as SQL Server (with a few limitations). Therefore, to
make a copy of a database, you would need to do more than copy the files.
After the files are copied (which must be done either when MSDE is not
running or when the databases are not attached), you would need to attach
them (look for sp_attach_db in Books OnLine).
If you drop a SQL Server datababase, the database files are deleted. If you
want to remove the database from SQL Server but keep all of the data, you
will need to detach the database (look for sp_detach_db in Books OnLine).
Hope this helps!
Chuck Heinzelman - MCSD, MCDBA
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server and its community of
SQL Server professionals.
www.sqlpass.org [quoted text, click to view] "M Skabialka" <mskabialka@NOSPAMdrc.com> wrote in message
news:OtrdmgrGFHA.560@TK2MSFTNGP12.phx.gbl...
> New to MSDE (as of today)
>
> I have used Access for many years, and understand the FE/BE connection;
each
> is a separate database, linked together.
>
> I installed MSDE and opened the Northwind database which looks the same as
> in Access. I made a copy of it (copy, paste) then changed some of the
table
> info in one version. I looked at the table in the other version and it
has
> also changed.
>
> Am I right in thinking that all tables for all of my databases will be
> residing in the same place? Even for other databases?
>
> I had upsized a database and used the same tables somehow (long day...
what
> did I do???)
> I made a new database as a test, used the same tables, then Dropped the
SQL
> database. Is that like unlinking or are those tables gone for good?
> Or can I somehow link back to them / reconnect?
>
> Is there info out there to explain all this to newcomers?
>
> Thanks,
> Mich
>
>
>
>
>
