I am working on a simple demo to showcase integration between a
proprietary system and a DBMS using Access 2003 and have stumbled into a
roadblock. Much to my surprise, Access doesn't seem to support 8 byte
integers whereas the tables of the backend system make heavy use of it.

Is this data type supported in Access 2007?

Also, is there any way to extend Access SQL through user-defined
functions? Say, I have a simple function (in the sense that it keeps no
state between calls) with a signature like:

int f(int x)

Is there a mechanism I can use it in a query, as in the following

select myintcolumn, f(myintcolumn)
from mytable

If the answers to the above questions are negative, what other utilities
would you recommend?

I'm not sure of how you'd be able to get around the 8 byte integer problem.
I don't believe it's any different in Access 2007.

Depending on where you're calling the query, you can define a public
function in a module (not a class module nor a module associated with a
form) and use it as you've illustrated. That will work if you're calling the
query from inside of Access. You won't be able to use the query from outside
of Access though.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"somebody" <somebody@somewhere> wrote in message
news:(E-Mail Removed)...
>I am working on a simple demo to showcase integration between a proprietary
>system and a DBMS using Access 2003 and have stumbled into a roadblock.
>Much to my surprise, Access doesn't seem to support 8 byte integers whereas
>the tables of the backend system make heavy use of it.
>
> Is this data type supported in Access 2007?
>
> Also, is there any way to extend Access SQL through user-defined
> functions? Say, I have a simple function (in the sense that it keeps no
> state between calls) with a signature like:
>
> int f(int x)
>
> Is there a mechanism I can use it in a query, as in the following
>
> select myintcolumn, f(myintcolumn)
> from mytable
>
> If the answers to the above questions are negative, what other utilities
> would you recommend?
>