ok, I'll start from the beginning. I am trying to add access within Visual Basic. I followed the instructions that was given in my book. I also looked over the site that you suggested, it basically told me almost the exact same steps. The only difference was that it said to be in Visual c#. My book, which I have to go by, says to be in visual basic. Thank you, ibok23

The first set of error said that I was not authorized or someone else was using that folder. So I found out to do . Now the error is this: Server Error in '/WebApplication1/WebApplication1/Chapter7Case345' Application. -------------------------------------------------------------------------------- Unspecified error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Unspecified error Source Error: Line 83: Line 84: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 85: DA1.Fill(MyDS1) Line 86: Page.DataBind() Line 87: End Sub Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Chapter7Case345\WebForm1.aspx.vb Line: 85 Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Chapter7Case345.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplication1\Chapter7Case345\WebForm1.aspx.vb:85 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 So I also went back and underneath system web I put I still get the above error. Now in http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q825738 it also says to: In Windows Explorer, locate the following folder: Document settings\ServerName\ASPNET\Local settings\Temp

ok, THis is helpful; however, i need to check out a folder to see if the read/write permissions for userAccount are not enabled in a certain folder. here is the folder Document settings\ServerName\ASPNET\LocalSettings\Temp I am not sure how to find this folder. The server Name is the server that I am using. is that where I went to change to MIcrosoft Jet 4.0 (because of access). I am sorry, I am lost. Thank you, ibok23

I am sorry, I am new at Visual basic and ASP.NET. How do I check the validating events? Thank you, ibok23

how do I check to see if this is the case: "and another thing you may have to look in your case is, you are using a typed dataset. so, when you try to fill it using adapter, it will have to fill in according to the tables structures defined. if the the 'SQL' using which you are filling dataapater does not follow the schema in typed dataset, it may fail. verify." and how do i fix this. Sorry, I am just learning. :confused: Thanks, Thank you, ibok23

Could someone tell me what I am doing wrong? I am trying to add access into visual basic. I have changed the server for access (Microsoft Jet 4.0 OLE DB Provider). I have done the test connection - all is well. I have added the dataGrid to the web form- Named it MyDG1. I clicked on OldDbDataAdapter and added the connection where the access page is. I have done the Query builder, generate dataset (which I called MyDS). I selected the the dataset and Previewed it - all is well when I filled it in. I assigned a table to the DataView - Shopping Products (my access page). I assigned the DataSource property on the DataGrid as DataView1. In the page_load handler I added OleDbDataAdaper1.Fill(MyDS1) Page.DataBind() I build it - all is good; however when I view in browser that is when I get my error. Here is my error. Server Error in '/WebApplication1/WebApplication1/Unit5' Application. -------------------------------------------------------------------------------- Unspecified error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Unspecified error Source Error: Line 83: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 84: 'Put user code to initialize the page here Line 85: OleDbDataAdapter1.Fill(MyDS1) Line 86: Page.DataBind() Line 87: End Sub Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb Line: 85 Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Unit5.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb:85 System.Web.UI.Control.onload(EventArg

yes, i coded it so it would allow the database. I will approach asp.net now. Thanks, Thank you, ibok23

Could someone tell me what I am doing wrong? I am trying to add access into visual basic. I have changed the server for access (Microsoft Jet 4.0 OLE DB Provider). I have done the test connection - all is well. I have added the dataGrid to the web form- Named it MyDG1. I clicked on OldDbDataAdapter and added the connection where the access page is. I have done the Query builder, generate dataset (which I called MyDS). I selected the the dataset and Previewed it - all is well when I filled it in. I assigned a table to the DataView - Shopping Products (my access page). I assigned the DataSource property on the DataGrid as DataView1. In the page_load handler I added OleDbDataAdaper1.Fill(MyDS1) Page.DataBind() I build it - all is good; however when I view in browser that is when I get my error. Here is my error. Server Error in '/WebApplication1/WebApplication1/Unit5' Application. -------------------------------------------------------------------------------- Unspecified error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Unspecified error Source Error: Line 83: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 84: 'Put user code to initialize the page here Line 85: OleDbDataAdapter1.Fill(MyDS1) Line 86: Page.DataBind() Line 87: End Sub Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb Line: 85 Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Unit5.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplic

I am having to come up with factors that may be involved when you are transferring data from one database architecture to another. In other words, if I wanted to transfer to RDBMS from a network architecture what do I need to look for? How can I find out this information - if I wanted to research? I have been trying to find it, but I must be putting in the wrong keywords for my search. Thank you, ibok23

I am trying to put a header on each of my columns in my data grid. I have the columns already there, but with a different name from when I made the data relations. For example on column one it has "fldEmployeeId". I just want "Employee ID". I am getting an error while trying to run it. It is telling me that An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dllAdditional information: Index was out of range. Must be non-negative and less than the size of the collection. The error is on the first line in this part of the code. What am I doing wrong? I have a total of 6 columns. Any suggestions.

dgPayrollInfo.GridColumnStyles(0).HeaderText = "Employee ID"
dgPayrollInfo.GridColumnStyles(0).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(1).HeaderText = "Payroll ID"
dgPayrollInfo.GridColumnStyles(1).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(2).HeaderText = "Pay Date"
dgPayrollInfo.GridColumnStyles(2).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(3).HeaderText = "Gross Pay"
dgPayrollInfo.GridColumnStyles(3).Alignment = HorizontalAlignment.Right
dgPayrollInfo.GridColumnStyles(4).HeaderText = "Withholding"
dgPayrollInfo.GridColumnStyles(4).Alignment = HorizontalAlignment.Right
dgPayrollInfo.GridColumnStyles(5).HeaderText = "Net Pay"
dgPayrollInfo.GridColumnStyles(5).Alignment = HorizontalAlignment.Right

