Recent content by rizd999

I already had tried your first suggestion also but your other suggestions seem like good ideas on troubleshooting the issue. It wouldn't be too bad if I had to install the newer settings on each client machine as I had already implemented this cool little feature that upgrades itself when it...

What, is everyone experiencing the same thing?? Are there no recommendations or blatant things that I'm doing wrong??

For a couple of years, I've had a standard Access 97 split database over a network where the backend was on a server and the interface was installed on each client machine. Performance has never been an issue with this setup regardless of data travelling over the LAN and running it on P2-350s...

Hey JonK, You were right on!! Thanks for the excellent suggestion!! :cool:

Hello everyone, I'm trying to fill an array with all the tablenames of an Access database meeting a certain criteria (includes a certain field) in VB6 so that it can be used at a later time. Currently it's programmed as so... Dim DB as DAO.Database Dim tdfLoop as TableDef Set...

Pat, Well, I do know the 2 distinct KeyIDs of the records that are going to be compared. So based off a simple query, I was going to make 2 recordset (OriginalRS) that contained only the record(s) of the first KeyID and then (DuplicateRS) that contained only the record(s) of the second KeyID...

Really?? Oh well. I've worked with recordsets in VB before and I'm quite comfortable with that already, I just thought there might have been an easier way or less cumbersome way using some nifty SQL procedure to compare the records. Other than looping through fields in a recordset, I'm going to...

Hmmmm...I tried that. First, it only allowed me to compare 10 fields (this table has more than 10) and Second, I couldn't be specific as to which 2 records I wanted to compare. :(

I have a table with multiple fields and I need to compare 2 records with 2 different KeyIDs. For the most part, these 2 selected records should match (except for the KeyID of course) but if a field does not match with the second record's field data , I wanted it to display the difference on a...