Example code to create an MS Access db locally using VB.Net 2003

Programming and Web Development Forums - dotnet-framework - Microsoft .NET technology

Skip to content

Example code to create an MS Access db locally using VB.Net 2003

dotnet-framework
Post a reply

    Next

  • 1. BC32017: Comma, ')', or a valid expression continuation expected.
    I am trying to dynamically create a javascript link. But, I get the following error: BC32017: Comma, ')', or a valid expression continuation expected. Here is the line I try creating the link. I'm done staring at it. Can someone else see what may be the matter. Fresh pair of eyes maybe? Thanks: <a href='javascript:PopIt(<%# chr(39) %>java/ipix/ipix-viewer.aspx?FileString=<%# DataBinder.Eval(Container.DataItem, "[\"FileString\"]") & chr(39) %>, 375, 350)' class="more">
  • 2. WLANAPI.DLL
    Hi All, Need help with writing a wrapper around wlanapi.dll. I am able to successfully call WlanOpenHandle and get a handler back; but when I call WlanEnumInterfaces or WlanGetAvailableNetworkList I get back a pointer to the returning structs (ppAvailableNetworkList , ppInterfaceList) but when I try to access it I dont find values in the expected memory location. If you would like to see the wrapper email me at XXXX@XXXXX.COM . Thanks in advance..
  • 3. Control/Editor /w Syntax Highlighting & Intellisense
    I have a program where the user inputs some proprietary code in an editor. I would like to use a windows form editor control that automatically does syntax highlighting & intellisense (after I define the vocabulary). 1) How would I do that myself? Any tips and/or links? 2) Are there any open source projects that offer this functionality? 3) What commercial products do offer this (at a reasonable price)? Thanks

Example code to create an MS Access db locally using VB.Net 2003

Postby john » Tue, 20 Jan 2004 15:37:25 GMT 

Hi, 

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.

Thanks
John
Top

Re: Example code to create an MS Access db locally using VB.Net 2003

Postby Miha Markic » Tue, 20 Jan 2004 18:12:04 GMT 

Hi John,

See
ACC: Create and Drop Tables and Relationships Using SQL DDL
 http://www.**--****.com/ ;en-us;116145&Product=acc
and
HOWTO: Common DDL SQL for the Microsoft Access Database Engine
 http://www.**--****.com/ ;en-us;180841&Product=acc

It is not directly related to ado.net.
You will have to execute those ddl commands via
OleDbCommand.ExecuteNonQuery() method.

-- 
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
Top

Re: Example code to create an MS Access db locally using VB.Net 2003

Postby Cor » Tue, 20 Jan 2004 19:01:03 GMT 

Hi John,

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=C:\db1.mdb")
///
I hope this helps a little bit?

Cor
Top

Re: Example code to create an MS Access db locally using VB.Net 2003

Postby john » Wed, 21 Jan 2004 05:15:56 GMT 

Thanks for this guys, I will give it a try and see what happens.
Regards
John
Top

Similar Threads:

1.Install Sheild / VB 6.0 / Ms Access DB created from Outlook 2003 

I have a Vb 6.0 project

The VB 6.0 project with a just a click of the button...exports the
calender rows from OUtlook to a MS Access file ( a DB and a table with
the calender rows are created) and from this table a crystal report is
created.The Db and table don't exist beforehand...they are created..

Right now for test purposes...I have a test machine set-up with just
Outlook 2003 set-up and on that test machine I  manually tried to
Export a file from Outlook to a MS Access file ( ie.... it creates a
database and then a table) and I get the error

" Outlook could not start the required translator...The feature (MS
ACCESS) is not currently installed."

Based on this info I provided... will I need to have MS Access
installed on this test machine in order for this project to work or if
I use Install Shield ( to bundle my project) will enough files be
included so that this can work without MS Access being installed on
the test machine.

2.Req code example of selecting MS sql MSDE database stored locally TIA sal 

Hello,

I'm trying to find an example in vb.net of how I can have a user select a MS SQL database locally
 created using MSDE.

TIA

3.Looking for example VBA code for MS Access DB sync 

Need to store Access database data in a central location where multiple users 
can update the data.  The users must be able to make modifications while off 
line (i.e. not connected to the central DB).  These changes are to be 
uploaded to the central data location when the user has internet access.

Anyone have example VBA code for an application of this type?

4.Handling Concurrency in an Access DB using VB .Net 2003 and Je 

Hi Mary I appreciate your response.

Any documentation or sample code you can refer me to?

Thank you.

"Mary Chipman [MSFT]" wrote:

> The best way to handle concurrency is to design for it at the outset
> -- normalize your database so that data is partitioned in such a way
> that no two people are accessing the same row at the same time. If
> that is not an option, then using optimistic concurrency is your best
> bet--pessimistic locking is a great way to kill concurrency. This is
> easier to control in .NET where data is fetched read-only and you only
> allow users to connect through your .NET UI, and not link directly to
> tables. If your data is hopelessly denormalized, then creating
> semaphore columns that are incremented with each data modification and
> checked prior to data modification are also an option. You can then
> "rollback", alert the user, and fetch fresh data. You can also
> implement Jet security as a deterrence to keep people from bypassing
> your UI and accessing the data directly (note that I stress
> "deterrence" here, not actual data security). The one thing you want
> to avoid as much as possible is a situation where people have abnormal
> shutdowns while editing data, which can cause rows to be locked
> indefinitely until someone goes in and deletes the .ldb file. This is
> one of the main reasons why using Jet is discouraged -- it's very
> fragile in multi-user scenarios unless you plan carefully around its
> weak points. You'll have the best results if you approach the problem
> as though you were designing a Web app. If you do that, there's no
> reason Jet can't support as many users as you want to throw at it (up
> to 255, anyway).
> 
> --Mary
> 
> On Fri, 16 Jun 2006 21:26:02 -0700, Salvador
> < XXXX@XXXXX.COM > wrote:
> 
> >Hi.
> >I need to know how to efficiently handle concurrency for an Access 2000 DB 
> >in a multiuser environment for an application written in VB .Net 2003. I'm 
> >using Jet Oledb 4.0 and Visual Studio .Net 2003 Pro.
> >
> >Please let me know where to find documentaion and examples.
> >
> >Thanks
>

5.Handling Concurrency in an Access DB using VB .Net 2003 and Jet Ol 

Hi.
I need to know how to efficiently handle concurrency for an Access 2000 DB 
in a multiuser environment for an application written in VB .Net 2003. I'm 
using Jet Oledb 4.0 and Visual Studio .Net 2003 Pro.

Please let me know where to find documentaion and examples.

Thanks

6. Accessing a MS Access 2003 DB from .NET CF v2.0 app running on WM2

7. how to create new folder MS OUtlook 2003 using in vb.net

8. Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB

Post a reply

Return to dotnet-framework

 

Who is online

Users browsing this forum: No registered users and 60 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group