rf44 (10/1/2012)

---

a) It took a longer time to write and format the text of the answer than to actually create both Access databases (English is not my mother language). As...

It is quite common in the Access world but I do not see any benefit in doing this.

I hear a lot of laughs when discussions about tables in a SQL...

Maybe I'm alone on this but I cringe when I see table names prefixed with 'tbl'.

IMHO, not a good practice.

Yes a DSN-less connection is an option.

It may not be the first choice that someone who is just learning Access but listed below are some links to articles on DSN-less...

Writing the code is not that hard. You may...

terry999 (9/27/2012)

---

Your point in separating the code from the data is a very good one (accde I think you called it). I also luckly had no code in Access my...

terry999 (9/26/2012)

---

Hi

I've linked Access to SQL Server via ODBC, it links to updatable views that a few selected users can use for read/write. The rest link to SQL via Access...

btw,

Before I check for the records in a table I also will have two packages and both check for the existence of a file in two separate folders.

Currently this logic...

opc.three (9/20/2012)

---

Why let the package that checks for the record exit? Just let it run. This way you would only need on SSIS package.

There are lots of options but here...

bossimal (9/25/2008)

---

Hi All,

Hungarian notation is awful and inflexible. I have attached the database naming conventions I developed for our organisation (identifying references removed) and it's worked wonders for our databases...

Yesterday morning I created an SSIS PAckage that checks for the existence of a record in a table for the current date.

If the record is found the package succeeds, else...

I remembered how to do it. That was tough. 🙂

Public Sub Main()

Dim BasisControlRowCount As...

Yeah what you are trying to do is probably more that you initially thought.

I would try and keep it simple. Start by adding list boxes one at a time on...

Your welcome, no big deal. Glad to see that you are good to go.:-)

polkadot (9/13/2012)

---

Now I would like to reattach the old 2008 databases, but there is a problem there... if you don't mind saying a few words about it I'd appreciate. ...