Thank you Kingston and Drew,

you are right in SQL Server there are datetime data types with functions designed for this kind if data. yyyymmdd as int would not make...

What about storing data as int like this yyyymmdd? (year*10000 + month*100 + day)

The pros are:

the numerical order is the same as calendar...

Good question, well done!

as Kingston wrote earlier, per BOL looks like there are a few more restrictions on truncate,

You cannot use TRUNCATE TABLE on tables that:

* Are referenced...

Thank you Alvin, your remark together with the link from wildt about

Populating a Kimball Date Dimension

are what I am looking for.

Very nice article Alex, thank you.

Indeed IsBusinessDate 'Y' or 'N' is great for building an understanding of the concepts, I remember when I implemented this functionality using something similar;...

Very useful and inspiring.

Thank you very much Drew and Chris.

Have a nice day,

Iulian

Hello,

Where is the schema stored now?

Can you provide a sample of the functionality you need?

Iulian

I use a graphical query builder,

Access has one, try it.

Or if you us SQL Server as back-end create your query with Query Analyzer and then paste it in Access.

This...

Alicea,

try to create a timestamp field in that table. I used this and it worked.

Good luck!

TRY THIS:

ensure the ODBC connection time-out is sufficiently long.

ODBC settings are managed through the system registry and must be configured when Access or any other clients using Jet are...

generate sql script for that table and archive it

also archive the access database and send them to

ciuli7ro@yahoo.com

I will try to rebuild them and see if I have the...