Search results for query: *

I have html report files (.html) that i need the actual data that resides in the report to store it in SQL to use as relational data. What is the best way that I can import this data from html into a sql table? I have a whole directory of these files. I just manually exported to excel and the...

How do I compare a field with part of another field? For example I want to know what filenames are included in file path names... If I had a filename (2008file.pst) column in table A and wanted to know if it was included in any records in the path (C:\Folder\2008file.pst) field of table B, how...

I am trying to create a stored procedure based on looking up information in system tables. I am pulling basic information such as Table name, records, field names, field types etc which is the source of data for an SSRS report. This is currently working fine. There is a request to add fields...

Are there any considerations or things to set up in SQL Server 2005 when you upgrade the amount of RAM on the server that runs SQL Server? We are upgrading the server from 16 Gigs of RAM to 32. I know if SQL is restarted it should use the maximum amount of memory available in the settings, as...

I have an ActiveX script where I am reading a text file into a variable through an FSO. I have to loop through to check each record's length. The problem is my condition on the loop when i check for end of file. I know when you use a recordset, you can say when the object eof, but i'm not...

What needs to be done to create an automated backup in MySQL Administrator? It prompts me and tells me that a file is needed with the password stored.

I have a MySQl database on the backend of an Access front end where multiple users update client information as calls come into the company. All of the data is now linked into Access from linked tables. The problem is the response time when they are adding records. It's not a heavy volume at...

I have a MySQl database on the backend of an Access front end where multiple users update client information as calls come into the company. All of the data is now linked into Access from linked tables. The problem is the response time when they are adding records. It's not a heavy volume at...

Can you use an Access select query that has two MySQL tables joined as the record source for a form? I know that the tables work, but I am not sure because the query will not work as long as it has MySQL tables in it.

I have several linked tables from MySQL in Access. Only two of the tables, which are updated from access show all deleted data in the columns when I open the tables in access. But when I open them in MySQL the data is fine. Anyone have any insight to this? Bob

I have several linked tables from MySQL in Access. Only two of the tables, which are updated from access show all deleted data in the columns when I open the tables in access. But when I open them in MySQL the data is fine. Anyone have any insight to this? Bob

Is it possible to run a DTS package from a stored procedure or from a command? If so, which command? I must be able to do it from a pass-through query or from query analyzer....Thanks

I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ... Server...

I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ... Server...

I am just starting to work with MySQL and I have it installed on a separae PC at my home as well. I downloaded and installed it, MySQL Administrator and the query analyzer as well. But I need to know how to create an initial database or does mysql come with a default database? I am asking...

I have a request for a file that contains a field for a record identifier. This field must be unique per record per file. Now to assign this number I obviously can't create a regular query, and I am thinking a cursor is the best way to go to access each record one at a time. I am thinking of...

I believe I have a corrupt table in Access. I found the record that is corrupt and could not delete it (Invalid Argument). I backed the DB up and tried to run a compact and repair and it said the DB encountered a problem and needs to close. I also tried to run a JetCompact and it said the...

I get an "Invalid Argument" error when trying to run a query from a report with a parameter in the query which prompts for a last name to run the query. When I take the parameter out of the criteria line of the query the query runs fine and returns all records. This only happens when there are...

I am experiencing a problem with all of my queries that are sorted by a field. I am getting an "Invalid Argument" message whenever there are other users in the database when trying to run the query. When I take the sort off, the query runs with no problem. Anyone have an idea as to what this...

I recently set up security on an Acces Database with about twenty users. I set this up through a workgroup. I did not assign any initial passwords for the users, as I will require them to set their passwords when they initially log in the first time. What my concern is, is now I need to...