[AccessD] The future of Access, .NET and SQL

Arthur Fuller artful at rogers.com
Wed Sep 28 22:05:00 CDT 2005


Multi-choice combos <> relational constraints!
Case in point: I want to add N children to a parent, whose DetailType is
selected from a multi-choice combo.... i.e. add a Hotel, a CarRental, a
ConcertTicket, an AirportShuttle. The UI lets me do this as quickly as
possible, and background code takes care of the Parent-Child relationships.
I see no problem here. What are you seeing?


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: September 28, 2005 11:22 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] The future of Access, .NET and SQL

>> Multi-choice combo box (M-M joins)

That's the one I find scary.  Does that mean they're abandoning
relational design?

Charlotte


-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk] 
Sent: Wednesday, September 28, 2005 6:32 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] The future of Access, .NET and SQL


Hi all

OK, found something in the slides at the links from Jim.
Does anyone know if "Append only" is fixed or optional?

<snip>

ACE - Access Data Engine

- Engine based on Jet code-base and installed with Office, 100%
backwards compatible with Jet
- Connects to external data sources
- Foundation for richer support of complex data
- Multi-choice combo box (M-M joins)
- Attachments 
- Append only
- Read and write Excel "12" file formats
- SharePoint ISAM enhancements
- OM changes to DAO and ACE OLEDB provider (ADO)

</snip>

I guess OM here means Object Model.
Further:

<snip>

New ACCDB file format

- Can be emailed and stored in SharePoint document libraries
- Default for all new database
- Supports complex data features
- Multiple value lookups
- Attachments
- Append only
- SharePoint list offline
- Office file encryption not Jet encoding

</snip>

Also this summary:

<snip>

- Microsoft is committed to Access as a developer platform
- SharePoint Services integration allows developers to build new types
of collaborative applications
- Developers can build and deploy tracking templates 

</snip>

Note that an Outlook code example in the presentation uses DAO, so this
seems not to be "dead" at all.

/gustav

>>> Gustav at cactus.dk 27-09-2005 21:03 >>>
Hi Susan and Martin

Thanks!
Just wondering what this new engine should be about ...


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list