Programmatically create Access 2007 database

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Trouble Using DataAdapter.Update() Hi, and thanks in advance for any help :-) From a high level, heres what I'm trying to do. I have a flat comma delimited file that I need to import into a database, but after some of the data is massaged and mingled with data in the destination table. So, I first import the flat file data into a dataset using one dataadapter and one dataset. Then, I use another dataadapter and dataset to import the current data from the eventual destination table. Then, I do the logic and place the resulting data into the *second* dataset. So far so good. Now, all I have left to do is update the database table with the new data. Easy, right? But I can't make it happen. I know it's a lot of code, but here's what I've got: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' First, import the flat file data Dim TextConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & "C:\Inetpub\wwwroot\GrandCentralCoupons\comissionjunction\" & ";" & _ "Extended Properties=""Text;HDR=Yes;FMT=Delimited;""" Dim TextConn As New System.Data.OleDb.OleDbConnection(TextConnectionString) TextConn.Open() Dim dad1 As New System.Data.OleDb.OleDbDataAdapter("Select top 5 * from cj.txt", TextConn) Dim dsSource As DataSet = New DataSet dad1.Fill(dsSource) TextConn.Close() dad1.Dispose() ' Verify that the data is corect by binding to a gridview for visual display GridView1.DataSource = dsSource GridView1.DataBind() ' Now, get the currentdata from the destination database table Dim dbConn As New SqlConnection(WebConfigurationManager.ConnectionStrings("GCC_Remote").ConnectionString) Dim dad2 As New SqlDataAdapter() dad2.SelectCommand = New SqlCommand("SELECT * FROM import_temp_cj2", dbConn) Dim cb As SqlCommandBuilder = New SqlCommandBuilder(dad2) dbConn.Open() Dim dsDestination As DataSet = New DataSet dad2.Fill(dsDestination, "temp_import_cj") ' verify the data is correct by binding to a second gridview for display GridView2.DataSource = dsDestination GridView2.DataBind() ' mix. mingle, manage the data form the two datasets '/* lots of code snipped for easy of viewing */ ' verify the new data is correct by binding to a third gridview for display GridView3.DataSource = dsDestination GridView3.DataBind() ' update the database table dad2.Update(dsDestination, "temp_import_cj") '<--- NOT WORKING!!! dbConn.Close() ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All three gridviews display exactly what they should be displaying. No errors at compile or runtime. But, the new data just never makes it into the db table. I have a hunch I am missing something really simple... but I can't pick it out. This is the article I am using as a guide: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlcommandbuilderclasstopic.asp Thanks! Tag: Programmatically create Access 2007 database Tag: 143659
  - 2
    - Vengadeshwaraa Astrologers Vision To be the leader in the field of Astrology, to be the best Astrological service providers and to be ranked as the pioneer Astrologer in the world. To deliver various aspects and knowledge bases of Sri Lanka to the whole world and to be the Astrological force that binds all human beings together, wherever they be. Mission To become an Astrologically meaningful resource and be a vital part of lives of our members and users. Providing efficient & trusted service 24 hrs a day, 7 days a week. Our endeavor has become fruitful in making solutions for users to shop on line with direct delivery facilities while offering you the opportunity to know yourself, to grow and to improve your life. Shree Vengadeshwaraa Astrologers founded on 08th April 1972 has since gained numerous audience due to the untiring efforts by us and we believe that no other Astrology service can provide you with the value that Vengadeshwaraa can. So much so, our service is backed by an unconditional guarantee.We have predicted thousands and thousands of horoscopes and have never failed.We want this science to be taken to all mankind irrespective of religion. This is based on mathematical calculations and in no way concerned to the religion. We provide a pleasant, satisfying and superior Astrology experience to our customers while protecting their privacy and security. Shree Vengadeshwaraa Astrologers consist of Sri Lankan and Indian Astrologers and count over 35 years of dedicated and friendly service out of which 20 years has been spent on research alone.We have a very eminent team of Astrologers who are well educated and traditionally inherited this divine/legendary art of science.Our Astrologers are not only educated but also traditionally qualified. Our Astrologers are supposed to be best in this profession. Shree Vengadeshwaraa Astrologers has 03 branches worldwide namely, Sri Lanka, India and Germany. Head of Sri Lanka branch Brahmashree V.S.Sharma is a very popular Astrologer in Jaffna, Sri Lanka Head of India branch Padmanaapa Saastrikal Head of Germany branch Brahmashree V.Mahadeva Sharma Our consultant service to International customers are absolutely free of charge. We have geared ourselves to launch our new branches in London, Canada, Singapore, Malaysia and Australia next year. Shree Vengadeshwaraa also offers services in the field of Matrimonial, Hindu Religion Development and Hindu Brahmins social network. We take pride in our endeavour for the introduction of "TOP 100 ASTROLOGERS RATING PROGRAM" for the first time. Visit vengadeshwaraa.com Please take some time to get to know us better through the links that we have provided on this page and enjoy very competitive product price, special promotions and of course 100% satisfaction on accurate calculation of Horoscopes. Our Astrological and sincere thanks for visit Now:http:// www.vengadeshwaraa.com Tag: Programmatically create Access 2007 database Tag: 143658
  - 3
    - Insert c# DateTime object to Oracle Table using OleDbDataAdapter I have a table defined as: create table product_price ( productId int, price number(20,10), price_date date, primary key (productId) ); I am reading through a price file in c# and I would like to insert a row into the table for every price+date+productId combination. I am using the DataAdapter insertCommand and Table.Rows.Add(newRow) method but it fails when setting the date of the new row. // Setting the insert command priceDA.InsertCommand = priceDA.SelectCommand.Connection.CreateCommand (); priceDA.InsertCommand.CommandText = "insert into product_price (productId, price, price_date)" + "values (@productId, @price, TO_DATE('@priceDate', 'YYYYMMDD'))"; // Adding the row private void addPriceRow (int prodId, decimal price, DateTime priceDate, DataTable priceTable) // priceDate and other params defined elsewhere DataRow newPriceRow = priceTable.NewRow(); newPriceRow["productId"] = prodId; newPriceRow["price"] = prodPrice; newPriceRow["price_date"] = priceDate; priceDA.Update(priceDS, "product_price"); // Dies here with an oracle error ORA-00936 missing expression priceDS.AcceptChanges(); I think this is some sort of date format error, so I tried: newPriceRow ["price_date"] = priceDate.ToString("yyyyMMdd"); but that line fails at runtime with: "String was not recognised as a valid DateTime" Any ideas how I can save this date to the table? Many thanks in advance. -- JohnH Tag: Programmatically create Access 2007 database Tag: 143657
  - 4
    - Inserting records from one database into identical table in another datrabase Hi! I'm transferring the records in a table from one database to another. I create a data adapter using a connection from the first database to fill a dataset. I add an InsertCommand with a different connection to the second database, and add the necessary parameters. I hoped that when I called the update method, the records in the dataset added from the first database would be inserted into the identical table in the second database. This didn't work, but no exception was thrown. Just no records were added. My code is like this modified code from msdn - should this work? Private Sub AdapterUpdate(ByVal connectionStringA As String, ByVal connectionStringB As String) dim connectionA As SqlConnection = New SqlConnection( _ connectionStringA) dim connectionB As SqlConnection = New SqlConnection( _ connectionStringB) Dim adapter As SqlDataAdapter = New SqlDataAdapter( _ "SELECT CategoryID, CategoryName FROM dbo.Categories", _ connectionA) adapter.InsertCommand = New SqlCommand( _ "INSERT Categories (CategoryName) values (@CategoryName), connectionB) adapter.UpdateCommand.Parameters.Add( _ "@CategoryName", SqlDbType.NVarChar, 15, "CategoryName") Dim categoryTable As New DataTable adapter.Fill(categoryTable) adapter.Update(categoryTable) End Sub Tag: Programmatically create Access 2007 database Tag: 143654
  - 5
    - SQL CLR Sproc isn't running right I have a stored procedure for SQL Server 2005 which is done with the CLR... when its executed as a admin it works. when its executed as a non-admin it doesn't work... any ideas? the user has permission to execute the procedure on the server... seems to be something with the .NET SPROC's that is going wierd Tag: Programmatically create Access 2007 database Tag: 143652
  - 6
    - list box primary key vb .net Does anyone know how to populate a list box using SqlDataReader. I am using VB .NET 2005. Along with the list box value that is visible I need it's primary key value that is not visible. Tag: Programmatically create Access 2007 database Tag: 143646
  - 7
    - Error Messages? Currently, I tend to return @@ERROR in my stored procedures so that the calling code can test for error conditions. But I'm wondering: When @@ERROR is non-zero, is there a way for ADO.NET to detect any specific error messages? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Programmatically create Access 2007 database Tag: 143638
  - 8
    - Can't save renamed DataColumn Hello. I experience a problem with columns in a DataSet. I need to add, remove, and rename columns in one table. I'd like to avoid changing the columns, but unfortunately I can't. The table is bound to a DataGridView. Adding and removing columns is not a problem, this works perfectly. The problem is what to do when I need to rename a column. I tried to rename the column in the DataTable and change the DataPropertyName property of the corresponding DataGridViewColumn. Everything seems to work fine. Then I want to save the DataSet to a .mdb file, so I do the following: 1. remove the column that was renamed, 2. add a new one with the correct name, 3. mark all unchanged rows in the DataTable as modified, 4. rebuild the insert, delete, and update commands using the CommandBuilder, and 5. call TableAdapter.Update(...); This routine works perfectly if I add some new columns and/or remove a few of them only. If I try to use this with a renamed column that was already present in the DataSet, it fails. Although it does not throw an exception, the saved file contains blank fields instead of the values in the renamed column. It confuses me a lot. What should I do to make this work? Any help would be much appreciated. Best regards, nvx Tag: Programmatically create Access 2007 database Tag: 143632
  - 9
    - Calling a stored procedure with a output parameter I've been testing a stored procedure that has an output parameter. When I add parameters to the sqlcommand this way, the output parameter returned is always what I pass in: With InsertLeg .Transaction = mySQLTrans .CommandType = CommandType.StoredProcedure .Parameters.Add(New SqlParameter("@Load_Num", SqlDbType.Int)) .Parameters.Add(New SqlParameter("@RC", SqlDbType.Int, 0, ParameterDirection.Output)) End With If I declare the sqlcommand this way, it works, the output parameter from the stored procedure is returned in the @RC parameter. With InsertLeg .Transaction = mySQLTrans .CommandType = CommandType.StoredProcedure .Parameters.Add(New SqlParameter("@Load_Num", SqlDbType.Int)) Dim Param As New SqlParameter("@RC", SqlDbType.Int) Param.Direction = ParameterDirection.Output .Parameters.Add(Param) End With Can someone tell me why these declarations are treated differently? Thanks, Kevin Tag: Programmatically create Access 2007 database Tag: 143631
  - 10
    - Problem using DbProviderFactory with a Access 2000 database Hi; I can't seem to open an Access 2000 database with the following dbprovider factory code : In my source : Code SnippetDim dp As String = ConfigurationManager.AppSettings("provider") Dim cnStr As String = _ ConfigurationManager.ConnectionStrings("AFIDConnectionString").ConnectionString ' The factory provider Dim df As DbProviderFactory = DbProviderFactories.GetFactory(dp) ' Now make the connection object Dim conn As DbConnection = df.CreateConnection() In my App config file I have : Code Snippet<configuration> <appSettings> <add key="provider" value="System.Data.OleDb" /> </appSettings> <connectionStrings> <add name="AFIDConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\wmcrystalt\sysData\FTPFiles\databases\FTPFilesRpts.mdb;" /> </connectionStrings> When I step through the code in my locals windows I notice that df {System.Data.OleDb.OleDbFactory} System.Data.Common.DbProviderFactory + System.Data.OleDb.OleDbFactory {System.Data.OleDb.OleDbFactory} System.Data.OleDb.OleDbFactory CanCreateDataSourceEnumerator False Boolean Can't you connect to an Access database i.e. MDB through the dbProvider object ? Thanks for any insights, -- Gordon Tag: Programmatically create Access 2007 database Tag: 143618
  - 11
    - Displaying Data Table Queries I have several basic queries that seem to add up to a very intricate query. I need to create a report to display the results of these queries, but I don't know the best way. The old VB5 program this new application is replacing wrote the document in a very painful, line-by-line format to a VSPrinter object. Should I do this again, using the PrintDocument object instead? I can't get Crystal Reports to display data for me, so I guess it is out. I've asked questions on how to use it, but I don't get replies. I guess others don't use it either. I suppose I could use an HTML page. This seems the simplest, but also would not give nice headers/footers between page breaks. Any thoughts? Tag: Programmatically create Access 2007 database Tag: 143617
  - 12
    - TransactionManagerCommunicationException when transaction is escalated Hello, I have an application which uses the System.Transactions.TransactionScope class to manage transactions. Transactions are often escalated to distributed transactions, and normally this works fine. With one particular installation I have a problem where as soon as the transaction is escalated I get the following error: System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. ---> System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim) at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken) --- End of inner exception stack trace --- at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken) at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx) at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx) at System.Transactions.EnlistableStates.Promote(InternalTransaction tx) at System.Transactions.Transaction.Promote() at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction) at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts) at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx) at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx) at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction) at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() I have tried using DTCPing to check the link between the machine and the database server and the finds no problems. Help! Tag: Programmatically create Access 2007 database Tag: 143613
  - 13
    - dataset error Hi, I've a requirement where in I need to read the data from a csv file and load the data into the sql database. The file has around 1 lakh records. I'm reading 300 records at a time from the file, loading into a dataset. From the dataset, I'm reading the rows sequentially,and updating one by one in to the database. This happens with a sql trnasaction. The problem is here with the performance.. The file to be loaded exists on one server and the database exists on another server. The loading process is too slow and it breaks with the below error 'The SqlTransaction is closed;it is no longer usable'. I've searched on the google..but couldn't get appropriate resolution. Can someone help me out? Tag: Programmatically create Access 2007 database Tag: 143612
  - 14
    - Pasting from excel to DataGrid Hello guys I'm having a winform application. I can copy from the datagrid and it can paste to excel, however I cannot copy from excel and paste to the datagrid. Is this doable? if so, how? Thanks HS Tag: Programmatically create Access 2007 database Tag: 143606
  - 15
    - Size of Table Hi EveryBody: How much data can be saved in the tabel in the database ? In another way can the size of table be 100 GB ? any help will be appreciated regard's Husam Tag: Programmatically create Access 2007 database Tag: 143601
  - 16
    - Moving from recordsets to datasets... Been writing VB6 for years and am now getting up to speed with .NET. In VB6 I used to create classes for each logical grouping of tables, then have a recordset in that class for each table. Then I'd have functions that would populate the different recordsets. I had a function like this: "getRecordset($SQLStr) as ADODB.Recordset" that would take care of the connection, opening the recordset, then just return a disconnected recordset from that query. Then I had a function called "updateRecordset(RS as ADODB.Recordset)" which just stored the changes. Everything was self contained and very easy to deal with. Now in VB.NET, I see that the dataset is essentially doing something very similar to what I was doing in VB6. A couple problems I'm having though. 1) When I finished making changes to a recordset in VB6, I'd just call my updateRecordset function, which would reconnect the recordset, call RS.UpdateBatch and take care of all the inserts, deletes, updates for me. In VB.NET it looks like I have to use the same SqlDataAdapter that I used to read the data to update the data in order to save my changes, and I have to write INSERT and UPDATE code for it? Am I correct, or is there any way to use this the same way as I was using recordsets? 2) With recordsets, I could specify the read type when I opened the recordset, which allowed me to set this programatically as needed but I would always be dealing with the RecordSet type regardless of how I read the data. With VB.NET, I have to use a dataReader if I want read only. Is there anyway to programatically set a dataTable to read only forward-looking, so that it works the same way as a dataReader and I only have to deal with one data type in my code? 3) I looked at the typed-datasets, but I really hate using wizards or GUIs to do my code. I like being able to see it all at once and copy and paste functions if needed. I also need to be able to change the connection string on the fly, because I will be using different servers and database names. Is there any way to create typed-datasets programatically? Any suggestions on guides to help me design a good back end for my program? Tag: Programmatically create Access 2007 database Tag: 143596
  - 17
    - Recommended db app strategy Hi I have an access backend database to which I need to give a vb.net front end. I created db connection and data source in vs 2008., I then dragged the fields onto a form which created the app for me. The app works ok but my question is; is this the correct/acceptable way to cerate an app or should I be using another technique? Thanks Regards Tag: Programmatically create Access 2007 database Tag: 143593
  - 18
    - Recommended db app strategy Hi I have an access backend database to which I need to give a vb.net front end. I created db connection and data source in vs 2008., I then dragged the fields onto a form which created the app for me. The app works ok but my question is; is this the correct/acceptable way to cerate an app or should I be using another technique? Thanks Regards Tag: Programmatically create Access 2007 database Tag: 143592
  - 19
    - Inserting from a asp:table in an asp:formview I am trying to insert from fields in a asp:table wrapped in a formview i am not sure if the fields are bound to the data source as when I do a view in browser the form view is blank I dont see the asp:table or asp:textboxes in the asp:table <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" AllowPaging="True" GridLines="None" HeaderStyle-BackColor="#909090" HeaderStyle-ForeColor="#FFFFFF" HeaderStyle-Font-Bold="True" HeaderStyle-HorizontalAlign="Center"> <HeaderTemplate> <asp:Label ID="Label1" Text='<%# Eval("Agency_ID") %>' Runat="Server"/> </HeaderTemplate> <ItemTemplate>  <asp:Table ID="Table2" runat="server" AccessKey='<%# Bind("Asset_Tag") %>' BackColor="#C0C0FF" Enabled='<%# Eval("Agency_ID") %>' Width="411px" Visible="true" > <asp:TableRow ID="TableRow1" runat="server"> <asp:TableCell ID="TableCell1" runat="server" Text="Asset_ID"></asp:TableCell> <asp:TableCell ID="TableCell2" runat="server"> :<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("Asset_ID") %>'></asp:TextBox> </asp:TableCell> <asp:TableCell ID="TableCell3" runat="server" Text="Agency_ID" ></asp:TableCell> <asp:TableCell ID="TableCell4" runat="server"> :<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("Agency_ID") %>' ></asp:TextBox> </asp:TableCell> </asp:TableRow> . . . <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Insert Record" Width="157px" /> when the button is clicked this runs in the code behind protected void Button1_Click(object sender, EventArgs e) { SqlDataSource1.Insert(); } Tag: Programmatically create Access 2007 database Tag: 143585
  - 20
    - Re-added row Hello there, I need an advice on "re-adding the deleted rows" in a DataTable. The situation is as follows: 1. I have a data-bound DataGridView. 2. User wants to delete a row with a key value "KEY", therefore this row gets deleted using DataRow row = dataSet.Tables["data"].Rows.Find("KEY"); row.Delete(); 3. The deleted row is still in the DataTable, but with DataRowState.Deleted. 4. Now, user decides to add a row with the same key value again, so he types it into the DataGridView. At this moment, there are TWO rows with the same key value "KEY": one with DataRowState.Deleted and one with DataRowState.Added. 5. User wants to save the data into the .mdb file, therefore tableAdapter.Update(...) is called ending up with a concurrency error saying that the UpdateCommand event caused 0 out of 1 records to update (or something similar, I unfortunately don't have an English version of .NET). What should I do with these two DataRows to be able to use the Update(...) command later on? Any help will be much appreciated. Best regards, nvx Tag: Programmatically create Access 2007 database Tag: 143582
  - 21
    - Using Visual Studio Queries In my C# project, I have a Data Set called Employee and an EmployeeTableAdapter. The EmployeeTableAdapter created a "Fill,GetData()" Query for itself, and it uses this to display data to my DataGridView. The properties of the Fill Query are: CommandText = SELECT ... CommandType = Text ExecuteMode = Reader Whenever my Form loads, it calls: this.EmployeeTableAdapter.Fill(this.Jp2DataSet.Employee); I have created additional queries to return select pieces of data. These are: FillMethodName: FillAssignmentList CommandText = dbo.AssignmentListProcedure CommandType = StoredProcedure ExecuteMode = Reader FillMethodName: FillGroup CommandText = dbo.GroupSelect CommandType = StoredProcedure ExecuteMode = Reader With this information set, how would I now go about calling one of these stored procedures? Is using Stored Procedures this way good or bad? If I switched my CommandType to Text, what would change in the way I called the query? I've looked on the MSDN site, but the many links I've found don't seem to answer how I would programatically call queries and procedures that I have added to my table adapters. Thanks for your help, and your time. Tag: Programmatically create Access 2007 database Tag: 143578
  - 22
    - oleDB hangs on ExecuteNonQuery The line insertStatus = cmdInsert.ExecuteNonQuery() is hanging; although the INSERT is working, because after I kill the application, I can see the new row. The OLE DB provider is set to IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider. Private Function VS_Insert(ByVal pndAmt As Decimal) As Boolean Dim currTime As String = Format(DateTime.Now, "HH.mm.ss") Dim currDate As String = Format(DateTime.Now, "yyyy-MM-dd") Dim success As Boolean = False Dim cnInsert As New OleDb.OleDbConnection(My.Settings.connAS400) Dim cmdInsert As New OleDb.OleDbCommand Dim insertStatus As Integer = 0 cmdInsert.Parameters.Clear() Dim query As String = "INSERT INTO PRODUCTION.DVABDAPV " & _ "(PONBR, LINENR) " & _ "VALUES (?,?)" With cmdInsert .CommandText = query .CommandType = CommandType.Text .Parameters.Add("?", OleDb.OleDbType.Char).Value = PONr .Parameters.Add("?", OleDb.OleDbType.Char).Value = lineNr .Connection = cnInsert End With handleConnection(cnInsert) insertStatus = cmdInsert.ExecuteNonQuery() If Not insertStatus = 0 Then MsgBox("The select failed") success = False Else MsgBox("The select WORKED") success = True End If handleConnection(cnInsert) Return (success) Tag: Programmatically create Access 2007 database Tag: 143575
  - 23
    - Calling DataAdapter.Update() on disposed DataSet? Hey, Some one gave a new developer of ours a project to make sure our core library funcitons are properly cleaning up resources (that's a good thing!), but I had consernse about one thing the developer was doing which sparked a debate with my co-worker. Some of these functions were returning DataSet objects, and the developer was calling the Dispose() function on the datasets inside the finally portion of a try block. For me, this kind of raised a red flag, because it seems to me the funciton is then returning an object which it has already "cleaned up". In some cases an "end programmer" might even want to take this dataset, modify datarow values and call a DataAdapter.Update() on it. It just doesn't seem like a very safe practise to me. Am I being overly cautious here? I guess I just have a problem with returning "cleaned up" object in general, to me it seems like no good can come from that. Thanks for your thoughts, Carlo Tag: Programmatically create Access 2007 database Tag: 143574
  - 24
    - VS 2008 control settings not persisting problem Hi I have noticed this problem with vs2008. I change settings for controls then I run the app and I don't see the changes at runtime. I stop the app and the changes are there in design mode. I close vs2008 and re-open app in vs2008 and app did not persist those changes and I have to do them all over again. Eventually the changes persist but only after re-doing them between 2-4 times which is a frustrating. Has anyone else experienced this problem? Is there a solution? This has happened with Infragistics Winform controls and Divelements WizardFramework. Thanks Regards Tag: Programmatically create Access 2007 database Tag: 143566
  - 25
    - When a clr has the input type of SqlString it causes nvarchar(4000) to be the parameter type of the function in sql server. how to modify my CLR function to use nvarchar(max) ? When a clr has the input type of SqlString it causes nvarchar(4000) to be the parameter type of the function in sql server. how to modify my CLR function to use nvarchar(max) ? Tag: Programmatically create Access 2007 database Tag: 143564
- Next
  - 1
    - Binding Navigator ToolStrip Actions Whenever I dropped a DataGridView onto my form, a Binding Navigator ToolStrip also installed over the DataGridView control. The actions on the ToolStrip control work great! In fact, for some of my File Menu items, I'd be happy to just call the method that the ToolStrip item calls (i.e. File | New). I've searched through my project (even the hidden/partial files), but I can not find any instance where these methods are called. For my File Menu's New item (miFileNew), how can I get it to call the Binding Navigator's ToolStrip item "bnAddNew"? Tag: Programmatically create Access 2007 database Tag: 143563
  - 2
    - No value given for one or more required parameters. During Select I am having a problem trying to run a Select Statment. I am using VB and ASP.Net 2.0 is on the server. I am connecting to an Access Database. Everything is working just fine on my test machine, but doesn't like our Production Server. It keeps giving me this error message: * Message: No value given for one or more required parameters. * Source: Microsoft JET Database Engine * Stack Trace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() at ASP.members_login_aspx.ValidateUser(Object Sender, EventArgs E) in d: \Hosts\vapa.org\wwwroot\members\login.aspx:line 73 * Target Site: ExecuteCommandTextForSingleResult * SQL: SELECT members.id, members.last_name, members.full_name, members.failed_attempts, members.active FROM members WHERE members.id = 1042 This is my code: If Page.IsValid = True Then Dim strDebug = "True" Dim strSQL As String Dim intCurrentFailedAttempts As Integer Dim strUID As String Dim strPWD As String strUID = Trim(txtUID.Text) strPWD = Trim(txtPWD.Text) strSQL = "SELECT members.id, members.last_name, members.full_name, members.failed_attempts, members.active FROM members WHERE members.id = " & strUID Dim objConnection As New OleDbConnection( System.Configuration.ConfigurationSettings.AppSettings("ConnectionString") ) Dim cmdSelectData As New OleDbCommand(strSQL, objConnection) Dim drAccountData As OleDbDataReader Try objConnection.Open() drAccountData = cmdSelectData.ExecuteReader() ... The code keeps breaking when it gets to drAccountData = cmdSelectData.ExecuteReader(): I have tried using different variations of the Select Statement and even tried to change it from a string to an integer (since all ID's are integers...) using Convert.ToInt32(Trim(txtUID.Text)) and I still receive the same error message. Does anyone have a suggestion on how I can resolve this problem. Thanks, Brian Tag: Programmatically create Access 2007 database Tag: 143562
  - 3
    - Split() function on single column result set? (VB.NET) Hi. I'm executing a DataReader and getting a single column resultset from a SQL Database. I need to load each resultset's row into a string array variable named CustomerNames(). Is it possible to do this? For example... Dim CustomerNames() as string CustomerNames = Split(mydatareader("columnname").tostring, ....) Thanks! Tag: Programmatically create Access 2007 database Tag: 143558
  - 4
    - Invalid attempt to FieldCount when reader is closed Hi I have a repeater control nested within another repeater control, and both the repeaters have a connection to the database. I'm having problems because the application complains that "Invalid attempt to FieldCount when reader is closed", even though I'm opening and closing connections in the right order. Can anyone shed some light on this? Code here: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connection As New SqlConnection(ConfigurationSettings.AppSettings("strDBConnect")) Dim command As New SqlCommand("usp_JobTypes_Get", connection) command.CommandType = CommandType.StoredProcedure connection.Open() Dim jobTypeDataReader As SqlDataReader = command.ExecuteReader JobGroups.DataSource = jobTypeDataReader JobGroups.DataBind() connection.Close() End Sub Sub JobGroups_ItemCreated(ByVal Sender As Object, ByVal e As RepeaterItemEventArgs) Handles JobGroups.ItemCreated Dim JobsRepeater As Repeater = e.Item.FindControl("Jobs") Dim connection As New SqlConnection(ConfigurationSettings.AppSettings("strDBConnect")) Dim command As New SqlCommand("usp_Jobs_Get", connection) command.CommandType = CommandType.StoredProcedure command.Parameters.Add("@JobType", 20) connection.Open() Dim jobDataReader As SqlDataReader = command.ExecuteReader JobsRepeater.DataSource = jobDataReader JobsRepeater.DataBind() connection.Close() End Sub Thanks, Mark Tag: Programmatically create Access 2007 database Tag: 143556
  - 5
    - OleDb can't read Excel file? With Visual Studio 2005 SP1 and DotNet Framework 2 SP1, Excel 2003 can read a file that was saved by Excel 2003, but the OleDb driver can't. Example: Excel row 2 maps to row 1 in OleDb, and Excel columns 1 to 24 (A to X) map to columns 0 to 23 in OleDb. Counting these in OleDb, row 1 columns 0 to 4 are OK, columns 5 and 6 get corrupted to DbNull, columns 7 to 12 are OK, columns 13 and 14 get corrupted to DbNull, etc. If I do Interop to Excel 2003 instead of using OleDb, it works. Counting these in Excel interop, row 2 columns 1 to 24 are entirely OK. Back to the OleDb problem. One worksheet has 40 columns instead of 24. The worksheet with 40 columns works. Several of the additional columns read as doubles instead of text but ToString() works on them. But all of the 24-column worksheets get corrupted by OleDb, and the corrupted column numbers vary. Does anyone know how to get OleDb to work? OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=NO'"); connection.Open(); DataTable schemaTable = connection.GetSchema("Tables"); DataRow[] schemaRows = schemaTable.Select(); foreach (DataRow schemaRow in schemaRows) { string tableName = schemaRow[2].ToString(); string tableNameNoDollar = tableName.Substring(0, tableName.Length - 1); OleDbDataAdapter dataAdapter = new OleDbDataAdapter( "SELECT * FROM [" + tableName + "]", connection); DataTable dataTable = new DataTable(tableName); for (int columnIndex = 1; columnIndex <= 24; columnIndex++) { dataTable.Columns.Add("F" + columnIndex.ToString(), typeof(string)); } dataAdapter.Fill(dataTable); int columnCount = dataTable.Columns.Count; int rowCount = dataTable.Rows.Count; if (!((rowCount >= 2) && ((columnCount == 24) || (columnCount == 40)))) { dataTable.Dispose(); dataAdapter.Dispose(); continue; } DataRow headerRow = dataTable.Rows[1]; // ... examine headerRow in the debugger; some elements are null ... string x = headerRow[5].ToString(); // crashes Tag: Programmatically create Access 2007 database Tag: 143553
  - 6
    - Enterprise Data Access Block and Web Services I'm working on some internal web services and I have a question about resource management within the Enterprise Data Access Block. I have about 20 methods which look similar to the one below: [WebMethod] public DataSet GetUserDataByGroup(int groupId) { string procName = "sp_GetUserDataByGroup"; return DatabaseFactory.CreateDatabase().ExecuteDataSet(procName, groupId); } My question is what happens to the resources created in DatabaseFactory? Are they disposed of properly? Will I run out of connections/ resources? If this is a bad way to write these ... whats the right way? Thanks, Kelly Greer kellygreer1@nospam.com change nospam to yahoo Tag: Programmatically create Access 2007 database Tag: 143544
  - 7
    - Inserting from a asp:table I have a sqldatasource and a asp:table as below, using the InserCommand from the sqldatasource how would I get the fields in the table inserted ? <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" <asp:Table ID="Table1" runat="server" Width="411px" BackColor="#C0C0FF" d> <asp:TableRow runat="server"> <asp:TableCell Text="Asset_ID" runat="server"></ asp:TableCell> <asp:TableCell runat="server"> :<asp:TextBox ID="Asset_ID" runat="server"></ asp:TextBox></asp:TableCell> <asp:TableCell Text="Agency_ID" runat="server"></ asp:TableCell> <asp:TableCell runat="server"> :<asp:TextBox ID="Agency_ID" runat="server"></ asp:TextBox></asp:TableCell> </asp:TableRow> . . . </asp:Table> Tag: Programmatically create Access 2007 database Tag: 143542
  - 8
    - Cannot bind an arraylist to a datagrid asp.net Hi, I have looked around for a solution to my problem with no results. My issue is that I cannot bind an arraylist to a datagrid control in asp.net. My code snippet: For Each ........ ......... ......... While dbread.Read() MyArrayList.add(dbread("iHawb")) MyArrayList.add(dbread("iDate")) MyArrayList.add(dbread("iTime")) MyArrayList.add(dbread("iStatus")) MyArrayList.TrimToSize() End While Next datagrid1.DataSource = MyArrayList datagrid1.DataBind() The error message: A field or property with the name 'iHawb' was not found on the selected data source. The error is because binding to a datagrid requires iList. A Radio Button, Drop Down List, etc can be bound but not a Datagrid,Datalist or a Datarepeater. Kind Regards Farook Tag: Programmatically create Access 2007 database Tag: 143541
  - 9
    - Test This is a multi-part message in MIME format. ------=_NextPart_000_0033_01C85D84.D0A37A60 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable ------=_NextPart_000_0033_01C85D84.D0A37A60 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-2"> <META content=3D"MSHTML 6.00.2900.3199" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0033_01C85D84.D0A37A60-- Tag: Programmatically create Access 2007 database Tag: 143539
  - 10
    - TableAdapter SQL Update Help I have 2 tables: EmployeeInfo and MGRSPV (Manager/Supervisor). On the DataGridView, we modified the EmployeeInfo Table's Fill/GetData to replace the EmployeeInfo.MGR value with the Manager/Supervisor's name from MGRSPV.[MGR/SPVSR] as follows: SELECT EmployeeInfo.FIRSTNAME, EmployeeInfo.LASTNAME, MGRSPV.[MGR/SPVSR] FROM EmployeeInfo INNER JOIN MGRSPV ON EmployeeInfo.MGR = MGRSPV.ID It was working great, but crashed with an unhandled exception whenever I tried to Save data on the 'AutoGenerated' line below. Now, VS refuses to compile: this.employeeInfoTableAdapter.Update(this.SqlSrvrDataSet.EmployeeInfo); 'EmployeeInfoTableAdapter' does not contain a definition for 'Update' I guess this means I need to write a custom Update query for the EmployeeInfo Table. Right? How would I write the statement? How would I later use the statement in my code? Do I need to manually read in and supply parameters from my form? How would they be inserted? Using SqlParameter with ParameterName/Value pairs seems like it would work, but then I'd need an SqlCommand and have to find a way to update the TableAdapter. The Wizard created everything on this except for the custom Fill/GetData SQL piece, so I am left out in the cold! Tag: Programmatically create Access 2007 database Tag: 143536
  - 11
    - Rename a Data Source How do I rename a Data Source as shown in the Data Sources pane in VS2005? At one time, the Data Source was given a name that matched the table we used from it. Now, we are using other tables from this Data Source, so the name is misleading. Everytime I try renaming, the project is no longer able to display the main form due to undefined components. Tag: Programmatically create Access 2007 database Tag: 143534
  - 12
    - loading an xmldocument object is that a way to load an xmldocument object into a dataset object? Tag: Programmatically create Access 2007 database Tag: 143528
  - 13
    - How to open MS Access database in VB 2005 hi everybody don't know if it's the right place to ask this qustion but I'm new with VB 2005 and need to open Access database in my project (the database was created with VB6). how do I do this task thanks Tag: Programmatically create Access 2007 database Tag: 143525
  - 14
    - When will ADO.NET Entity Framework? When will ADO.NET Entity Framework? http://www.alvas.net - Audio tools for C# and VB.Net developers Tag: Programmatically create Access 2007 database Tag: 143514
  - 15
    - The definition of access rights in MS SQL Server 2005 How programmic (C#) to know whether there is a right of access to the server object (table, stored procedure) for current user. http://www.alvas.net - Audio tools for C# and VB.Net developers Tag: Programmatically create Access 2007 database Tag: 143512
  - 16
    - C# ConnectionStringName Using VB, I can access the database connection string (or other application settings) using: Dim myconnStr As String = My.Settings.ConnectionStringName What is the equivalent in C#? Tag: Programmatically create Access 2007 database Tag: 143495
  - 17
    - how to remove databinding We have a database with one table of 15000 employees and 21 fields. (Yes, it needs to be restructured, but that isn't happening today). I have a DataGridView that is databound to the table. Whenever the application starts, it takes about 5-10 seconds to populate this DataGrid (depending on how congested our internal network is). I also have ComboBox controls for each of the individual fields in the database. Before, I was filling these in programatically from data in the TableAdapter for the DataGridView. While reading through a "How-To" book, I saw where I could have my ComboBoxes also bound to the data. Hoping for increased effeciency, I data bound each of my 21 ComboBoxes with a column from my table. Now, whenever I start my application, instead of taking 5-10 seconds to populate the DataGridView and display the form, it now takes (5-10 seconds) * (1 DataGridView + 21 ComboBoxes) to show the form. Ouch! I thought my application had crashed for an unknown reason! How do I "unbind" these controls now? There isn't anything in this "How-To" book on undoing the evils it started. Regards, Joe "How-To" book: Microsoft Visual Basic 2005 "Step by Step" Tag: Programmatically create Access 2007 database Tag: 143492
  - 18
    - Binding Source - Cant Delete - Can From BS Datasource Hi there, As i understand it binding sources are supposed to be a layer of indirection for an underlying datasource. However I often find my self unable to delete records from a binding source using the remove method, and yet if i delete a row from its underlying datasource/data table - thats work fine. What are the conditions surrounding deletes from a binding source? It a bit of a waste of time in providing "indirection" if i have to keep going to the underlying datasource anyway. Thanks Richard Tag: Programmatically create Access 2007 database Tag: 143453
  - 19
    - VBA code/style equivalent Hi I am synchronising one access db with its master via the below code; Dim dbSynch As DAO.Database Set dbSynch = DBEngine(0).OpenDatabase(<path local>) dbSynch.Synchronize <path remote> dbSynch.Close Set dbSynch = Nothing How can I do this in vb.net/ado.net? Thanks Regards Tag: Programmatically create Access 2007 database Tag: 143433
  - 20
    - Checking for table existence Hi How can I check for existence of a certain table by name in and access database and if the table exists find the number of records in it? I guess I can access this information by setting up a dataset for the database but I am wondering if there is a quick way to find this. Thanks Regards Tag: Programmatically create Access 2007 database Tag: 143432
  - 21
    - Linq - Relation in .dbml but not in code behind Hi I have a db the looks like DVD - (table) id (primary key , identity) title categoryId (fk on Category Id) .... Category (table) Id (primary key , identity) name ... Tag DvdID (fk on DVD id) name when i drop the 3 table on dbml the 3 tables and 2 associations are created but when i look at the code behind i only have entyref in category (EntityRef<DVD>) and DVD (EntityRef<Category>) why is it that i don't have the relations in Tag(EntityRef<DVD>) and DVD (EntityRef<Tag>) the way the code is generated i can't call dvd.Tags even if the relations is on the dbml any idea why ? i even tried with a relations table changing Tag table to id(primary key, identity) name DVDTag (tabl) DVDId (fk on DVD id) TagId (fk on TagId) the table and relations are created on dbml but not EntityRef in code behind maybe i'm just approching the tag feature the wrong way thanks for the help Tag: Programmatically create Access 2007 database Tag: 143430
  - 22
    - Dataset bug Hi guys, I'm using Dataset in my project. In design time I configure TableAdapter in the Dataset and set to the adapter as an Insert query following sql: INSERT INTO UserInterface.ViewFields (createdBy, createdOn, modifiedBy, modifiedOn, viewId, fieldId, logicalFieldName) SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID, fld.id, clmn.name FROM UserInterface.Fields AS fld INNER JOIN DBMetaData.Columns AS clmn ON fld.columnId = clmn.id WHERE (clmn.tableId = @tableID) The problem is that the method automaticaly generated by VS for this only sql (with others I don't have such a problem) has no parameters!!! I was more confused, when by click on "Query Builder..." -> "Execute Query" in "TableAdapter Query Configuration Wizard" VS asked me to enter these params!!! Does anybody know about the bug, and know how can I resolve it? Thanks a lot Aleksey Tag: Programmatically create Access 2007 database Tag: 143420
  - 23
    - Dataset bug Hi guys, I'm using Dataset in my project. In design time I configure TableAdapter in the Dataset and set to the adapter as an Insert query following sql: INSERT INTO UserInterface.ViewFields (createdBy, createdOn, modifiedBy, modifiedOn, viewId, fieldId, logicalFieldName) SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID, fld.id, clmn.name FROM UserInterface.Fields AS fld INNER JOIN DBMetaData.Columns AS clmn ON fld.columnId = clmn.id WHERE (clmn.tableId = @tableID) The problem is that the method automaticaly generated by VS for this only sql (with others I don't have such a problem) has no parameters!!! I was more confused, when by click on "Query Builder..." -> "Execute Query" in "TableAdapter Query Configuration Wizard" VS asked me to enter these params!!! Does anybody know about the bug, and know how can I resolve it? Thanks a lot Aleksey Tag: Programmatically create Access 2007 database Tag: 143419
  - 24
    - Help! Question about literal date strings and ADO I'm trying to write a web app in Dot Net 2.0 (VB) that accesses some old FoxPro 6 tables, connecting through OleDb. By necessity I need to manually write the Insert and update calls for the table adapters. One of the requirements of the project is that certain date fields be automatically set to a literal default value in the Insert function. The only way I've been able to find so far is to include a Date(1899,1,1) call in the values string. This works but the sql parser doesn't seem to like it much. Does anyone know of an alternative? Every literal string format I've tried so far has failed. (I have very little FoxPro experience.) Tag: Programmatically create Access 2007 database Tag: 143416
  - 25
    - TableAdaptor Configure and Query Builder Differences Hi, I am using VS2005 vb.net. I have a dataset.xsd file where I have added a dataAdapter and built my queries using the built in Query Builder. I am connecting to an Access database with the following connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\127.0.0.1\database \databse.mdb" Everything is ok but I have a problem selecting unique dates. Some dates are return twice! My sql is as follows: SELECT DISTINCT DateValue([DateTime]) AS [Date] FROM Job WHERE ([DateTime] >= ?) AND ([DateTime] < ?) I tested this with the QueryBuilder using the following parameters. I am using the format yyyy-mm-dd: #2007-12-17# #2007-01-19# and I always get the correct results i.e. a list of unique dates However, when I run call this query via the dataset function that is created I get different results for the same dates and same SQL. The dataset query autogenerates the following code: Public Overridable Overloads Function GetUniqueDay(ByVal DateTime As Date, ByVal DateTime1 As Date) As DataSetFilters.UniqueDayDataTable Me.Adapter.SelectCommand = Me.CommandCollection(0) Me.Adapter.SelectCommand.Parameters(0).Value = CType(DateTime, Date) Me.Adapter.SelectCommand.Parameters(1).Value = CType(DateTime1, Date) Dim dataTable As DataSetFilters.UniqueDayDataTable = New DataSetFilters.UniqueDayDataTable Me.Adapter.Fill(dataTable) Return dataTable End Function I noticed that the dates values passed into this function are converted by the Date type as: #12/18/2007# and #1/19/2008# The results of this query looks like this: 02/01/2008 00:01 02/01/2008 23:58 ---> This should be 03/01/2008 04/01/2008 00:00 07/01/2008 00:01 07/01/2008 23:58 ---> This should be 08/01/2008 09/01/2008 00:01 09/01/2008 23:57 ---> This should be 10/01/2008 10/01/2008 23:59 14/01/2008 00:00 14/01/2008 23:58 ---> This should be 15/01/2008 When I run the exact same query using the Query Builder->Execute and follows for the same date parameters (and doesn't matter if I use "yyyy-mm-dd" or "dd/mm/yyyy" as the results are always the same) I get the following: 02/01/2008 00:00 03/01/2008 00:00 --> Now ok! 04/01/2008 00:00 07/01/2008 00:00 08/01/2008 00:00 --> Now ok! 09/01/2008 00:00 10/01/2008 00:00 --> Now ok! 11/01/2008 00:00 14/01/2008 00:00 15/01/2008 00:00 --> Now ok! Does anyone have any advice what I can do to correct this? Thank you Regards Paul Tag: Programmatically create Access 2007 database Tag: 143414

Greetings...

From this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;317881
article I've knew how to create access 2000 databases. But what with
2007?

Best regards...

Top

Re: Programmatically create Access 2007 database by Jeff

Jeff
Thu Jan 31 03:52:45 CST 2008

On 31/01/2008 in message
<62fb1def-4a41-4be3-871a-bc6e81e9ba92@e10g2000prf.googlegroups.com>
68756E746572@gmail.com wrote:

>Greetings...
>
>From this:
>http://support.microsoft.com/default.aspx?scid=kb;en-us;317881
>article I've knew how to create access 2000 databases. But what with
>2007?
>
>Best regards...

You will be delighted to hear it's exactly the same except for the
connection string, a snippet from my createDB function (which is called
with filePath set up)

if (access12)
connString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=";
else
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";

connString += filePath;
connString += ";";
catNewDB.Create(connString);

--
Jeff Gaines

Top