Search results for query: *

Hello, I have been having a hard time with this so I decided to ask for help. I am trying to insert student names from one table to another. The student name is the primary key in the new table and I have about 300 records. How do i insert all records at once? Thanks NewbieDev

Hello, I am trying to write a query that selects students that enrolled between a two dates: select firstname, lastname from students where startdate >= 10/1/2007 and startdate <= 09/30/2008 But this is not working for me because there is something I should be doing with the dates that I...

Hello, I am trying to update 3 fields in 3 different tables - these fields are related so for some reason I can't change one before the other. I tried updating the primary table first, and then the other tables using it as a foreign key but it wouldn't let me. Is there a cascade update thing...

Thanks Phil, Yes, the users may have to login at their workatation to use the application without entering their username and password - I think we may have something else for users who are not at their workatations to enter their username and passwords. This option will only show if the user...

That's almost all I was looking for! I will give it a shot. Thanks!

Thanks! I will give this a shot and let you know how it works out.

I am pretty new to WMI Scripting but I heard one could use it to find out who is current logged into an access Database/application. Would really appreciate any help with puting the script together - I want to be able to know the workstation/username/time/date that the user logged in, and...

Hi Everyone, Does anyone know how to capture windows environment variables for Windows XP in coldfusion/Html? I am trying to use such info for login security. Any help will be appreciated. Thanks!

thargtheslayer - What do you mean by take care of the tables for me? Do you mean I shouldn't worry about students being related to all the classes etc that they currently have in the access database? And that the tables will be loaded with new ID but relationships will be kept intact? I am not...

Thanks fo the response philhege - Yes, it is an intranet App. Yeah, the problem is users sometimes have to use other workstations so we have to at least keep track of the username, and check it against the username and access level in the DB. Is there a way to capture windows workstation...

Thanks Guys, JoeAtWork - The front end is an Access MDB file (with I think some VB6 code)which links to an Access DB backend. Yes, everyone is opening the same fromt end. Hmm... I actually thought about that for a second but discounted it because i don't know that much about access. I'll try...

Thargtheslayer, Thanks for the response. This is the problem I am trying to solve: We have this application created using an access database that is now being transfered to an Oracle Database which will have more tables than existed in the original Database. We are trying to assign new...

Hi Guys, Thanks for the reply! thargtheslayer - Let me see if I get this: After doing everything needed to create the external table, I will not need to create source tables in Oracle, but query the external tables (which is really a text data file) for records that need to be inserted into my...

I have an application that was created using an Access Database backend and a Visual Basic forms front end. The users have been geting numerous error messages informing them that the Database has been corrupted - ussually all we have to do is restore the VB GUI fron end and everything will be...

Hello everyone, I have a few questions. I currently have a ColdFusion application in which users are assigned a username and password to be able to access/use the application. The problem is people are tired of entering different passwords for different applications and they would like a...

Hello everyone, I have a few questions. I currently have an application in which users are assigned a username and password to be able to access/use the application. The problem is people are tired of entering different passwords for different applications and they would like a single sign...

Hi everyone: I need some help with some data migration related issues. I am receiving a couple of flat files from a DB2 database. These flat files will be placed in a designated folder. I was told this folder will have to be on a server that has COntrolM so that it could be picked up by ORACLE...

Hi Everyone, I have some data migration questions. I have been tasked with migrating an Access database to an Oracle database. The Oracle database structure is different from the Access database as I now how more tables, and existing tables were somewhat modified to have more or less fields...

Is there a way of making the auto suggest drop-down 508 compliant? It should pass both JAWS and Dragon testing. Thanks, NewbieDev

Thanks for the reply!