I need to drop 175 of 180 tables in Access 2003 (using an Access 2000 format database). The first thing I tried was going to the table list and trying to select all, control-clicking the ones I want to keep, and choosing "Delete". However, it turns out you can only select one at a time. Then I found out a way to get a list of all the ...
I run a sports program where i have a master roll of who is in which class in excel. I want to link this to a database in access that stores the other information about each athlete, e.g. address, parents name, school, medical details. I want to be able to add names to class in the excel speadsheet and have this automatically generate a ...
Hi I have a very small application. This save data in mdb file (this mdb file only have 2 tables). MDB file is stored in my PC. From application I can set the path to my .mdb file. I have installed my app in 2 PC (office and home) and now I want to save mdb file in 1 pendrive. This way when I go home only I will have to plug the pendr...
I got stuck in the problem beneath, because I don´t use Access or Excel much and I have some basic programming language. So here's the deal: I just made a fairly simple database in MS Access (2007) with a nice query to retrieve data, depending on which parameters you pass. In Excel (2007), I have this big 'template' which basically has...
Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an Access database that for various reasons can't be upsized to SQL. This MSDN page says: The .NET Framework includes ADO.NET providers for direct access to Microsoft SQL Server (including Entity Frame...
Here is my query: PARAMETERS ... TRANSFORM ... SELECT ... ... PIVOT Mytable.type In ("Other","Info"); This is a cross query and I need to set all the column headings with this row: PIVOT Mytable.type In ("Other","Info") and now I have hard-coded the headings, Other and Info. But I want to do this dynamically. So what I want to do is ...
Hi all Some background: we have a windows application (c#) that locate in the system try. that simple application is a basically shortcuts manger for other application and messaging between the workers. one of the application is an Access 2007 application (connected to sqlserver) - the client works with ACCESS Runtime 2007 (latest vers...
At work, we use/develop a LOT of MS Access apps. Whenever the business has a significantly different problem to be solved, a new MS Access project is started. As such, although these projects are solving fairly different problems, they may actually use very similar code in parts of each project. There are only so many ways you can ext...
Hi there I'm trying to set an ODBC connection to a MS Access, with an Asp.net app. I keep getting this error message: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Office Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission ...
I am working on replacing an old ms access system with an SQL server one with a C# front end. Unfortunately I have some die hard ms access users who will be accessing the SQL server tables from ms access but to them it should essentially look the same. When tables are created in ms access and a relationship is created between them they ...
I've got a query that returns Headcount and Newcomers values for months like this: Month Headcount Newcomers January 12 2 February 14 1 ... and so on. I would like to display them in a report this way: January February ... Headcount 12 14 Newcomers 2 1 Is it po...
I am trying to create a form in Microsoft Access that has 2 ComboBoxes. The first ComboBox is populated with a SQL query that accesses a list of values from a table. The 2nd ComboBox is will also be populated with a SQL query, but the 2nd ComboBox SQL query takes a parameter. I want to use the text that is currently in the 1st ComboBo...
Hi I am running on php. And in my local I am working on windows environment so it was easy to connect to MS Access Database using ODBC connector. But on my live server environment there is Linux so there is a problem regarding the DB connection. So what are the steps to connect to MS Access DB in Linux environment using php. Thanks...
I am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement. Here is what I got so far. Dim cn As OleDbConnection Dim cmd As OleDbCommand D...
I have a table Project. It has the following column: Project ID, projectName, UpdateTime The data in the table is as follows: Project ID projectName UpdateTime 1 abc 12-2-2009 01:10:00 1 abc 12-2-2009 04:18:00 2 xyz 17-7-2009 08:45:00 2 xyz ...
I have form with 1 button. when you click on the button 3 others appear which relate to product colours red green or blue. At the moment when you click on a colour button it opens a form just for that colour product. Is it possible to have just one colour form that opens when any colour button is clicked but will filter the parts relat...
I have a VB6/Access application that occasionally encounters a problem with wrong autonumber field seed. Lets say there is a table MYTABLE with an autonumber field ID (that is also the primary key). Lets say at the moment the maximum value of ID is 1000. When the application inserts a new record (ID value is not provided explicitly), f...
Have a Access 2007 database which needs to have a report that prints out some really big numbers (for some signage). Currently in Excel the template uses a 400 point font size. When trying to change the font size in Access the following error message appears: The setting of the FontSize property must be from 1 through 127 I tried...
I want to add functionality to my Access 2007 report whereby a PDF copy of the report is created at the click of a button. I know that there is an OutputTo macro which can do this for me, but it does not allow me to include report field values as part of the PDF's filename, namely: [Client Organisations].Code + "-" + Clients.Code + "-" +...
First off, I'm using Access 2000 and DAO. I have code that executes a simple INSERT INTO query that I call using db.Execute. This code works fine inside an mdb. However, if I compile into an mde then I get error 5 - Invalid procedure call or argument on this line and the record does not get inserted. However, if I change from...