i not sure can it be done.
Using VB.net by typing the name and hit the button to Show the person record from the database access.
the log file will pop out and show the person record in VB.Net
does VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI am trying to create a database in access, and interact with it using a VB form and listboxes in particular. I am stuck on one small section which should open the rest up for me if fixed!The database has 5 columns, ID, Book Title, Author, No. Sold and Year Sold. I have managed to get my program to put all the data from 'years' into a listbox using this coding:[code]This nearly works, but the problem is that it copies ALL the Number Sold from every year, not just the one highlighted.
View 3 RepliesHow to create a ms-access database with table in run time .i mean i want to create a database when user run the application
View 6 RepliesI need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!
Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean
[Code]....
How do you create an access database dynamically?
View 2 Repliesdo you Create Database in MS Access Using Oledb in vb.net?
View 4 RepliesDoes any of you know of a way to create an Ms Access Database (either mdb or accdb) without having to use adox or interop?
View 4 RepliesIs there a way to create reports from an access database using visual basic 2008 express?
View 4 RepliesI wanna create an access database programmatically.How should this be done?Do you recommend that I do it via code?I don't know how to create an access 2003 compatible file at run-tim
View 4 RepliesHow can i create a Database file in Access 2010 file format (.accdb) and create tables in it through Vb code at runtime by taking the filename and table names from the user.PBL (Visual Studio 2010 Ultimate)
View 16 Repliesi need to make a professional form in vb 2008 to make a full backup and restore for my database file with progress bar and ability to write my backup in CD-room so
View 5 Repliesso far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
Until recently I have been using net 2005 with distributing an app which uses an access database with getting data using recordsets
I decided it was time to upgrade so I got net 2010 & started using ADO.net with a dataadapter.
To my dismay I have found that my app will not run on all platforms, ie XP, Vista 32 & 64 bit, Windows 7 32 & 64 bit From another question I have been told
"If compiled to target AnyCPU, your program will fail to run in an x64 environment if it utilizes any ODBC database driver. In this case, you must compile it to x86. Therefore, x86 is safer than AnyCPU."
Which I have found to be correct I am not familiar with all the options to open a database & the respective code required to extract/change the database data. I also don't understand the implications of using x86 cpu instead of any CPU
MY net 2005 apps have been working fine for the last 6 years (until W7 64 bit), so I want to develop an app that has the same lifespan without having to make variations to the build for specific platforms
I would like the answers to the following:
1. is x86 the new standard for specifying cpu & works on all platforms?
2. why does W7 64 bit have a windows & windows x86 system folder
3. why does my installer when "any CPU" is specified install it in the x86 system folder (W7 64 bit, even though the app fails when trying to open the database as outlined above)
4. which method of opening an access database is preferred which works on all platforms with a common cpu specified?
I'm doing my work in VB express 2008. I'm trying to connect it to my access 2007 Database, so a user can log in with ther username and password, if they are using valid username/password.
I've connected my Access 2007 database using Data Source window: data->show data sources->add new data source.
Is this the correct way to connect database for my Log-In page? [code]...
What I need to create Microsoft Access database using VB.NET? I was looking for microsoft ado ext. 2.7 for ddl and security but I could not find anywhere.
View 2 RepliesFriends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
[Code]...
I have an issue with my access database when creating a simple insert form on visual. When I load the form into the browsers and add the data, it says it has worked but when I look in the database the information has not been added.
View 3 RepliesI want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 RepliesI am attempting to create a program for a business but i have no idea how to create a database to hold the information and allow me to access it when needed
View 1 RepliesIm working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 RepliesI have a requirement to create n Access 2007 database & some related tables from my application at runtime.
I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.
i've got a free mysql database online hosted by 000webhost, i'm just wondering if i could connect to the mysql database, and if so what would the connectionstring be like? when i connect using php its something like this: new mysqli("mysql13.000webhost.com", "user", "password", "database1"), how do i translate this into a vb connection string, i can't decide what to put as the data source [code]if there's no way to connect, is there anyway for me to create an application that can store and access database online?
View 7 RepliesI would like to creat database by access 2010 in design view i am using data type is Attachment. Then i want to connect this access with vb 2010 .. now how can effect attachment file Which code i can use?
View 7 RepliesI trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
View 1 Replieshow can i create report and link it with MS access to display database on this report..
View 1 RepliesI have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
Previously this was not problem on XP/Vista (with minor changes), but windows 7 (64bit), is having issue's and I thought it might be how I'm implementing this time around? This is the original version just gives a com exception error of {"Cannot create ActiveX component."} [Code]
View 1 RepliesI have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesI have a slight problem with something i am working on. I found this module here:
View 2 Replies