Thank you, ibok23

I have added a data grid. I am trying to change the default header of each column to another name. For example:

dgtsPayrollInfo.GridColumnStyles(0).HeaderText = "Employee ID"
dgtsPayrollInfo.GridColumnStyles(0).Alignment = HorizontalAlignment.Center

I keep getting an error. I want my first column to have employee id as the header. Any Sugggestion Thank you, ibok23

I am trying to put a header on each of my columns in my data grid. I am getting an error while trying to run it. It is telling me that

An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll

Additional information: Index was out of range. Must be non-negative and less than the size of the collection.

The error is on the first line in this part of the code. What am I doing wrong? I have a total of 6 columns. Any suggestions.

dgPayrollInfo.GridColumnStyles(0).HeaderText = "Employee ID"
dgPayrollInfo.GridColumnStyles(0).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(1).HeaderText = "Payroll ID"
dgPayrollInfo.GridColumnStyles(1).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(2).HeaderText = "Pay Date"
dgPayrollInfo.GridColumnStyles(2).Alignment = HorizontalAlignment.Center
dgPayrollInfo.GridColumnStyles(3).HeaderText = "Gross Pay"
dgPayrollInfo.GridColumnStyles(3).Alignment = HorizontalAlignment.Right
dgPayrollInfo.GridColumnStyles(4).HeaderText = "Withholding"
dgPayrollInfo.GridColumnStyles(4).Alignment = HorizontalAlignment.Right
dgPayrollInfo.GridColumnStyles(5).HeaderText = "Net Pay"
dgPayrollInfo.GridColumnStyles(5).Alignment = HorizontalAlignment.Right

Thank you, ibok23

I am trying to write a code for enabling and disabling a textboxes for output and for input during certain times in the program. One of my textboxes is PartNumber.text. At the beginning of the program I want to disable this box; however, if they want to add another Part this box will become clear so they can input a number so I want it to be enabled. I am confused on how to write it. Thank you, ibok23

ok, I have on top file,edit,and Navigate. Under file is exit, under edit are add, edit, update, cancel update and delete. Under Navigate are first, next, previous and last. The instructions are Create the code for the Add, edit, update, cancel, and delete menu items, create a sub procedure name EditState to enable and disable menu items as necessary. Enable or disable the text boxes also. so far I have in the code under the sub of add is

Call EditState (cblnNotEditing)
Me.BindingContext (DsParts1, "tblparts").addNew()

I have nothing underneath the editState, I am not sure what to put there. I found this in my book telling me this is what I am suppose to type. I have an error under (cblnNotEditing). I am not sure what this cblnNotEditing means. I am just putting what the book is telling me. Thank you, ibok23

Do I do an if then statement? For example If MenuItem7.enable = true then MenuItem5.enable = false MenuItem6.enable = false MenuItem10.enable = false Else If MenuItem5.enable = true then MenuItem6.enable = false so on and so on.. Thank you, ibok23

I have created a sub procedure named EditState. This is to enable and siable menu items as necessary. Enable or disable text boxes also. I do not know how to do this. Can anybody help.:| Thank you, ibok23

Could somebody tell me what I am doing wrong? This is what I have...

Dim partInformation As Binding
partInformation = New Binding ("Text", dsParts, "tblParts.fldpartNumber")
txtpartNumber.dataBinding.add(partInformation)
partInformation = New Binding ("Text", dsParts, "tblParts.flddescription")
txtDescription.dataBinding.add(partInformation)
partInformation = new binding ("Text", tblParts.fldquanityOnHand")
txtquanityOnHand.dataBinding.add(partInformation)
partInformation = new Binding ("Text", tblParts.fldcost")
txtcost.dataBinding.add(partInformation)
partInformation = new binding ("Text", tblParts.fldsalesPrice")
txtsalesPrice.dataBinding.add(partInformation)

I am getting an error on all of the partInformation except for the dim. It says declaration expected. I am also getting an error on all the txt before the dataBinding saying declaration expected. :( Thank you, ibok23

I am trying to bind object together from access to visual. I am in the process of writing the code. I keep on getting the same error and don't know why. I have this so far.

dim partInformation as Binding
partInformation = new binding ("Text", dsParts1,_
"tblParts.fldpartNumber")

Under part information on the 2nd line the error that is coming up is - Declaration expected. Under "tblParts.fldpartNumber" the error is Syntax error. What am I doing wrong? :( Thank you, ibok23

I am trying to start to write the code for the binding. In my book it says for me to activate the Code Editor for the form named frmMain. (I am not sure where this is. I can not find it.) that is where I am to start the code is in this section. Well I have started the coding underneath the Windows Form Designer generated code. So far I have..

dim partRecords as Integer
partRecords = adbdaParts.fill(dsPart1)

This is giving me an error on the second line saying I need to declare partRecords. partRecords is how many records I have in my database. Thank you, ibok23

I am very new at this. I am confused also. I have a book that is showing me what to do. But i am still confused. Yes, on a code sample. Thank you, ibok23