I have looked around google and downloaded several program with no luck. I have a Microsoft Access 2000 DB which my web app connects to and now published the website with a MS SQL Server DB 5.0. I need to create the tables on it but its not deeming easy. The closest thing I got the creating SQLfor creating the tables was:
[Code]...
I'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?
View 7 RepliesI'm looking for some simple code that lets me create a Microsoft Access table via code.Currently all I do in Access is write and retrieve data from specific tables but now I want to be able to create them at runtime. Here is an example of the code I use to load some data just so you can get a feel of what I'm currently doing. Hopefully there is an easy way using the same rough way that I'm currently dealing with databases.
Code:
Public Sub LoadCareer()
Public rs As New ADO
[code]....
use the following code to create a database in ms access
Code:
'reference: Microsoft ActiveX Data Objects 2.8 Library
'reference: Microsoft ADO Ext. 2.8 for DDL and Security
[code].....
I have a small problem, I have written a small application to update a database table. Now on my computer I have a copy of the database but using MSDE 2000 and when I run my application it works perfectly, however I also have a copy of the database attached to MS SQL 2005 on another computer. Now when I got an run my application on this machine, it fails with a "Time out" error. I have changed the timeout settings on the SQL Server however it then just sits there for ages, whereas when I run it on my development machine MSDE 2000 it loops through the code quickly.
[Code]...
what I am doing wrong in the coding below:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
I have a folder C:databases and in that folder there are subfolders C:DatabasesDatabase1 and CDDatabasesDatabase2 What I want to do is have a VB script or code that will go through each directory and make a copy of all .mdb database files found within the folder or subfolders of C:Databases.
View 4 RepliesI have been using VB6 to manipulate MS Access 2000 databases via the DAO 3.6 library on Win XP. I have recently acquired Visual Basic Express 2010 and I have not been able to port my VB6 code. I can not find any sample code to use MS Access 2000 from VBE 2010. Is it possible to access MS Access 2000 from VBE 2010?
Here is my VB6 code:
Sub Main()
Dim dbJobCPD As Database
Dim rsJob As Recordset
[Code]......
I am working on upgrading an old Access 2000 database to VB .NET (2010). There is one form that I am having trouble figuring out how to build so that it works similarly to the Access form. In Access, there is a header, detail and footer for this form. The objects in the detail section only need to be created once and Access will "copy" them for each record in the database and fill in the appropriate information (the form objects include buttons, textboxes, comboboxes, etc.).
How can I do this in VB .NET? Each different area that is chosen will have a different number of sections. I've thought about using a GroupBox, but I'm not sure how to make that work.
vb.net 2008, using DataGrid, How to connect with MS Access DataBase 2000?, In VB6 just drag Datagrid and ADODC set the datasource can see the data in few seconds.
View 3 RepliesHow can you access the Start Menu from a VB form for both Windows XP & 2000?
I've done a lot of research and haven't found anything that works for this.
How can I connect my vb2008 windows app to an Access 2000 database which is located at www.mysiteserver.com/files/rubbishdatabse.mdb?What code is needed to do so? And where should I put the code in(of coz in the vb app, i know XD, but which part)?
View 8 RepliesI will start off here by asking the question. How do I make the data from a database be bound to my project? I keep trying to add a new data source so that I can drag and drop things to my form, but I am unable to. I follow the steps, choosing an OLE DB, the file's location (D:Data Connected Applicationsfile name) The conecting string looks like: Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:Data Connected ApplicationsItem_Database_A.accdb". I choose the objects that I want (In this case, the entire tables option) and then it returns a message to me stating that: An error occurred while creating the new data source: Could not get information for 'WindowsApplication1.Item_Database_A.accdbDataSet3'
[Code]...
Yes, you read it right! Exchange Server 2000. I want to create a script that retrieve information(ie. Last Access Time) of all the files that are place within the public folder of the Exchange Server 2000.
View 2 RepliesI am starting to design in Visual Studio 2008 and I am designing a web application that connects to a SQL database. In VB6 I could create a record set and read its contents as follows.
SQLCommand = "SELECT * FROM Tablename WHERE field = '" & data & "'"
Recordset.Open SQLCommand, Database, adOpenDynamic
If Recordset.EOF = True Then
MsgBox "Record does not exist!", , "Record does not exist"
End If
Then I would Bind the fields data to, say a text box like this
Textbox.Text=Recordset("Field1")
I am finding dificult to do this in Visual Studio 2008. Does anybody know how to create a recordset in Visual Basic 2008 as described above.I have been reading a lot, watching traing videos, and researching on the Internet and I have not found any source which will explain how to do it.
I am writing an application in VB.Net, the application stores a number of images within the database and therefore the SQL database size gets quite large. At the moment I use a single database, however what I want to do is create a new database for each project within my application. I need some advise on the best way to proceed with this and also the best way to be able to create a new database for each project. Below is the approach that I was planning to adopt:
1. When the application is installed it automatically has a common database that comes with the application and this database is attached to the SQL Server, lets call this application "AppA" and common database "AppADB" Within the AppADB there would be a table called projectsTbl and in this projectsTbl it has a 2 columns called "projectDesc" and "projectDB". projectDesc would hold the description of a project and then the projectDB would hold the SQL database name for that project.
2. The user would login to my application and in the admin side of the application have a create project form. In this form he would enter the project description and also a 3 character code for the project. When the user OK's the form it would take the project descrption from the form and put this in the "projectDesc' field in the AppADB and then take the 3 character code from the form add this as a prefix to "AppADB" and put this within the "projectDB" field within the AppADB e.g. if the 3 character code was "SIM" then the projectDB name would be "SIMAppADB"
3. What I obviously now need to do is create a new database called "SIMAppADB" now what I was thinking was I could create a SQL database backup of a database that has the standard database structure that is required and then I can restore this .bak file (which would be in my application installed directory) to this new name, using the following code:
Code:
RESTORE DATABASE SIMAppDB
FROM DISK = 'C:Program FilesAppA Installed DirectoryDB.Bak'
WITH REPLACE, MOVE SIMAppDB_Data' TO 'C:MSSQLDATASIMAppDB_Data.MDF',
MOVE 'SIMAppDB_Log' TO 'C:MSSQLDATASIMAppDB_Log.LDF'
4. Then when the user logins to my application again, on the login screen he will see a list of projects from the "projectsTbl" table in the "AppADB" database. The user can then select the project they wish to login to and from this the application and extract the database name from the "projectDB" table in the "AppADB" database. I then can store this database name in my application and when the application needs to connect to the database it modifies the connection string to connect to the respective database.
I'm trying to write code to create a new database and then create tables within the database.
I'm running into a strange problem right now, which is the fact that I was able to create a new database ok on either the regular SQL Server instance, or the SQLEXPRESS instance. However, when I attempted to create a table, I got an error message saying that there is already a table of the same name.
When I tried to connect to the new database via SQL Server Management Studio, I could see the database. However, there are no tables in it! So, theoretically, I'm creating a brand new blank DB, so there should not be anything in this DB, right? and I should be able to create any tables I want in it!
Here is the code that I have so far:
[code...]
I just have one simple form with a button on it. The click event on this button calls the CreateAllDBs() routine.
I am trying to load a crystal report from two tables but it seems that is not working.Here is the code to load the crystal report:
Code:
Private Sub InvoiceLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]......
An order can have many OrderDetails, and a Product can be on many different orders. The OrderDetail table just has the OrderID and productID, so there is essentially a many-to-many between order and product).I have a form for the user to enter a new order. I want to have an unbound box that contains the names of all the products, and to be able to drag these names into a box under the order, to add a new OrderDetail record using the productID of the dragged order along with our orderID.
View 1 RepliesI am using VS 2008 standard edition to develop my first windows form application and it does not come with crystal components. I nedd to design few reports but I can't find any help on the net. In my vba application I create one form which accepts all parameters and based on parameter I build SQL statement and pass it to report data source. I would like to similar in vb.net, but all I see is cryatal. Can I create reports without Crystal?
View 1 RepliesI was hoping to save some coding by using views to access my forms in VBInstead of using a very long query I was hoping to use
Code:
Select * FROM my_view
[code].....
I am creating a small admin reporting tool that gathers certain information on some PCs. Unfortuantly the user that is running the tool doesnt have access and I cant give access to those particular machines. What I have done is created a user on these machines that can get this information.I would like to then have the reporting tool run certain parts of the code as this user so the information can be obtained, without any intervention from the user running the tool. Can I hardcode this user into the code so that it runs the code as the user?
View 4 RepliesI am creating a reporting app that pulls information off of a Sql database and populates the data in a datagridview control (DVG). I am using tab pages (Tabcontrol), and I have about 10 tabs with within the control. What I have done is created a dynamic control that will populate in each tab page once the tab is selected. I am using a split container and in my split container.panel 1 is where all my buttons and search functionality will be. In my split container.panel2 to is where the main DGV control will be. I have got this to function properly, however now I am unable to add anything to my split container.panel1. I would like to add diffrent labels and buttons in the panel1 one without putting another panel on top of the split container.panel1, and also if i do this when I resize my container the panel will just sit there. I am using the selected index changed event to get my split container to show in each of the diffrent tabs
Private Sub searchTab_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchTab.SelectedIndexChanged
searchTab.TabPages(searchTab.TabPages.IndexOf(searchTab.SelectedTab)).Controls.Add(splitContainer1)
[code]...
I am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
I have taken up a task where end user should be able to enter information via vb interface into microsoft Access database. This then will be displayed onto the Datagrid via VB interface. The program needs to be setup in a way that first entry by end user will flash upon 3 hours.
Example:
VB Interface
=========
Basket Number | Number of Trays | Run Type | Time In
1 | 1 | CNC | 15:00:00
[code]....
Values defined within database shows in this datagrid.The Datagrid works fine and I can insert values into the database fine as well however, I am not sure how to setup a timer so that when 3 hours are up the first entry into the database(shown on datagrid) starts flashing.This is needed so that the end user gets an alert when the time is up so that he can take the trays out of the oven.
In Summary: Can we really setup a timmer so that a value in the datagrid will flash at a particular time.Below is the image of an application. Here you can see the data on the datagrid however I want it to flash after 3 hours. So the first entry will flash after 3 hours following the 2nd entry.
---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?
View 1 Repliesi can't link access 2003 to vb6. its say's"unrecognized database format" explain to me in a low english.do i have to create module?i have to create conn.txt? i just have to add source code in a form to link the access 2003??
View 1 RepliesI have been struggling with the construction of an Access connection string. Here's the problem.My Visual Basic 2008 project is located in a disk partition on my hard drive that I have named S:. My Access MDB file is in the same location.When I deploy the application it obviously will not be in an S: drive on the user's machine. My concern is that if I construct the Connection String using the file designations on my computer as:
(Provider =Microsoft.Jet.OLEDB.4.0; Data Source =S:MyApplicationmydatabase.mdb; User Id =admin; Password =
The deployed application won't know where to look for the data file. I know there are some shortcuts that will allow me to construct the connection string, but I do not know either the designated names or where to find them.
I'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?
View 3 Repliesi have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.
View 5 Replies