Search results

I have a form that is used to update some tables, and I have it located on a network drive. What I am trying to do is get around the form lock or table lock error I get when I am on a form and another user tries to get on that form, and they get an error stating they can not update, cause it is...

I have a form that is used to update some tables, and I have it located on a network drive. What I am trying to do is get around the form lock or table lock error I get when I am on a form and another user tries to get on that form, and they get an error stating they can not update, cause it is...

SP = Stored Procedure (on SQL Server) I actually did the same thing as suggested - I created 10 forms with status bars on them. The first one with 10 % complete, then 20, then 30 and so on. The problem I am having is that the sp's run so fast that the status forms do not have time to...

Won't really work.. Good idea - But it takes too long to refresh the screen. The sp's only take about 30 seconds, and by the time the visible property is set to false - the next sp is already complete. This is kind of what I was thinking though too.. Does ANYONE know how to have an image pop...

This will be easy for most probably... I have a button that calls 9 SP's in sequence, and I am wanting to display an image for the user while a sp is running and once it completes and the nest sp starts the image will go to invisible and the next image will become visible. I am doing the same...

This will be easy for most probably... I have a button that calls 9 SP's in sequence, and I am wanting to display an image for the user while a sp is running and once it completes and the nest sp starts the image will go to invisible and the next image will become visible. I am doing the same...

Thanks! Thanks man - I hate it when I forget the easy things : )

OK - this may be easy or may be hard - not too sure. I have a procedure that calls about 7 stored procedures in a row off the SQL server and once the last one returns it will pop up a form for the user. Problem - I am filtering through about 8 million records and it takes a minute or two. So...

It is a memeber of the accessobject class. I looked it up in the object browser.. Has anyone used it before? Thanks, Brian

I am having problems with this isloaded function. I am using it in my login routine and it keeps giving me "compile error sub or function not defined" Does anyone know what I need to do to get this function to work?? Here is the code I am using.. If Not isloaded("frmLogin") Then...

Anyone??? I am using ado - so as far as I understand ado - once I open a connection - it will stay open until I close that connection??? Any other thoughts??

I am actually not using an odbc driver. I created a new form in a new access database - and just put a button on the form with the code I pasted earlier. So I the only connection I am using is the adodb.connection string... any thought?? I have also swapped the code out for other things and...

I don't think so. I can run the sp on the sql box through query analyzer and it runs for about 4 minutes with no parameters just fine (transfering about 6 million records), but when I run it through the access front end where it is calling the sp through ado it times out on me... ??? Thanks...

Unluckily I have tried that. It is really funny - I have created a new form in a new project and called the same sp and it does the exact same. Everytime it errors out between 30a nd 35 seconds. Is there some global setting I am missing somewhere? I appreciate the help... BS

Ok - I am calling a stored procedure that runs anywhere from 30 seconds to 6 minutes depending on what parameter the user enters. My problem is that when ever it runs for anything more than 35 seconds I get a runtime error for timeout expired. Here is my code: Private Sub Command0_Click()...

I have been trying to figure out the adodb.command and I keep getting errors... If I am in the subroutine for a command button, and I am just trying to connect to a sql server (SQLTEST1) database (DBASE1) and all I want to do is run a stored procedure (sp_test1) - What would the code be for the...

This will be an easy one for you ACCESS guru's I am sure. I have built an application in ACCESS2000 and a backend in SQL 2000. I have a main form with many subforms that I am asking for user input with. When they enter the data it is stored in a few different tables in SQL. I then have a...

Not trying to be mean - But did I ask a really hard question? I don't know half as much as most on here about ACCESS, but I did not think it was a really hard question. If it is just let me know so I will know to seek knowledge somewhere else? Thanks, Brian

Not trying to be mean - But did I ask a really hard question? I don't know half as much as most on here about ACCESS, but I did not think it was a really hard question. If it is just let me know so I will know to seek knowledge somewhere else? Thanks, Brian

I am using ACCESS as the front end and SQL server as the backen. I am using ODBC to link about 20 tables through ACCESS. My question is: I want to run some sort of a script when you start the application to refresh the links to sql server. What and where would that code go? Thanks, BS