473,395 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Trying to determine if MSDE Database is installed and install if not

Hello,

I have an Access database front end (XP version). I would like to check the
installed MSDE or if the user wants to connect to an SQL Server, check that
and see if the database exists. If the database does not exist in the MSDE
or in the SQL Server, then I'd like to create it programatically. Any ideas
how to do this?

Jo
Nov 13 '05 #1
2 3104
Jozef wrote:
Hello,

I have an Access database front end (XP version). I would like to check the
installed MSDE or if the user wants to connect to an SQL Server, check that
and see if the database exists. If the database does not exist in the MSDE
or in the SQL Server, then I'd like to create it programatically. Any ideas
how to do this?


If you connect to the database "master" you can interrogate the
sysdatabases table to see if your database exists.

To install it would depend on how you've distributed it, e.g. if as a
backup then you need to issue the SQL command to restore it or if it's a
database file(s) then you can call the sp_attachdb stored procedure to
attach the database.

--
[OO=00=OO]
Nov 13 '05 #2
Excellent! Thanks Trevor, I'll give that a try!

Jo

"Trevor Best" <no****@besty.org.uk> wrote in message
news:42***********************@news.zen.co.uk...
Jozef wrote:
Hello,

I have an Access database front end (XP version). I would like to check
the installed MSDE or if the user wants to connect to an SQL Server,
check that and see if the database exists. If the database does not
exist in the MSDE or in the SQL Server, then I'd like to create it
programatically. Any ideas how to do this?


If you connect to the database "master" you can interrogate the
sysdatabases table to see if your database exists.

To install it would depend on how you've distributed it, e.g. if as a
backup then you need to issue the SQL command to restore it or if it's a
database file(s) then you can call the sp_attachdb stored procedure to
attach the database.

--
[OO=00=OO]

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: rdlebreton | last post by:
Hello, I work in Tech Support at a company that has a new product using the MSDE 1.0 (MSSQL 7) at its database engine. We have a growning number of clients using this product and, of course,...
1
by: Diana Finley | last post by:
Hi all, I just got SQL Server 2000, but I already have MSDE installed. Is there any reason I would want to keep MSDE around on my computer if I install SQL Server 2000? I use MS Visual Studio...
2
by: gdavid9 | last post by:
Hi all, I have MSDE installed on an HP server as some of the utilities required a database. I have also subsequently installed SQL 2000 onto this server which is a windows 2003 box. I know it...
2
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
1
by: Paul Aspinall | last post by:
Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks
3
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together...
3
by: NWx | last post by:
Hi, I write an ASP,NET application who uses SQL Server (MSDE) as Back-end I'm an experienced developer, but haven't used SQL server before and I need some help. Since I don't have full SQL...
4
by: Jason | last post by:
If I've got simple Access DB, and I've got a front end with a with a datagrid and use SQL SERver 2005 Expression edition to create the connections, develop the app then I give the DB and the...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.