I don't know if this can be done however I would like to know if I could set values in an open access database.so if I have access open and I would like to pass variables to the form itself from my executable. Is this possible or do I have to write to the db itself?
View 5 RepliesI coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
I have a few questions reguarding converting a Access program to a sql/vb.net program. I know these are vague questions, so feel free to give vague answers.
NOTES: I have a solid unstranding of SQL and VB.net. i have little Access experience, but i would be working with the individual who created the access program. I also don't have alot of experience in converting on program from one language to another. Most of my experience is in new programing.
[Q1] Is their a general rule of thumb when converting/recodeing on how long it should take? i.e. if this project would take me 40 hours to write my self from scratch it would take me 30 hours to recode into another language?
[Q2] What type of problems do i need to look out for when working on projects of this nature and being inexperinced?
Access To SQL With program? Here is my SQL Editer program [code]....
View 7 RepliesI need to set-up SQL Server 2005 database to allow read/write access to it's atabases/tables from a vb.net application programProgrammatically, I have done this before but I have never had to set-up the connectivity between the program and the database.
View 13 RepliesHow do i access a port in Visual Basic?
View 3 RepliesI've done this form on MS Access. What i want is to get this into a form in VB 2008, but i dont know how.
that's all working, i just cant adapt it into Visual Studio 2008.
I am creating an application in vb.net that accesses a database on a drive that other students do not have access to. The program will not run correctly if it is run under one of these students accounts. How can I make it so the program will access the db under any account?
View 2 RepliesI was wondering can I make a program that I can send to other computer so i can access their screen. is this something that can be done in visual basic? i ask how to do this because Verizon did this to me the other day i saw him moving the mouse around and checking the connection but of course i had to accept this and it showed me a thing saying he was off when he was done.
View 1 RepliesI have a vb 2005 app with a Access 2003 backend. I need to upgrade the the BE to 2007 file format. Changing the connection string in settings produces a "Unrecognized database format" error message. I installed Access 2007 runtime but still get the same message.
View 1 RepliesHow do I run Access queries from within VB? The queries have been written and saved in Access using SQL, and use a search-parameter (Team name) to return a single integer value (games won, points scored etc).
View 1 RepliesI have a program that discover the network..and give IP addresses of the active computers..now I want to connect my program with MS access database..in my database I added the IP addresses..but I want to update my database everytime I debug my program..i want my database to check if IP address is already in it if yes then check its status and depending on the status update the database(0 in the case of off and 1 in case of active)..and if IP address is not already present then add that in the database..and do the same with every IP addresse that my Network Monitor program has discovered ..m having problem in updating my databse and check if IP addresse are already present[code]...
View 3 RepliesFor those of you that have been helping me for the last two days thank you first of all, my program is now at the stage where i need to have a windows application that the user can then select databases from, and then using these databases information will be put into a second application that will then run a program to compute some data and spit it into a .xml file.
Is there a prewritten piece of code for choosing databases? And then a set format for choosing cells in that data base to be exported into another windows application?
I'm new to VB Express 2008 (but not new to VB).I'd like to look at some of the samples, which I've tried to access from the Help menu. I've downloaded a 9 MB file called VS 2008 RTM VBSamples.zip, which contains nearly 2000 files many of which have the same name (e.g., Application.Designer.vb or Form1.Designer.vb).I can extract any of these files from the zip file, but how can I know which .vb, .proj, .sln, etc files I want in order to see a full sample for, say, learning how to use Try Catch or for learning how to read a text file ?
View 2 RepliesI have a access database named login.mdb,which has many tables.i want to update table named "try".in tat table i have two fields viz name and rollnumber.i want to update rollnum of corresponding name.[code]...
View 2 Replies1) I want my database should save on default location unlike this:
Dim connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Contacts3mycontacts.mdb;Persist Security Info=False"
Since i'm deploying my project on another computer itz showing me an error of database connection.Then again i've to make one folder of Contacts3 in C drive and then itz connecting the database.please let me know how can i deploy my database as default.
2)When i'm deploying my project on server itz not running and the same pfoject is running on different computers.Itz showing me security errors.
I am having trouble developing the VB code (syntax) to automate the export a series of tables from a MS Access 2003 database to SAS. This is a process that I can do manually table by table.
View 3 RepliesI have these two classes class FootballAdmin makes use of the import Football from the projects references, what i need to do is in class MainForm is for the updateView method to access the list held by FootballAdmin and display it in the teamSheetListBox, i am unsure how access the list as indicated by ?[cod]e...
View 1 RepliesMicrosoft Access queries with somecolumnname = [?] do not show up in the list of Views in the New DataSource Wizard in Visual Studio.
The query works perfectly from within Microsoft Access by just prompting for the values of the parameters.
The columns of the query should populate labels on my form based on the values in a couple textboxes.
What is the "best-practices" way to use parameter queries in my .NET application?
I want to write a program, which if you provide username and password, will go thru the authentication of a specific website, and then jump to a specified section.
View 4 RepliesI was wondering if anyone knows how to access a web service in vb.net 2010? Im trying to figure out how but the interface has changed since vb.net 2005 and 2008 and i havent found any updated web service sample code. Anyone got a simple web service code
sample somewhere i can look at to see how its done in vb.net 2010?Once you eliminate the impossible, whatever remains, no matter how improbable, must be the truth. - "Sherlock holmes" "speak softly and carry a big stick" - theodore roosevelt. Fear leads to anger, anger leads to hate, hate leads to
How to backup ms access database in vb.net?We're gonna make a system for a certain company but our teacher doesn't teach us at all
View 1 RepliesI am trying to write a section of Access VB code that opens the Windows dialog box and allows my user to select and open a file to verify it is the correct one. (Then I use the file path and name to copy, rename and move the file). I have been trying to use the OpenFileName structure and have succeeded in capturing the file path and name my user selected... My main problem in all of this is getting the file to actually open so the user can verify it before I commit the actions noted. This probably can be done as a part of the OpenFileName dialog if I understood it better, but but isn't there also a trivial way to open a file if you have the path and name?
View 2 RepliesI have a windows application written in VB.net. After finishing it I'll setup the program in more than one pc. I want to connect the program in all PCs to one database in another PC using Microsoft Access, and I also want to limit the level of access of the users to the database in my program.
View 2 RepliesI need to create a .Net program that will access a webservice provided to me from a customer. I need to be able to call this .Net program from a VB6 program. Basically, this .Net program needs to be an in-between program between a VB6 program and a webservice.I'm not very knowledgeable about .Net so I am struggling to find a way to do this. When I search the internet I seem to find information on how to make a webservice. But, this is not what I need to do. I just need to be able to access a webservice provide to me and pass the data to a VB6 program.
View 1 RepliesI have tried to google it and then tried to search on codeproject as well but unable to find an article in which there is some good guidlines and walkthroughs for making reports using Ms Access in VB.NET.
View 3 Repliesi an encounting this problem that is...my database is unable to access in client pc and its comes out this error: cannot open database "synonym" requested by the login.The login failed. Login failed for user 'SIDNEY-U1KECH4Tsidey'.
View 8 RepliesI have started a little program which is linked to an access database, and it basically allows the user to input a name and a picture, with the file path stored in a text box and the picturebox getting the picture location from said text box. At the moment I am using the BindingNavigator to go between data. Everything works fine, however, whenever I press previous or next, the picturebox loads up the picture using the file location of the previous datas picture field. How can I tweak this so that when I press next or previous it loads the picture into the picturebox using the file location of the data I am going to, not coming from? [code]
View 5 Repliesi have a program that accesses an access database but i have a problem with this line
-'dbSkillCommand.Fill(dsSkillPageData, "skill")'giving this error message
-'No value given for one or more required parameters.' [code]