How do I test if a recordSet is empty? isNull?
I would check the “End of File” flag: If temp_rst1.EOF Or temp_rst2.EOF Then MsgBox “null”
ms-access
How can I join two tables but only return rows that don’t match?
SELECT T1.* FROM T1 WHERE NOT EXISTS(SELECT NULL FROM T2 WHERE T1.ID = T2.ID AND T1.Date = T2.Date AND T1.Hour = T2.Hour) It could also be done with a LEFT JOIN: SELECT T1.* FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID AND T1.Date = T2.Date AND T1.Hour = T2.Hour WHERE T2.ID IS NULL
What does ApplicationIntent=ReadOnly mean in the connection string
This means that if you are using Availability Groups in SQL Server 2012, the engine knows that your connections are read only and can be routed to read-only replicas (if they exist). Some information here: Configure Read-Only Access on an Availability Replica Availability Group Listeners, Client Connectivity, and Application Failover If you are not currently … Read more
What will we do after Access? [closed]
Access is not a DBMS. Or at least it’s not just a simple DBMS. It’s a very good RAD environment, a simple way to create SQL code graphically, and a regular front-end to fully fledged DBMs. Neither SQL Server (Express or MSDE) nor Oracle, MySQL, etc. will ever replace it, until they come integrated with … Read more
How can I show an “&” (ampersand) in button or label text?
If you are trying to display & in button text, use &&. A single & is used for keyboard shortcuts, and a double ampersand will escape that. The article Escape ampersand (&) character in C# mentions that you can leave the caption unaltered with single & and just set UseMnemonic property of the button to … Read more
Can we create multicolumn unique indexes on MS access databases?
Turns out you can create a multi-column unique index on an MS access database, but it’s a little crazy if you want to do this via the GUI. There’s also a limitation; you can only use 10 columns per index. Anyway, here’s how you create a multi-column unique index on an MS access database. Open … Read more
Lightweight SQL database which doesn’t require installation [closed]
Depends on what you mean by lightweight. Easy on RAM? Or lighter db file? Or lighter connector to connect to db? Or fewer files over all? I’ll give a comparison of what I know: no of files cumulative size of files db size Firebird 2.5 5 6.82 MB 250 KB SqlServerCe 4 7 2.08 MB … Read more
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
For Java 7 you can simply omit the Class.forName() statement as it is not really required. For Java 8 you cannot use the JDBC-ODBC Bridge because it has been removed. You will need to use something like UCanAccess instead. For more information, see Manipulating an Access database from Java without ODBC
Classic ASP SQL Injection Protection
Stored Procedures and/or prepared statements: https://stackoverflow.com/questions/1973/what-is-the-best-way-to-avoid-sql-injection-attacks Can I protect against SQL Injection by escaping single-quote and surrounding user input with single-quotes? Catching SQL Injection and other Malicious Web Requests With Access DB, you can still do it, but if you’re already worried about SQL Injection, I think you need to get off Access anyway. Here’s … Read more
How do I create a table alias in MySQL
Off the top of my head CREATE VIEW dbo_customers AS SELECT * FROM customers Maybe not the best solution but should work as the view is updatable. Will definitely work for Read Only