I have this problem, I can create a setup for my app/database but everyone can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app.
View 2 RepliesI'm making a VB.NET application with an SQL Server 2005 in the background. Naturally the user can not edit the database directly but will use a number of UI features to be able to add and modify the data.However, there are a few tables that should be easily accessible from the admin interface such as specific information about a vendor. What's the easiest way to let the user edit this data freely? One way would be to use a DataGridView but this could appear complicated to the user, plus I'm not sure exactly when to save the edited data back to the database.
The best way that I can think of is to create custom dialog boxes for adding, deleting and changing the information, but this seems like too much work for such a small feature.
I am strugling to get a value back from an access database, what i am using is,
Public Shared Function ReturnTimes(ByVal DateValue As Date) As DataTable
Dim cmd As OleDbCommand = New OleDbCommand()
With cmd
.Connection = Database.conn
[Code]...
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 Repliesexperts is it possible to roll back insert or update operation in ms access database..
View 1 RepliesI am using MS Access 2003 and vb.net to develop a windows application of inventory management.
I have used datagridview in the form and using FillBytoolstrip option, can filter data using type.
But i have no idea as to how can i update the database to reflect the latest changes in the gridview.
following is the code I have used.
Private Sub BOM_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.PartnoTableAdapter.Fill(Me.HemDatabase1DataSet3.partno)
End Sub
[Code].....
I am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?
View 2 RepliesI have an application running with a access db. I have written some code to copy & zip the db file to another location (selected by the user) for the purpose of backup. (I am using sharpzipwrapper)Whenever I try to run the code for the copying & zipping it gives me an exception saying that the file cannot be zipped as it is use.Do I have to close all open connections in order to backup the .accdb file? If yes then how? else what do i have to do inorder to get 'access' to the file.Do I have to exit the application to close all connections? These connections are written in code for e.g. :
dim
cnStudent as
oledbconnection
[code].....
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 RepliesI have a ASP.NET page called admin.aspx that needs to be protected from direct access. I want it to be accessed only when the user enter his name & password in another page called login.aspx I'm working in ASP.NET with Visual Basic .NET 2008, and I have no idea how to do it.
View 4 RepliesI want to know if I can directly read or write values in the current process in a Visual Basic 2005 Windows application. Like *(DWORD*)(0x123456) = 1; in C++ will write the value 1 at the address 0x123456. So anyway to do the same in VB using only built in functions and not using ReadProcessMemory and WriteProcessMemory?
View 1 RepliesI am trying to log the contents of an object to a text file. If I do a debug.print of the object itself in the immediate window, it prints all of the values of the object's properties:
?mDb.DatabaseOptions
{Microsoft.SqlServer.Management.Smo.DatabaseOptions}
AnsiNullDefault: False
...
UserData: Nothing
However, I can't seem to access this as a string in code due to a type mismatch. I assumed I could get this information using the .ToString method, but all that returns is the object description with none of the properties or values:
?mDb.DatabaseOptions.ToString
"Microsoft.SqlServer.Management.Smo.DatabaseOptions"
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 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
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 RepliesI 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 RepliesI'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
(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 have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 RepliesI 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. However, there should be something simpler and faster than that, shouldn't it? Any idea?
View 6 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 want to prevent user from adding same data on my database... (using access as database)
let say i have 5 fields on my database... ID, Name, address, contact, email... binded to textboxes... idTextbox, nameTextbox, addressTextbox, contactTextbox, emailTextbox.
if the user add a data.... and clicks the save button (saveButton) a messagebox will show a message saying that the data he/she entered already exist..
the messagebox will only show if the user entered a data with the same Name.
In a VB App. I read an Access table and display it to the UserForm... I would like to prevent and skip Access database update "for the sake of application efficiency and speed" if user has not changed the data displayed on the userform... How can I do that?
View 5 RepliesIn VB 2005, I am calling a C++ DLL function that returns the address in memory and size in bytes of a jpeg image. How can I load that jpeg image directly from memory into a picture box in my VB form? I cannot afford to save it to disk first.
View 10 RepliesThis program is going to submit GET data to our webpage. However, we don't want users accessing the webpage any other way than the program. We can prevent users from sharing the program using HWID authentication, but nothing prevents them from using a packet scanner to get the URL of the webpage. We thought about user-agent authentication, which we will implement, but user-agents can easily be spoofed.
how can we prevent users from accessing the webpage directly, instead of through the program?
Currently we will be implementing:
HWID Authentication to use the program User-Agent Authentication to access the web page Instant IP Blacklisting to anyone accessing the webpage without the proper User-Agent
[code]
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Configuration
[code]....
I don't know if these can connect with Access, anyway, I got ERROR on the com.Connection.Open()?
I need a good book for beginning to use VB 2008. I have some (limited) experience in using VBA. I want to access a database (SQL) and have access to the data set as variables?
View 6 RepliesI am an old mainframe programmer and have started learning VB and find it a whole new world. I am not able to get my example code to work to access an Access database through automation. I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/13/2009, Prod Ver 4.00.9756.0.
View 2 Replies