473,379 Members | 1,253 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,379 software developers and data experts.

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 2715
"cql90" <cq***@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP09.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, OleDbDataAdapter, etc; Take
care and have a nice day...
"Cletus Van Damme" <cl****@iforgot.com> wrote in message
news:ep**************@TK2MSFTNGP10.phx.gbl...
"cql90" <cq***@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP09.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**********@newsgroup.nospam> wrote in message
news:6v********************************@4ax.com...
On Thu, 20 Oct 2005 08:13:59 -0t700, "cql90" <cq***@yahoo.com> 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, OleDbDataAdapter, 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**************@TK2MSFTNGP10.phx.gbl...
"cql90" <cq***@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP09.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
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. ...
7
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...
10
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...
9
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...
1
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...
17
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...
1
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...
3
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,...
1
by: henrymania | last post by:
Am writing a code for database backup....by backupservlet is as given below i get the following exception
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...

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.