[AccessD] Create A Table

Compiler would have straightened me out, I'm sure.

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Tuesday, January 05, 2010 7:19 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Create A Table

Rocky,

The code I gave was not mecessarily meant to be water-tight.  But I
immediately see I missed a few items from the declarations section.  Sorry. 
Should include:
    Dim tdf As DAO.TableDef
    Dim rln As DAO.Relation
    Dim fld As DAO.Field

Regards
Steve

--------------------------------------------------
From: "Steve Schapel" <miscellany at mvps.org>
Sent: Wednesday, January 06, 2010 4:12 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Create A Table

> Rocky,
>
> I would make the table temporarily in the Frontend file.  Then your 
> code can export this table to the backend, and delete it from the 
> frontend.  Some sample "air" code:
>
> ' ----------------
>    Dim dbsBE As DAO.Database
>    Dim dbs as DAO.Database
>    Dim BEPath As String
>    Dim AlreadyLinked As Boolean
>    Dim AlreadyInBE As Boolean
>
 

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