Search results for query: *

Problem solved... Apparently "CurrentDatabase.Connection" is simply the current database (MDB file) you're working in. The creator of this database simply had flagged all of the tables as "hidden", so they weren't showing up. Quite annoying, and definitely unnecessary but, problem solved...

Also, in some of the searching I've done, it appears that perhaps the CurrentProject.Connection is some global setting typically related to an ADP (Access data proejct), which I'm completely unfamiliar with. However, I found only one ".adp" file on our server, in some backup folder, and it...

So I got to pick up the pieces on somebody's old code, and could use a little help since my Access skills are a little weak. I have this MDB that is used to import data from an MDB file into an Oracle database. It consists of forms and a bunch of modules, but no data tables, so the data is...

Hello all, I'm trying to help a friend restore all of the emails in his inbox that are now missing. He had 300-400 emails in his inbox but after a problem this mornign they're all gone. Here's the scenario. This morning he called me because he kept getting these same 54 emails over and over...

Note that there's one commented out line in there with a few @sumfunc variables on that line. Also, this query is pretty much a crosstab/pivot query much like MSAccess had built in. Most of the query code shouldn't matter much in your reviewing it, but rather maybe an explanation as to why an...

This problem has been baffling me for days and i just cannot figure out why it is not working. I have the following stored procedure which runs perfect and returns the perfect information when running it from the SQL Query Analyzer (QA) or from the Enterprise Manager (EM), but when I try to run...

Found a solution that will actually work in this instance where i've only got a few fields and all data will fit in the query string... - -- - -- --- -- - - - - queryString = "email=" & email & "&firstname=" & firstname & "&lastname=" & lastname set xml =...

Help! I am using XMLHTTP to push data from one ASP page on one remote server to an ASP page on another server. The receiving page needs to accept the data and insert it into the database. If I'm using XMLHTTP to shuttle the info to the remote server, how do I setup my receiving page to...

Hey there PREPRESSHELP, I have this same problem. I found and removed the trojan a while back but am still having this security problem did you find a way to fix it? Or did it seem to fix when you removed the Trojan? Also, I have a number of folders named with invalid names such as...

I am a fairly seasoned ASP developer and am looking for a tool/api/method to allow website visitors to search through the body text of an archive of PDF documents as well as searching site HTML files. I have a fairly robust TXT/HTML/ASP page search, but am looking for an easy way to add PDFs to...

I just wanted to point out one thing, the above attempt fails because if multiple rows are updated I'd be attempting to SET "class_id" = multiple records of the (SELECT class_id FROM updated) query, which of course doesn't work. I'm looking for a way to get around this. Thanks, ST

How do I write an update trigger that will run for each record, rather than for the entire set of updated records? Is there any way to access individual records of the UPDATED table? I have a table called CLASSES with a STATUS field amongst others. This status field contains a value of...

Hi, we're about to purchase a PIX 510 for our office here and I've got a question about the licensing. We have about 12 users who we'll want setup using DHCP and that will need to be able to hit the outside web. We also have 2 servers using about 5 IP addresses combined. My options are either a...

Are you creating a second profile and adding the Internet E-Mail service or are you adding the Internet E-Mail service to the same profile? Attempting to add an additional internet email service to the existing profile. There is one internet email account already, and I'm just trying to add...

Outlook 2000 Workgroup or Corporate (I don't remember which, this is a client's machine and I'm trying to help). Trying to add a second Internet mail account in outlook 2000 and it doesn't seem to be receiving email. If I walk them through the steps in Outlook Express they are able to receive...

I found a solution. Figured I'd post in case anyone else runs across this same problem. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q193998

I have images stored NOT in the database, but I have their filenames stored in the database. I want my ASP page to do a BinaryWrite of the image somehow if I know the filename. I know how it works if I am pulling an "image" from the database, but that's not what I'm looking for. I need...

I want to set a background for a <TD> cell and have it aligned to the bottom of the cell so that as the content grows, the image is still always at the bottom as a background. Any ideas? I need it to work in Netscape (yes, older than 6.. preferabbly 4 and up)... and at least IE 4. I know how...

Nevermind, found the problem. Figured I'd post the answer in case anyone else has a similar problem. The problem is that we are using WINS rather than DNS for our network. So what I had to do was edit my c:\winnt\system32\drivers\etc\hosts file and add the line &quot;192.168.1.1...

Our server connects to a firewall and then out to the internet. For some reason, when our external connection is lost, I can no longer connect to the SQL Server. I am connected to the server in Enterprise Manager by using the server name &quot;myserver1&quot; and using windows authentication. We...