Here is the original article that describes a method to send email from Access without referencing the Outlook library, it uses the Collaboration Data Objects CDO 1.21 library...

SendObject method fails...

Back during the transition from Access 97 to 2000, there was a bug in 2000 that prevented using SendObject from sending multiple emails from VBA. At that time I found...

Vic Rauch (9/18/2008)

---

Would you be able to associated ".mdb" with that vb6 program? Then being able to click on the .mdb would run the VB6 program and open the...

The basic problem is that Access is self-registering, so the file association and the dll's are re-written to the registry every time it opens.

At one point, I had a PC...

That is a classic "corrupted Access database" message, can you compact & repair the database & then...

Interesting. I had the "Compact and Repair" problem & applied the hotfix, but it was due to Office, not XP, SP3.

Thanks.

(EDIT: it really was Office, not XP)

This is just a thought, but you mentioned multiple columns in the combo boxes. Do the # of fields match the column counts in the combos & are the column...

This is from the SQL Server 2005 Books Online (BOL):

----

You cannot use TRUNCATE TABLE on tables that:

Are referenced by a FOREIGN KEY constraint.

Participate in an indexed view.

Are published by...

Replication goes all the way back to at least Access 97, don't remember if 2.0 or 95 had it.

I agree with Karma, replication is the best choice for syncing two Access databases without writing any code.

The downsides:

Replication adds system tables & fields to your database, so the file...

No, that's not how SQL Server works.

First, you need to have the SQL Server program installed & running on a Windows server on your network. (If you don't have a...

Instead of

TRUNCATE TABLE GME_Resident_Errors

can you try

DELETE GME_Resident_Errors

maybe it's a permissions problem.

My original idea did not work, please see the edited post for the corrections...

You're starting out with two Access files: FrontEnd.mdb and BackEnd.mdb

BackEnd.mdb holds all the tables

FrontEnd.mdb has the user interface, and has links to the data in BackEnd.mdb

1. Run the SSMA on...

That is a good point. If you already have links to a back-end file, after the conversion you would have two sets of links - front-end to back-end and then...