Hi I've inherited a Access database that is used to import some data in SQL. The MDB opens with a form, in a modal mode: no Access menubar or buttons are visible. I can view the tables with content by using the Visual Studio 'Data Connection' tool, but I cannot see the module's code. I've looked at this question here, but the answers ...
I have the following T-SQL query (a simple test case) running fine in MS SQL but cannot get the equivalent query in MS Access (JET-SQL). The problem is the additional criteria in the LEFT JOIN. How can I do this in MS Access? T-SQL: SELECT * FROM A LEFT OUTER JOIN B ON A.ID = B.A_ID AND B.F_ID = 3 JET-SQL (what I h...
One of the best practices as specified by Microsoft for Access Development is splitting Access application into 2 parts; Front End that hold all the object except tables and the Back End that holds the tables. The msdn page links there to the article Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainabilit...
I am trying to run a query with Access. Each customer may have multiple revisions of the same 'widget'. Not all customers require the same revision, e.g. - CustomerA was entered in column 'ID' as 10, 13, and 34 - 34 contains the data I want to see without seeing entry 10 and 13 - each 'ID' has the date it was entered and the same 'widg...
How can I open an Access form so that it opens in Center screen? ...
I have MS Access reports that needs to be displayed in a crystal report in .net windows application. Is there any way to do it or some alternatives? I am not sure about the right approach to complete this, can anybody help here? ...
being a dbExpress newbie I wonder if there is a dbExpress driver for Microsoft Access? ...
I want to list all tables and their row count, in an MS Access database, in a grid view. I am using a query as follows: SELECT MSysObjects.Name, CLng(DCount('*',[name])) AS RecordCount FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND (MSysObjects.Name NOT LIKE 'MSys*')) ORDER BY MSysObjects.Name; In MS Access Query pane this works j...
I have code below which determines the version of Access. It runs quickly on most PCs. We also have four terminal servers. On two of the terminal servers it runs fine. On the other two, this code takes over 15 seconds to run. All four terminal servers have Access 2003 runtime. I can't figure out why it would take longer to run on two se...
Anyway to get Access 2K Module (vba code) editor to show line numbers? ...
What are the limitations for parameters when calling C# methods from VBA code using COM interop? I'm finding that if I call a method that takes a single simple type (string, int, etc) it works, but calling a method that takes a custom class as a parameter fails - with a 'Type Mismatch' error while compiling the VBA code. C# code: ...
I have a database that I have recently upgraded via SSMA to use SQL Server 2005. If I open a form that is bound to a table, it will display the data from the table; however, I am unable to edit the form and save the information. Simply typing in a textbox does nothing. I have noticed that the Access DB now has extra "tables" that begi...
Hello, I currently have a table in MS Access called Total Registrants. How can I insert string "N/A" into the cells of the column "EventRegCompany" where there are blank cells? I created an update query UPDATE Test SET Test.eventRegCompany = "N/A" WHERE (((Test.eventRegCompany)=NULL)); Thanks! ...
I have some add-ins that are used with an MS Access 2007 .accdb application. When I open the .accdb file --the first time-- (after logging into the PC), the add-ins initialize/load successfully. If I then close MS Access 2007, the second (and subsequent) time(s) I open MS Access 2007, the add-ins do NOT initialize/load. They will in...
Hi, I have a problem connecting to MS Access and MySQL using Java. My problem is that I cannot find the driver for MySQL. Here is my code: <%@ page import="java.sql.*" %> <% Connection odbcconn = null; Connection jdbcconn = null; PreparedStatement readsms = null; PreparedStatement updsms = null; ResultSet rsread = nul...
Hi, we need some data which is stored on several Microsoft Access databases on our servers, and our application will be executed on a Linux machine. So, our only alternative consist in using a JDBC Type 4 driver. In our research, we found two alternatives: HXTT - http://www.hxtt.com/access.html StelsMDB - http://www.csv-jdbc.com/st...
I'm designing a database for a franchiser. My skill level is intermediate at best (I just work in the franchiser's office). This database must define store locations and franchisees. So I know I will need a "store" table and a "franchisee" table. The "store number" will be the primary key in the store table. One franchisee can own mu...
What are the strategies you employ to let multiple people work on an access database? Is it possible to host it online and have its features still functional without having to develop a custom frontend? MS Access as a software has a few nice features that don't require any programming to configure: Drop down lists - choose one Multi ...
The limit of an access database. Because I only know of manipulating access 2003 database with vb.net. And were going to make an information system for a small hospital for our project. Is ms access still usable for a hospital with over 2000 patients per year? Could you suggest some database if the ms access that I'm using no longer fits...
I've got a website that runs on a shared hosting environment, using ASP.net 2.0 (C#) and MS SQL Server 2005. I've recently been asked if I can integrate my website with a piece of third party desktop software that uses the Access runtime as its database (transparent to the end user). Primarily I want to be able to offer users of my web...