I finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database.
View 2 RepliesI finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database,
View 4 RepliesI 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 am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
I am using VB .Net to connect to an access databse when using several connection sometimes i get this erro "unspecified error microsoft jet database engine" even though i am an administrator on my local machine.
View 1 Replies(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE:
I 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]...
this is my code for adding users in my database but it has an error on the INSERT INTO statement.here is the error: Microsoft office access database engine: syntax error in INSERT INTO statement.
vb.net
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Dim conn As New OleDbConnection(cn)
Dim check As Integer
[code]....
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
I am trying to attach my mdf files to SQL server (using windows XP) but it gives operating system error (error 5), saying Access is denied to the dbMaster.mdf
View 1 RepliesI've tried various methods to search for files, but each time I encounter a "acces denied" error, which stops the search.Is there a way to scan for files, and skip the files it doesn't have access to, or force access to it?I want to gather all exe's on a specific drive. This works, when there are no restricted files/paths
Quote:
Dim searchResults As String() = Directory.GetFiles(cboDrives.Text, "*.exe", SearchOption.AllDirectories)
I have a program that needs to access the files that are open by another program on the computer.When my application comes up I can easily see if the other application is running with the .net Process.GetProcessesByName method
Dim MyProcesses() as Process = GetProcessesByName("AnApplication")
For Each Instance as Process in MyProcesses
If MsgBox("application is running - do you want to end it?", MsgBoxStyle.YesNo or MsgBoxStyle.Question, "Warning") = MsgBoxResult.Yes then
[code].....
The problem is that the Instance.Kill does not allow the application to end gracefully. In VB6 you could use the SendMessage API to send a close message to the application and it would end gracefully - i.e. give the user the normal closing prompt. This just slays the application - leaving any open files in their potentially incomplete state, etc.
I am writting an application that stores data in an Access database. I can't put the files in the Program Files directory since standard users can't write to that folder. I can't use a 'user' folder since multiple users will need to access the same file. In addition to accessing the file, users on occassion will copy new versions of the file into the folder, overwritting the old file.Where should I put this file? I am thinking the ProgramData folder, but when I create that folder during the install, it is also read-only for a standard user.I'm lost as to where I should put a file that can be accessed by multiple users, that is read/write, and I can install the folder into the location. I don't think I have a programmatic way of installing a file into the Public users folder.
View 1 RepliesI am working on a very simple program for someone and because it's been so long since i've programmed, I'm looking for an answer as to the best way to do the following.
My program consists of tracking incident reports and each report needs to have the data entered as well as the "paper form" linked to it that shows the members signature. I have everything completed on the program but how to get my file to link with the incident. I am using Access for my database and have been looking everywhere online on how to attachment documents within Access using the Attachment Datatype. So my question is.....
Should i find a way to import the file to Access, and if so, how do i do this, or should i just send the file path to Access as a text field, and then hyperlink the file when it is displayed on the report? I've never done anything like this and was just looking for some pointers.
How to save pdf files into access database ?
View 4 RepliesI'm trying to run an EXE file using process.start.I've put in username, password and domain that it is accepting (it complains when I put the wrong password, and not when I put the right one, so it is checking etc), and that have local admin rights on the PC.However, when I try to run an EXE that's stored in Program Files, I cannot run it. It always says Access is Denied. When I copy that EXE to another folder, it runs perfectly![code]
View 2 RepliesSo in VB.NET I created a resource file called "source.txt" (as its a text file). My program will take in the text in the file, and then compile it into an executable.
How do I access this file which is in my resources folder in my project?
I'm trying to make a file.copy to the program files folder but can't get access to it.This is on windows vista and 7.
View 6 RepliesI want to make a database of my media collection for my application. I want to create a library for that. Now what i want is that user should be able to add his own song to the database. How can i access mp3 files metadata in my database? How to update that database using my application.
PS: My application is a media player made in Visual Basic using Visual Studio?
I use text files to hold the program data, which is loaded in to variables when the program starts. I use StreamWriter to write to the text files when they update within the program. This is fine although the writer adds a extra line when I do not want this, which causes the program to error on the next use.
[Code]...
I am using the .getdirectory to scan my whole c drive for certain files to be backup. e.g *.doc. however when i run the code, i hit into error. stating folder access error. one of the folder which cause the error is system information volume.
View 8 RepliesMy application creates a file by writing to System.AppDomain.CurrentDomain.BaseDirectory() & "data/" & filename...Now this works fine usually, but I just added a setup utility to the app, so now it installs to the program files directory. It installs correctly and creates the data folder, however when it tries to write the file it gets an exception "unauthorized access".
View 3 RepliesI am trying to create a program that downloads audio files via FTP, converts the audio to mp2 if necessary and copies them to a certain directory for consumption by our automation system. (I am a radio station engineer.)I am using the open source converter FFMpeg to convert audio files to mp2. This is a command line exectuted program. Here is the command line that I use to execute the external program with the input and output audio files at the root level: cmd.exe /k ""C:New Folderffmpeg.exe" -i "C:Test.mp3" -y "C:Test.mp2"" This command line works correctly whether I am using Shell() or System.Diagnostics.Process (Process) to execute the external program. I am going the Process route so I can know when the conversion has finished.Now, I really don't want to use the root directory for this but when I go below root with this line using Process the external program will not execute:[code]Can anyone tell me why that line will not work with Process though it works as expected with Shell()? I can't figure out how to stop the external program to get some feedback as to what its problem is.
View 7 RepliesHow to connect vb .net data grid view to a ms access database files
View 2 RepliesI would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 RepliesI am making a Visual Basic program that launches Halo CE, and two other programs at the same time. The two other applications load fine but when it tries to launch Halo CE an error windows comes up saying that there is missing files which there is not. I use
"Process.Start("C:Program Files/Microsoft Games/Halo Custom Edition/haloce.exe")".
I have tried to copy and paste numerous files into the "Debug" folder from the Halo CE folder but there is one file that is demanded but is simply not on my computer. I would also not want to put programs files in the debug folder because I wish to publish this to "Halo Maps."
I have incredimail that was working fine but now I get a runtime error Program Cprogram files (X86) incredimailinin app.exe This application has requested the runtime to terminatet in an unusual way.
View 2 RepliesI tried attach .mdf file to server via vb.net code for deployment my application .I put .mdf and log in debug folder and I used this connection string.[code]
View 2 RepliesI am trying to utilize the access database, but I'm getting an error message: Value cannot be null. Parameter name: dataSet
[Code]...
That's the code I'm using, why I'm getting this error?
For 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?