Search results

Hey, all! I'm using Access 2013 and trying to run a simple DELETE query on a table in another database, but because of attachment fields, the query errors out (Cannot reference a table with a multi-valued field using an IN clause that refers to another database). I would really love to keep the...

Using an audit log to point to where the changes happened was something else I was considering. I think I might take another crack at it - it might speed up the process significantly if I collect the right data.

Alright, I'm following you! I had not considered the fact that I have to do the root tables first - there goes my loop through each table idea! I'll get to work on this and probably post a new thread if (when!) I require query assistance. Thanks for the guidance, CJ!

Okay, so I will be syncing one table at a time. I just wanted to make sure the keys didn't HAVE to be unique throughout the whole db - I have quite a lot of records, so I will choose something a little less "bloaty"! Thanks once more! Tomorrow I start on the queries!

I'm sorry to be a bother, but after a day of (mostly fruitless) researching I have a question now about GUIDs - why are they so necessary for database replication? I only have at most 10 remote users entering ~300 records total - wouldn't random AutoNumbers fulfil the unique aspect? Or concacted...

As long as all conflicts: a) are resolved by the user, or b) are appended to a tblConflict in the Master before the override, that wouldn't necessarily be a problem?

Thanks for the logic, CJ - this will assist me with doing it in bite-sized chunks. And I was going to ask the GUID question so thanks for the pre-emptive answer! A couple thoughts: - I can remove users' ability to delete records (not a big deal - deletes are not really something that happens...

Alright, that makes me feel better! The remote users would only be making changes to tables, so I won't have to worry about non-table objects. I'll get to work on changing the AutoNumber to random and creating GUID/Timestamp fields for each table - do you know of any examples of the kind of...

Alright Uncle Gizmo, I'll take a stroll down that rabbit-hole! MSDN does not seem to have the article any more, but has some similar ones. I'll try to download the zip on my home computer later. Thanks!

Hello, all! I have a question about how to deal with the loss of replication in Access. I will start by mentioning that I work for the government, and am limited to using Access 2013. No extra servers and no online connections – if only! I had previously chosen to use replication because...

Okay, I've got it now - thanks for the direction, MarkK. In case anyone else is curious, I used an UPDATE statement which referenced the same table twice - I didn't realize that this was an option! Code for the interested: UPDATE tblInspection AS ti1, tblinspection AS ti2 SET ti1.Field1 =...

I do get it, I guess I just need to figure out a different syntax for the UPDATE statement. I had originally tried exactly what you had posted, and when I realized it needed to be an UPDATE statement, I didn't think I could translate the INSERT one. The statement I was using (and was being...

Quick question: because the inspection I would be on at the time would already exist in the database, can I still use an INSERT INTO statement? I thought that would add a new record into the table. Would I instead need an UPDATE statement? And would that be the same syntax?

Okay, I'll give that a try and get back to you.

Okay, first off - thanks to you two for your assistance! MarkK, the changes you made work just fine, thanks for the correction! I will burn these details into my brain. Now after looking at the tables, I’ve discovered that I was actually altering the original data, instead of a “virtual...

Hi all, I am having difficulties working though this loop problem - for some reason, I am missing a vital concept! BACKGROUND I am trying to copy certain fields from one record to another using a command button on a form. In the OnClick event, I set a SQL string as a DAO recordset and then...

Okay, for some reason I always come up with the answer shortly after posting on this forum! I've figured it out, and I used the Between function, so thanks to you, Ranman!

Thanks for relplying! I am not using a form; I'll reword for clarity. But thanks of reminding me of the between function - that's definitely going to be part of the answer. My setup looks like this: qrySiteLatestConstructDate SteKey - pk for tblSite MaxConstructionDate - Date...

Hi all! I need to create a query and I’m not 100% certain how to make it. I have a query that shows the latest construction date for a Site and a table with two types (Type = 1 and Type = 2) of reclamation criteria, and a start date and end date for each criteria. I need a query to tell me...

Thanks for the confirmation; that's basically what I have! I'm having trouble gleaning the appropriate information from Access, though - I thought that maybe my structure was incorrect. I have: tblAsset ---------- [AssetID] auto [AssetName] [AssetCost] [PurchasedBy] [PurchaseDate] [Status]...