User Either SQL2005 Or MS Access Database?
Mar 6, 2009
I am new in programming and I am using VB2005 and I can user either SQL2005 or MS access database.Here my scenario:I have created a project where the user can add a new record, (Support Desk) there are times when a new record is added, it may need a backup (Pictures, Document)to be included in regards the problem.
I need to know if anyone has some sample code on how to attached any type pf file (jpeg, BMP, doc, txt, PDF, excel) and be able to save it to the database.
View 4 Replies
ADVERTISEMENT
Oct 20, 2010
I would like to test a remote connection to a local Sql 2005 Database first thru Hamachi using a small exe that would be set on the client machine to let me know if the connection was successful or not, in the close future the connection would change to be set thru a VPN but for now i would like to accomplish this by using Hamachi software.i want to code the client .NET exe file to connect to the server, Hamachi gives an IP address and hostname once installed on the "server" machine so i wonder how should i include both in the connection string of the client exe file.
View 1 Replies
Jan 18, 2012
not all in the listbox items are save in database....only the index 0 is saved in the database...i want all to be save in database.
[Code]...
View 1 Replies
Jun 20, 2011
I have made an app which has id and name and class and tel fields using sql2005 database I made ID field as primery key so when i delete record from table it doesnt rearange it self for example I added record number
1
2
3
4
[code]....
View 9 Replies
May 29, 2009
I have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
View 3 Replies
Dec 21, 2011
add user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
View 16 Replies
Apr 4, 2011
i want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 Replies
Mar 11, 2011
I have a program which I am securing with a Username and Password box, in which the user enters their credentials. In the database, the username is a number field (VB would not accept this as a string and was looking for it as Int32). And the password is a text field. I have the form linked to the database by an OleDbConnection with a DataAdapter (DaUser) and DataSet (DsUser). I am using a datarow which I have declared at the top of my code i.e. Public drUser As DataRow. The problem arises when the user enters their username and password.
The following code searches the primary key row of the database (Username)
drUser = DsUser.Tables("User").Rows.Find(txtUsername.Text)
When the Username entered does not exist, I'm getting this error when trying to display on the form the users email:
NullReferenceException was unhandled - Object reference not set to an instance of an object.
I've tried both if statements and try/catch to basically say if the Username doesn't exist... display an error message etc.
View 2 Replies
Jul 10, 2009
My aim is to try to add a new user to a access database. Im doing this using from a form named frmRegister. It seems like the code is working perfectly, and I get no expectations that indicate if any errors occurred. However, the user doesn't get added to the database.
The code I'm using is:
Public Class Register
Dim connectionString As String
Dim connection As OleDbConnection
Dim OLEDBAdapter As New OleDbDataAdapter
Dim OLE As String
[Code] .....
(Files too large for attaching here)
Rar format - [URL]
Zip format - [URL]
View 6 Replies
Sep 29, 2009
I have decided to quit using Access and trying my hand a VB.I am wanting to create a database with Forms for entering Address's.
View 1 Replies
Mar 20, 2011
I need help with the code to make it so when a form loads it will check the Access database for the user and if that user is present, then it will load their selections. Otherwise, if no user is present it will add a new row to the database and display nothing.
View 2 Replies
May 29, 2010
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsKashifDesktopDesktop itemsvalid.mdb;")
View 2 Replies
Apr 27, 2012
I have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.
Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.
Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?
View 3 Replies
Sep 3, 2008
I'm writing a form that get some informations from a database to manage the User Access Level.The way i do that is to Fill a Dataset by using a DataAdapter and the Bind some controls to the Dataset.The controls i binding are a ListBox, a Textbox, and five Checkboxes.All are fine with this controls. I can delete values and update values, i can choose a record from my ListBox and the values of this record to be desplayed on the othrer binded controls and so on.
[Code]...
View 1 Replies
May 8, 2009
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 Replies
Dec 3, 2009
I've been working on an application for awhile that, basically, allows the viewing and printing of a maintenance database. It allows the user to view basic information for the object and then view the maintenance history. My approach for the maintenance history is simply to have unique tables per object since a history has to be kept for each, however, I'm running into a problem in the application that allows the user to view the general information from one DB and the Maintenance history from the other DB.
Say you have Object ID BG1. I can enter the object ID into a search field, pull the data from the general DB and display the data, but I also need it to pull the information from the maintenance history and display. If maintenance history for this object is not found, then create a new table within the DB, fill the columns with the required fields and allow for the user to edit the history.
View 6 Replies
Apr 17, 2011
I have a form with 5 fields(inputs). When I entered data in the form and click submit, the data is entered into an Access 2007 Database(Table). All the set up (connection) is working because the data table is getting populated with the user info. However, I also need to search the database by entering a name in the name text box and clicking a button.
This is suppose to populated all the fields with information from the data base if the user exist. The search part is not working. I have no more hair to pull. :) Here is the code:
[Code]...
View 1 Replies
Oct 28, 2009
I want to take my access database which i used in my project on visual studio2008 backup by selecting the local drive of my computer at the time of backup i choose the drive & there were i taken the backup i restore my database. Is is possible to take backup atomatically when i close my application.
View 1 Replies
Mar 24, 2009
Looking for comment about best link to learn about Replication SQL2005.
[Code]...
View 3 Replies
Aug 15, 2008
I have a general VB fax program working fine, however now I would like to connect to a SQL database and get the fax numbers to send out to our customers. What code is missing to connect to the SQL server? I'm leaving the test fax - individual file just for testing purposes. Please don't respond with links, moreover I can do my own google searches![code]...
View 4 Replies
Jun 4, 2011
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replies
Sep 17, 2011
I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 Replies
Jul 14, 2011
Iam using sql2005 database in vb.net2005
my table's name = tab1
I have 3 fields
1- ID = auto number =primery key
2- IDD = number
3- name = text
now if I add 10 names in the table from (1-10) =1,2,3,4,5,6,7,8,9 ,10
then if I delete name number 6 the IDD field will rearrange it self from( 1-9)=1,2,3,4,5,6,7,8,9 instead of 1,2,3,4,5,7,8,9,10
View 9 Replies
Jul 8, 2011
Iam using sql2005 database in vb.net2005
my table,s name = tab1
I have 3 fields
1- ID = auto number =primery key
2- IDD = number
3- name = text
now if I add 10 names in the table from (1-10) =123456789 10 then I deleted name number 6 the IDD field will renumber it self from( 1-9)=123456789 instead of 1234578910 so in reports and queries the names will appear numberd from 1 to last number with out missing numbers in the middle of numbering I use in MS-Access code which does this perfactly
Public Sub RowOrder()
Dim db As DAO.Database
Set db = CurrentDb
[code]....
View 1 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Mar 30, 2009
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 Replies
Jun 22, 2010
I am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 Replies
May 31, 2012
I thought I postet this yesterday but I can't find my thread so if this is a duplicate please point me at the original one. Background: I need to create a user account and Modify it's registry before the user logs on the first time. Creating the account is done by using the Winnt provider (works great). To create the profile I'm trying to use Process.start to launch a process as the newly created user. With the use of loaduserprofile property the users profile gets created and i can do my regwrites without problem.
[Code]...
View 11 Replies
Jan 27, 2012
I've created a user control that is basically a Panel that contains 1 label,3 TextBoxes and a few properties that set/get some short integer values.During a form load event I display a number of these Panels.I then access the Panels name (and other panel properties) via a user-created handler for the panel's click eventHowever I would really like to access the values from the user-control's properties.
Public Sub load_Panels()
Dim pnlName As String
Dim x As Short = 69
[code].....
View 9 Replies
Sep 25, 2009
writing user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 Replies
