Search results
-
M
Combo Box with fixed database structure
cascading Combo Boxes. I have front end to an SQL database that requires drop down combo boxes. I have seen and used combo boxes from the forum. The problem I have at the moment is the underlying database structure. A batch is a Sub division of a Release The is the server table that holds... -
M
Query Access to Secure Database
Thanks Ken, I am looking at the posibility of having two DBs -
M
Query Access to Secure Database
However they only have read_only access to the tables -
M
Query Access to Secure Database
The problem is than we would be tracking 2 database for upgrades -
M
Query Access to Secure Database
I have a database that does not allow the users to view the "database window". The users are also locked out from using shift. However we have a requirement for a "Query User" which would have "READ-ONLY" access to querys. Is there a command that can open up the database window even if it is... -
M
Regular Expression and Wildcard
I worked out the syntax in the where clause it was * -
M
Regular Expression and Wildcard
In the my database users have decided to an "*" or "?" to confirm a contact rather than use a contact confirmation flag (don't ask me why).. What I want to do is construct query to search all record in a particular field which have the character "*" at the end.... -
M
Database keeps Currupting
I hve looked through the code nothing stands out... and all fields seem fine although some strange queries have appeared starting all starting with a ~ -
M
Database keeps Currupting
I have an access database with about 5 users on. Recently we are experiencing regular database corruptions. These are relatively easy to fix but are very annoying for the users. Is these any way to analyse the what causes corruption of a database?. Any help would be appreciated – thanks. -
M
Result format
The current SQL I have is. SELECT data_server.Server_Name, data_System_1.System_Name FROM ((data_server INNER JOIN (data_System INNER JOIN data_System_Membership ON (data_System_Membership.System_Name = data_System.System_ID) AND (data_System.System_ID = data_System_Membership.System_Name))... -
M
Result format
Hi, I have a query that is trying to find out which systems are on a server. I have a server table, and system table and a link table between them. When I run a query for example server 1 I get the result in the following format. Server 1, SystemA Server 1, SystemB This denotes that the...