| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 17 December 2004 : 21:42:29
|
quote:
Originally posted by Doug G
If you have Access 2000 or higher, you can use it as a graphical front end to manage your MSDE engine. You can do nearly all management tasks from Access that you can do using EM.
great minds think alike...
quote:
Originally posted by dayve
...However, you can do maintenance on an MSDE database with certain development tools like Visual Studio and even some stuff can be accomplished using linked tables in an Access database...
you can also use 2eNetWorx TableEditor for some management of the MSDE database (I believe). |
 |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 December 2004 : 02:34:14
|
To use access with your MSDE you want to creat an Access Data Project (.adp) file, not a regular .mdb file. Search the online help for details on creating and using a data project. You can create SQL Databases, manage users, design tables, diagrams, views, and stored procedurs.
I use .adp's to manage some remote SQL Servers and hardly ever need EM or any other tool.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 18 December 2004 : 07:40:38
|
quote:
Originally posted by pdrg
MSDE was patched for slammer!
The MSDE patch for Slammer came after the fact. Microsoft had already posted a patch for the other versions before the worm hit the web.
I was running MSDE at the time.  |
 Nathan Bales
CoreBoard | Active Users Download |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 18 December 2004 : 16:08:20
|
quote:
Originally posted by Doug G
To use access with your MSDE you want to creat an Access Data Project (.adp) file, not a regular .mdb file. Search the online help for details on creating and using a data project. You can create SQL Databases, manage users, design tables, diagrams, views, and stored procedurs.
I use .adp's to manage some remote SQL Servers and hardly ever need EM or any other tool.
well, I learned something new. although I am partial towards EM, this is a great feature of MS Access. I've always used Access in a fasion using linked tables to do simple management of a SQL database like queries and hot edits. I'll now have to use adp's instead.
setting this us was extremely easy as well... looks like you have your answer stimmie. |
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 December 2004 : 20:06:00
|
quote:
Originally posted by dayve
quote:
Originally posted by Doug G
To use access with your MSDE you want to creat an Access Data Project (.adp) file, not a regular .mdb file. Search the online help for details on creating and using a data project. You can create SQL Databases, manage users, design tables, diagrams, views, and stored procedurs.
I use .adp's to manage some remote SQL Servers and hardly ever need EM or any other tool.
well, I learned something new. although I am partial towards EM, this is a great feature of MS Access. I've always used Access in a fasion using linked tables to do simple management of a SQL database like queries and hot edits. I'll now have to use adp's instead.
setting this us was extremely easy as well... looks like you have your answer stimmie.
Indeed I do |
-Stim |
|
|
|
homeacademy
Junior Member
USA
163 Posts |
Posted - 19 December 2004 : 08:33:15
|
I have been playing with SQL Server 2005 Express (http://www.microsoft.com/sql/express/) for the past couple of weeks and really like it. Everything about it is still in Beta, but it works very well so far for me. It runs on .NET Framework 2.0. It is designed to be a replacement for MSDE and will always be free. It also will come with 'Express Manager' GUI, which is a slimmed-down version of query analyzer/enterprise manager for managment (also free). This feature is only out in a very limited version so isn't overly useful currently but should be great once finished. 2005 Express does not have a performance governer (unlike MSDE) and supports most of the new features of SQL 2005 full version. If you're interested, I recommend the Demeber CTP version of it instead of the Beta 2 (it is supposedly less tested but works for me and it allows you to run the Preview Release of Express Manager to check it out). That version can be downloaded from here: http://blogs.msdn.com/sqlexpress/ . If anyone else messes with this, I'd like to know their opinions.
On another note -- I didn't know about the management features of Access as described above. Kewl! I'll have to go check that out, thanks for the info! |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 20 December 2004 : 05:23:03
|
quote:
Originally posted by Nathan
quote:
Originally posted by pdrg
MSDE was patched for slammer!
The MSDE patch for Slammer came after the fact. Microsoft had already posted a patch for the other versions before the worm hit the web.
I was running MSDE at the time.
In fact the sp3 patch for SQL Server also covered MSDE, but maybe they only released a QFE patch for the fuller products? This would be consistent, as QFE's are not as fully QA'd (by definition, if you think about it) as a public service pack.
Re CTP of SQLExpress:
Key Note: This CTP release of SQL Server Express is intended only for standalone users and should not be used in conjunction with Microsoft Visual Studio 2005 products. If you are installing any of the Microsoft Visual Studio 2005 products (such as Microsoft Visual C++, Microsoft Visual C#, Microsoft Visual J#, Microsoft Visual Basic, or Microsoft Visual Web Developer Express Edition), make sure you install only the version of SQL Server Express Edition that is included as part of the Visual Studio 2005 setup.
Make sure you read the words on the box before doing anything that may mess with your PC!! |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 30 December 2004 : 23:28:45
|
quote:
Originally posted by Da_Stimulator
quote:
Originally posted by dayve
quote:
Originally posted by Doug G
To use access with your MSDE you want to creat an Access Data Project (.adp) file, not a regular .mdb file. Search the online help for details on creating and using a data project. You can create SQL Databases, manage users, design tables, diagrams, views, and stored procedurs.
I use .adp's to manage some remote SQL Servers and hardly ever need EM or any other tool.
well, I learned something new. although I am partial towards EM, this is a great feature of MS Access. I've always used Access in a fasion using linked tables to do simple management of a SQL database like queries and hot edits. I'll now have to use adp's instead.
setting this us was extremely easy as well... looks like you have your answer stimmie.
Indeed I do
Well... I tried that connecting to an sql db... and it worked to a point. But every time I try to do something (create a table, remove a table, open a table in design view, open a table to retrieve records) it gives me an ADO error, every stinkin time.... |
-Stim |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 31 December 2004 : 17:03:19
|
What's the error? I use .adp's to manage 3 or 4 SQL 2000 servers in another city via DSL, with some forms and vba coding directly against the db as well as the normal access forms. I have no problems creating tables, editing data, creating and running sp's, etc. In my case I'm using Access 2000 and Access 2002.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 03 January 2005 : 12:07:18
|
It turns out the server I was connected to was in the process of restarting just as I'd connected, so I got the table information, but when I went to go for more there was nothing and it threw errors.
Works good now though :) |
-Stim |
|
|
|
Topic |
|
Topic Locked
