Recent content by tjm77

I am only getting this error after the file is closing. I don't know what else there is to look for. Its a very simple access file. Any ideas?

I am getting an error message after I run an MS Access 2000 file. I don't get it on all files and I can't seem to figure out the problem. The error message is: Cannot find file C:\databases\file.mdb (or one of its components). Check to ensure the path and filename are correct and that all...

I am trying to automate a process that runs through the windows at command. It opens up access97 program that in returns trys to open another application that connects to our mainframe and extracts data. When I click and run it, it works. But when the at command calls it I get the following...

Figured out my problem. You have to go to the server and give permission to the user name at that host. Change the permissions that you want on the server for that user and user machine.

Has anyone ever had a problem where you set up a dsn connection and put the server's IP address in and test it only to find out that the test is using a different ip address? I can't understand this one bit. I created a DSN connection to an IP address and when I test it, it comes back and says...

I am getting an invalid object error when trying to run a ActiveX tree in a form. I am running 2000, but i have the same code in a 97 form and it works fine. Any thoughts on why I am getting that error? code: Dim rstSchedules As Recordset Dim db As Database Dim nodX As Node Dim...

Is there anyway to run the database utility Compact through the use of VBA?? I want to set up a button that will compact the database just by clicking and not going to tools, etc...

I want to create a column, but want to change the properties of it using code to an autonumber format? Any idea on how to do that?? this is what I have so far: DoCmd.RunSQL ("ALTER TABLE tec_trac ADD COLUMN auto LONG;")

I have an online form that should write to a Access table, but I keep getting the following error: The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. /requests/request.asp, line 20 Line 20 looks like this...

I am running into an order by problem. I have the following select statement: fp_sQry = "SELECT * FROM tblCMPS WHERE techID = '" & techid & "' AND year(rptMonth)=" & tYear It works fine, except that there are two tabs on the webpage, one for 1999 and 2000, the...

I keep getting a Dr. Watson nt error of inetinfo.exe read access, which disables my web site. Any ideas on why this error is occuring or what to do to fix it. If I reboot the machine it goes away and works for a while and then the error happens again one to two weeks later. ideas, suggestions??

I have had Backup Exec running on my server for months with no problems. I have logged onto the server with the save user name and password, with no changes in either. But I still get the following error: Logon attempt with current password failed with the following error: Logon failure...

I have a Crosstab query that combines two other queries. My problem is that for some of my columns I have a blank or null value. So when the two queries match up by a date relationship they leave blank or null values for ones that do not have that date. In other words, is there a way to...

I have a database that will not come off of record-locking (i.e. lbm extension on it) I have rebooted and shutdown several times. Any ideas on how to fix this.

The Backup Exec (TM) Agent Browser service failed to start due to the following error: The service did not start due to a logon failure. Any ideas on how to solve this issue without reinstalling??