473,666 Members | 2,208 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Create access database at runtime with C#

Hi all PRO,

I don't know how to create the MSAccess database in the runtime with C#, Are
there any body know how to do this? I am pretty sure that all of you know
how to do it, except me :( . Thanks you so much in advance, I am deeply
appreciated for your help. Take care and have a good one...

Kate
Nov 17 '05 #1
3 2731
"cql90" <cq***@yahoo.co m> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hi all PRO,

I don't know how to create the MSAccess database in the runtime with C#,
Are there any body know how to do this? I am pretty sure that all of you
know how to do it, except me :( . Thanks you so much in advance, I am
deeply appreciated for your help. Take care and have a good one...

Kate


If you want to create the database at runtime, you can do this via the ADOX
com library. Search this group to find code examples of this is done. An
alternative is to create the database at design time, embed the .mdb
database file as a resource in your assembly and extract it at runtime. I
used this approach on a recent project and it worked quite well. If you
need code examples of how this is done, I'd be happy to post one.

CVD
Nov 17 '05 #2
Dear Cletus Van Damme,

You are so quick, unbelievable, thanks you so so much, I am greatly
appreciated. I am kind of know how to do with ADOX, but I would like to
learn how to do straight like CREATE DATABASE command, some thing like that
and also, I would like to try out OleDbCommand, OleDbDataAdapte r, etc; Take
care and have a nice day...
"Cletus Van Damme" <cl****@iforgot .com> wrote in message
news:ep******** ******@TK2MSFTN GP10.phx.gbl...
"cql90" <cq***@yahoo.co m> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hi all PRO,

I don't know how to create the MSAccess database in the runtime with C#,
Are there any body know how to do this? I am pretty sure that all of you
know how to do it, except me :( . Thanks you so much in advance, I am
deeply appreciated for your help. Take care and have a good one...

Kate


If you want to create the database at runtime, you can do this via the
ADOX com library. Search this group to find code examples of this is
done. An alternative is to create the database at design time, embed the
.mdb database file as a resource in your assembly and extract it at
runtime. I used this approach on a recent project and it worked quite
well. If you need code examples of how this is done, I'd be happy to post
one.

CVD

Nov 17 '05 #3
Dear Otis,

Thanks you very much for your responded, I am greatly appreciated. The
reason I need to create database at runtime is incase the user lost the
database, and some information is very credential, we don't want the user to
search for it, therefore we create the database at runtime and then deleted
right away. Take care and have a nice day...

Kate
"Otis Mukinfus" <Ot**********@n ewsgroup.nospam > wrote in message
news:6v******** *************** *********@4ax.c om...
On Thu, 20 Oct 2005 08:13:59 -0t700, "cql90" <cq***@yahoo.co m> wrote:
Dear Cletus Van Damme,

You are so quick, unbelievable, thanks you so so much, I am greatly
appreciated . I am kind of know how to do with ADOX, but I would like to
learn how to do straight like CREATE DATABASE command, some thing like
that
and also, I would like to try out OleDbCommand, OleDbDataAdapte r, etc;
Take
care and have a nice day...

Kate,

Cletus has told you the only two ways I know of to do what you inquire
about.

I have done it both ways myself and prefer using a pre constructed
database. But
I don't include mine as a resource. I just put a template DB in a folder
and
copy it when I want a new copy of it.

"Cletus Van Damme" <cl****@iforgot .com> wrote in message
news:ep****** ********@TK2MSF TNGP10.phx.gbl. ..
"cql90" <cq***@yahoo.co m> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hi all PRO,

I don't know how to create the MSAccess database in the runtime with
C#,
Are there any body know how to do this? I am pretty sure that all of
you
know how to do it, except me :( . Thanks you so much in advance, I am
deeply appreciated for your help. Take care and have a good one...

Kate

If you want to create the database at runtime, you can do this via the
ADOX com library. Search this group to find code examples of this is
done. An alternative is to create the database at design time, embed
the
.mdb database file as a resource in your assembly and extract it at
runtime. I used this approach on a recent project and it worked quite
well. If you need code examples of how this is done, I'd be happy to
post
one.

CVD

Otis

Nov 17 '05 #4

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

Similar topics

5
15111
by: Nathan Bloom | last post by:
Hi, I have a secured database that runs fine on the computer the database is installed on. I have several workstations with access runtime installed that also need access to the database. Access runtime runs fine when accessing an unsecured version of the database. However once the database was secured it generates a runtime error after asking for the user and password and won't open. The shortcut to the secured database is: "path...
7
8851
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
10
2368
by: Sue Bricker | last post by:
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
9
4756
by: Paul H | last post by:
As I understand it, to distribute a runtime version of Access 2003 with my app I need to spend £600 on "Visual Studio Tools for Office System package" which contains the RT plus a load of stuff I do not want. Or.... I can supply the client with a copy of "AccessRT.msi" which is on my Office 2003 pro CD and not tell anyone! Who is being more unscrupulous, me or Microsoft? Surely Microsoft forcing me
1
2725
by: ravikiranveluguleti | last post by:
hi, this is ravikiran, I have a situation where i need to create an ms-access database with one table in it at runtime when an user clicks on a button in my front end. Is there any way to create a new database at runtime in ms-access using java. plz help me thanx in advance
17
7659
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my...
1
1941
by: zuchowra | last post by:
Hello everyone Im running Access 2007. I made a sweet Data base that works flawless however, not all out computers will have access 2007. Their is some features in access 2007 in my database that will not work on earlier versions. I saw the feature for runtime which works awesome but, my question is how can i make updates to my database if its in runtime. For example: Say i use the database and dump a ton of information into it from the runtime...
3
18700
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky Assumption: Reader of this article have basic knowledge of creating data reports. Creating a Parent-Child Command and create a DataReport Suppose we have a database called company with two tables ...
1
4455
by: henrymania | last post by:
Am writing a code for database backup....by backupservlet is as given below i get the following exception
0
8443
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8550
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7385
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6192
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4366
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2769
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.