Waldek

I wonder if anyone has solved this problem already. I have a fully populated datatable (ado.net datatable) containing about 3000 rows of data with 53 fields. I want to copy the contents of the data table into an access database table ready prepared and empty which has the identical structure …

I have a problem that hopefully someone can shed light on. My OleDBdataadapters and OledbTableadapters have gone on strike!! In a simple vb.net 2005 pro project I have an Access 2003 .mdb with 2 tables each with 1 primary key and all other fields allowing zero length and not required. …

Has anyone succeeded in creating a class library solution/project in VB.net VS2010 4.0 Net Framework for COM to run on WindowsXP Excel 2003. I created a dll which changed specific data in an excel worksheet. The dll worked just fine on the development computer but wont work on any other. …

Hi Leodumbi, I'm no expert but I wonder why you are using ADO and recordsets instead of ADO.net? If I were populating a datagridview from a datatable I would use a command object that used an sql string which has an extra field that multiplies your 2 existing fields within …

Have you actually got the interop for excel. I did this a while ago for word and access and had to download and install the interop assemblies from MS website to the GAC (Global Assembly Cache).

Hi SaberExcalibur, I had this sort of problem and also found that the database wouldnt update properly. The database update problem resulted from vb.net creating an additional copy of the database, unbeknown to me, in the debug subfolder on which all the updates were being made. Check your assemblies (cant …

Hello All! Does anyone know how to list all the paths to one or several (if they exist) versions of msaccess.exe on a PC. I'm using VB2005 and have a project with an Access backend that contains reports which are called at various points. These need to be opened with …

Hi Everyone, I wonder if anyone out there has deployed a solution successfully like mine? I have created a vb.net 2005 winform solution that can be installed on a desktop. It uses an access 2003 database to hold data. The setup.msi was created using the vs.net deployment menus. The solution …

Hi All, I have a problem with a datagridview (7 columns) of which last 2 columns are combo boxes. The datagrid view was set in design view with column names same as a table called OccRecStaff but without a datasource. Although the datagrid view works perfectly for the first 5 …

I'm a vba and former vb6 developer and I work in the UK, mainly in Access, Excel and sqlServer. I've been learning VB.Net 2005 for a couple of years as a hobby. I've joined the forum because of selfish reasons, yes youre right, I've got a problem. I'll use another …