using access 2007

[Roy Goldhammer]

Hello there

On new computer I had to transfer to access 2007.

What is this thing?
Where can I find my old menu bar? or menubars i've created for my project?
whay anything who works at access 2003 is shuttind down the access?
how can i reach to all tools menu or other issues was in access 2003?

 

[Allen Browne]

Welcome to the wild world of ribbons.

Most of the options are under the Office Button (top left corner).
Then click Access Options (bottom of dialog.)

Here's something to get you started:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

Hopefully Service Pack 1 will be out in the near future, and they that they
have fixed the worst of the bugs.

 

[Roy Goldhammer]

Whell Allen

Thanks about this document.

But my old application was written on ADP which is not supported by Access
2007. (Realy bad)

The reason I choosed ADP for my application was made do support SQL server
databases with bigint variable (which is exist on any part of SQL server
database and MDB does not support them) does the new MDB support using
BIGINT?

 

[Allen Browne]

You can attach a SQL Server table (as an attached table in an MDB), and JET
will recognise the BigInt field.

In DAO code, dbBigInt is a constant with the value 16 (decimal.)
The various field type names are listed in this function:
http://allenbrowne.com/func-06.html

Using MDB instead of ADP has other advantages too, such as being able to
create local temp tables.