Search results for query: *

Good Morning: When using Query Analyzer with the Developers' Edition of SQL Server 2000, on my XP Pro, Office 2003 desktop, the "Alter" item in the shortcut menu is disabled when viewing the "Script Object to ..." shortcut menus, after right clicking a table name in the object pane. For...

Good Morning FesterSXS: Thank you for your response. I doublechecked those settings and no luck so far. Smuckers "May your hysterical randomness be cured!"

Good Afternoon: I am trying to use a normal ASP program with approximately 50 asp files. The setup file that uses a connection string to MS Access fails. Now after trying the simplest of *.asp file connections to the MS Access Northwind.mdb database, that fails too. I tried using DSN &...

Good evening dtrahokie: I had to make the assumption that the last Update Number was the Maximum value and that the two tables were not joined. Note, this query is unique to MS Access only. The T-SQL version for Update does not work for MS Access in this instance, thus the use of the "DMax"...

Good Evening kdoran: I use the following process of adding info to a new line in a table. To summarize: 1. Declare and open an ADO recordset. 2. Must use the ".AddNew" and ".Update" statements if adding a new line to a table. 3. I assume you have an autonumber field, FieldTagNotesID, as...

Good Morning Machiaveli: This has worked for me with very low maintenance. 1. In Query Analyzer, start by verifying the proper functioning of a stored procedure calling a DTS package. 2. In Access, use the command ADO object to pass in parameters(s) and to run the stored procedure. Be sure...

Good afternoon Cranebill: Your original question was to see how the SQL string could be updateble. Review all the tables that are pulling data and look at the tables in the database relationships view. To be updateable, include those tables that are acting as bridges or connections between...

Good Morning pzaman1077: From your description it sounds like you are very busy. My approach is non-standard but I believe in your situation it my be helpful. I'll leave that up to you to decide. First of all, this is an evolutionary process. You may use any point to start and then move...

Good afternoon Masaud: This is how I got started. I learned SQL with a free program called WinSQL. It can be used for MS Access, SQL Server 2000, MySQL, AS-400 and many other applications with tables. The interface is very user friendly. Using WinSQL and MS Access Query interface, I was...

Good afternoon noorani: After reviewing your code and your problem statement, I think I can help. Unfortunately, I do not believe that there is only one problem. I offer to you a series of code tests to try. The result will be this problem being resolved or determing that Excel is not the...

Good Morning mikeyb540! I have experienced similar issues and handled them 2 different ways. Each time my objective was to force a change in the link/connection causing it to reset itself. Sorry, this is not good programming methodology but these two techniques have proven themselves. My...

Good Afternoon cg084! Hmm... I have used various security schemas without the Security Wizard. The code snippet below will restrict access to forms, buttons, controls or other objects. You'll need a couple of tables that will hold the following information: 1. Users Names 2. Passwords 3...

Good Afternoon mikeyb540! I used the following statement to successfully transfer and export form objects. Perhaps including quotes and fully qualified paths the statement will work. When you get close, the error messages will start telling you which argument or part is not working. I...

Good Afternoon kennetha! Yes,I do it this way and as long as the file is open the username and passwords may be used at any time. I first create a Class Module and name the properties. I named the class clsLogOn. ******************************************************** Public Property Get...

Good Afternoon pdbowling! I checked the Left$ method in the object browser of the VBE and found the Library to be VBA, or the Visual Basic Applications library. Hope this helps. Sincerely, Smuckers

Good Afternoon! I can't explain why but I can tell you what I did to fix the problem. My Projects use stored procedures as much as possible and these problems occur from time to time when using Form-datasheet views. In this case, I open the form in Normal view and click on the column heading...

Good Afternoon! Below it the title of the article that relates to the startup properties of a Project. The article covers programming in both the *.adp and *.mdb environments. I have used it to set a few of the properties for my applications. Sorry, I have not used it for the ByPass key yet...

Good afternoon! I am unable to edit an ADO recordset for a Form using Stored procedures. It works when the form has the property "Recordsource" set directly to a single table but not when it is dynamically changed using the code below. I created a small table of 3 records with 3...

[b]Good Afternoon! Open the DAP in Design mode and select the "command" button control from the toolbox. Make sure the wizard is on when the button is selected. It will walk you through the process. The result is a button that will save and advance the existing DAP entries and...

I have a split MS Access 2000 database, unsecured, on a network. The FE is shared via a common shortcut. The program locks out multiple users. When I click directly on the BE file, the error message, "Could not use "G:\Database_be.mdb"; file already in use" displays. I...