Search results

This is probably a pretty basic question, but I figure I am making it more difficult than it needs to be by overthinking it. I have an equipment database. I have a table that lists all equipment manufacturers. What I am trying to figure out is how to assign a MFR ID which is sequential to the...

The former of course :D Look up "technical writing" - That may give you a good idea on how to go about your manual

I see a golden opportunity for a $250/hour consulting service LOL.

What most of my databases are used for, don't require multiple back-ends, but that could change. I was just reading some things about access and happened upon threads/articles talking about multiple back-ends. It just got me thinking about how I would go about handling it given a scenario...

Right, I agree. But regardless of where they reside and when they need to be re-linked, what is your preferred method of re-linking given the scenarios I listed (or others). For example, do you have your users 'browse' for each back-end?

I'm not sure if this belongs here or in the "Theory and Practice..." area. Please move if needed. My question encompasses a front end connected to multiple back ends. It is probably a mundane point, but reading a few articles didn't seem to touch on it. By this, let me toss out that I am...

I agree with what Dave and Uncle Gizmo stated. They are solid ideas. You can only "lock down" Access so much, and even that isn't going to stop a knowledgeable, determined person.

I wrote this a while ago (Audit Trail) and have modified it a bit since, but I use a global variable from my login forms and pass the value to the "DB User Field". I also log the PC name and the windows log in as well

Yes, that's Bob's code. I tried linking to his website to show the file but I am getting an error. I made quite a few changes to it but the very first thing I do is look at the extension and skip the whole thing if its not an accde or mde.

The FE update code I see most people use is either Bob Larson's or a derivative thereof, like what was posted. I too had my working file deleted long ago. I started with Bob's method and combined all of it into one function/sub. I added a small If statement to mine to skip the whole update...

Does the user have 'write' permissions on the folder where trying to create the workbook? Probably not it, but I had a similar issue. Mine wouldn't create with either until I granted permission.

Try: DateChk = Format([txtDateCheck], "\#mm\/dd\/yyyy\#") varID = DLookup("ID", "tblQSI", "Service_Date = " & DateChk)

Is your form in the datasheet view set to a SQL query as a record source? I don't use that particular audit trail, but mine works in any view from the form's before_update event.

I don't think so. The only code for linking currently in any of my front-ends is initiated by manually selecting the back-end at startup when the connection check fails. I can certainly write code to check for the connection before_update. As far as applications and connections go, Access is...

Before I modified the registry and followed the instructions in the KB article I posted, the PC would not even go to sleep. If the front end was open and the user filling out the form, the connection could be lost in as little as 4 minutes. As far as the before update, I already have a...

Agreed.... I guess what was trying to show getting something other than desired. No. Yes, it is related.... http://support.microsoft.com/kb/2740020 I've also made some registry changes to prolong the timeout to the duration of the shift.

Certain times and various users, I have front-end users lose connection to the back-end. They end up with error #3043 that says: "Your network connection was interrupted. To continue, close the database and open it again." -If this is a new record when this occurs, all data entry is lost and of...

I've always used an audit trail for tracking changes of records that already exist but I have had a situation come up where I now need to track records that have been deleted. For example, if I delete a record in the datasheet view. I've seen several examples how to do this, with the most...

Sorry for resurrecting this, but I just wanted to add a couple of things. As far as I am assuming you are talking about a backend database when someone other than yourself is in it. If so, there is code out there that will kick all users off the backend and close it (I have it at home...

I've used this bit of code (below) successfully over the years. I can't seem to find it, but I also adapted it to loop and return the path to all tables, insert into a temp table, and extract the paths that way.. I'll keep looking for it... but it was for a db that had 2 access backends. I don't...