Search results

I'm converting an Access 2002 database to 2007. A form in this db has a text box has it's control source set to This works fine in 2002, but in 2007 just returns the irritating "#NAME?" To add to my puzzlement, I've added a button to that same form (for debugging purposes) with the following...

Has anyone found a solution for this? It seems to be occuring more often.. every couple of days... on a variety of different dbs (all Access 2002) and a variety of different PC's (None running vista). It's very irritating; I'll try to start one of my access apps and it won't start, no error...

The strSQL statement is fine. The code rewrites the pass-thru query in Access, then attemps to run it. The pass through query runs FINE outside of the code, it just won't run from within the code. IT's the statement DB.Execute "DemandHistoryNormalizedRefresh1", dbFailOnError which fails...

I am trying to run the following SQL pass thru query from MS Access 2002: This fails on the db.execute line, with error Connection failed: SQL State: 28000 SQL Server Error: 18456 Login failed for user 'pc3565k' But, if I cancel out of the code and then immediately execute the same query, it...

Thanks, just what I needed!

At long last I've gotten my IT department to set up a link to a remote server. Sure would be nice to be able to view the list of tables on the remote server! The only way I've found to do this so far is by using a system stored procedure: How can I set up a VIEW to return this same information?

I want to convert a DMax function that I use in my vb code to something that will more efficiently run on the server. code currently is: ddate=dmax("rundate","runlog","itemname='myitem') RunLog is a SQL server table that's currently linked to my db frontend. So I thought instead I could...

OK, I'm willing to believe that maybe this is caused by closing the app without specifically closing each recordset you may have opened, although it sure seems like Access should do this automatically! However, what's the best way to insure that you've done this? I try to remember to do this...

Thanks a million! It made my brain hurt, too, but it works!

Thanks much, that did the trick.

Well, that's frustrating! I'm trying to move my automated stuff out of Access, to improve reliability, but SQL server has a much more limited range of functions than Access / Excel. So this will mean I have to leave a very important, complex part of my app in Access. Just venting.... no reply...

I don't think I can use Analysis services. The excel function needs to be included in a View which is used in a Stored Procedure when I import new data. As I read it, analysis services is more for just reporting and data mining....? So I have this stored procedure which basically I cannot run...

I'm trying to use an excel function 'NormsInv" in a View on SQL server. MSKB says (NormsInv is NOT marked by an asterisk) I am confused about this "Analysis services" stuff, which I'm not (as far as I know) using. I'm just using SQL Server Management Studio. Should the excel functions be...

I changed to but still get the same error

What's wrong with my syntax here?? This works fine in Access 2002 but when I try it in SQL server I keep getting "Incorrect syntax near the keyword 'LEFT'.

Thanks for the replies. I have ended up (so far) using a combination of 1. My own code for comparing SQL in queries, table fields, and simple existence of all objects. 2. A commercially available program called AccessDiff for comparing design of forms and reports. Although I have yet to...

Hi, I need to find all the structural differences between 2 copies of a database front-end. I don't need to find differences in the data, but I do need to know of any other differences. Here's the scenario: About a year ago, I was 90% of the way through converting a large, complex, application...

Thanks so much for all the helpful input. Doc_Man, if I have problems in the future I may pursue your method but for now I'm going as follows: I've changed my db back to open non-exclusively. This, for some reason, allows z-cron to realize it's already open, so it doesn't try to open it multiple...

LPurvis, maybe I'm just slow, but I can't see how this will help. The app is already opened exclusively, that's not the problem. The problem is that when the cron job tries to open it again, I get "can't open file, already in use" messages hanging there until someone remembers to come along and...

LPurvis, this sounds hopeful but I'm not sure how it would work. If the app is already open exclusively, when I try to open it again it will never get this far, will it? Won't I still just get the "already in use" message? It seems like I would need to NOT open the app exclusively, and then...