Re: Excel front-end and Access back-end?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Been linking to Interbase, MS SQL Server, SQLite, Access, Excel and text files all in the same .xla.
So, no need to worry about being snobby with mentioning linking to DB2 ...

RBS


"Jim Thomlinson" <James_Thomlinson@xxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0445DC9D-C9A7-4AC5-B466-8C61CEBC0B50@xxxxxxxxxxxxxxxx
I've been linking to DB2 also but I didn't want to appear too snobby ;-)
--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:


"Jim Thomlinson" <James_Thomlinson@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9BB53B29-639C-43C1-AC20-4DEA8EB390EF@xxxxxxxxxxxxxxxx

> To Bob's point however I only use Access as the data layer. The > business
> logic and user interface are done in XL. All of the queries are in XL
> also.
> That being said I have created multiple front ends for a single Access
> back
> end and even done some reporting and querieng directly within Access
> (using a
> Access Frond end Database)...

Same here, but with a real database (cue Access aficionados jumoping on me)
such as SQL Server, Sybase, etc. I have coded triggers and constraints that
do some of the validation work.





.

Relevant Pages

  • Linking Tables in CR8.5 - DB2 to SQL Server
    ... Hi, I'm trying to link two tables together in a report, one from a DB2 ... database and one from SQL Server. ... table - the DB2 field is a character field length 5 and the SQL Server ... I've linked the tables via Crystal's Visual Linking Expert, ...
    (microsoft.public.vb.crystal)
  • Re: Unable to edit records
    ... When you edit the old records (before linking the table in MS Access from ... Sql server 2005) it shows write conflict error. ... what are the fields and DataTypes of the fields and what is the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: linking to an .mde file from .adp
    ... Also, note that unless you have specifically enabled that feature, ... tried linking using an .adp file. ... I tried linking via a linked SQL Server and and DNS. ...
    (microsoft.public.access.externaldata)
  • Re: Banned site linking to our site.
    ... Don't worry about getting the link removed. ... what you really must worry about is making sure you are not linking ... double penalty - you are linking to a site with a link farm and you are ... Most of my google alerts are from spam/scraper sites like that. ...
    (alt.internet.search-engines)
  • Re: save ~50,000 record table sorted from one million record table
    ... ?Access/Jet, SQL Server, Oracle, ... text-file, ...? ... Are you linking to the table from within ...
    (microsoft.public.access.tablesdbdesign)