Recent content by Mitch_____W

The .RefreshLink was what I was looking for. Thanks! Got it working, however when the link refreshes, it is fairly time consuming considering I am dealing with ODBC connections. I think I will try to delete/append the TableDef with the modified .Connect property and see if that transpires...

If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] & " And [EvaluatorMgr] = " & txtRandomMgr) = 1 Then MsgBox ("This user has already evaluated a manager") End If

SELECT Applicant_Loan_Info.Submission FROM Applicant_Loan_Info WHERE (((Applicant_Loan_Info.Submission) Between [Starting Submission] And [Ending Submission]));

Is it possible to "Edit" a TableDef.Connect value vs Creating a new TableDef with the connection string you desire, then deleting the old TableDef and appending the new TableDef? This would be a TableDef in a remote mdb.

Is there any way of converting MS Access Forms(And module behind) to Visual Studio.Net? I have a pretty comprehensive MS Access DB that has several complex forms. I want to redo this DB App in Visual Studio.Net but don't want to recreate the forms from scratch if there is any way of...

I compiled the DB's... no difference in the problem occurance... Not having a problem with the locking file closing (it closes/deletes fine), I am having a problem with the "MSACCESS" process not ending on the user(s) computer... Mitch

I have never compiled any of the FE's. I make changes too often at this point. I have repaired/compacted the DB's frequently. Doesn't seem to make much difference with the occurences... Mitch

I have witnessed users closing the DB's with the command button with the DoCmd.Runcmd acCmdExit code behind it and it still doesn't sshut down the ACCESS process in the task manager. Doesn't happen all the time though. Could it be a network issue? And I have full permissions set for all users...

I have a 2K BE mdb (on server) which may have, at any given time, 15 connections from 10ea 2K FE mdb's. Many times users have to end the ACCESS process via Task Manager before they can reopen a FE mdb on their box. What is causing ACCESS not to end it's process the last time the user(s) closed...

What are some good resources on the use of Recordsets via online or print form? I have several books on access and VB but none of them go in depth on recordsets... Crap! I meant to post this thread in the "General" Forum...

Check out the "Audit Trail Demo" db here: http://members.shaw.ca/glenk/access2000.html

I recommend you catch him off the premises and kick the living sh-- out of him.... Might be surprised how many questions you have that will be answered then... :D I crack me up!!!

Remove Admin from the Users group..... (A side note: I would create another user named something other than Admin and give that user (you) the same permissions as Admin had and then delete Admin)

Zip it first and then post it as a .zip file...

is there a "your Database Name".idb file present in the same directory as your db? If there is and you don't have the db open then somebody else has it locked. If you can't delete the .idb file then someone has a hung connection with it (seen this before even when user was logged off the...