Re: Append Filtered records to table
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Tue, 3 Jul 2007 12:35:08 -0400
"nunyez" <nunyez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:87F0DEF1-1912-4C07-B542-6D36A62E9326@xxxxxxxxxxxxxxxx
Well I am building a data dictionary in access based on the fields
contained
in our Oracle databases. So I am creating a form that compares the Oracle
vs. Access tables and having a button to import if they don't exist in the
datadictionary yet. So, three questions:
1. Do you suggest having an query query built using the queries tab on
the
DB or build the query in the VB code?
If I'm updating tables once, I usually use queries. If I'm building
something for users to use on a continuous basis, I use VBA code with an SQL
statement (instead of walking recordsets, which is much slower)
2. I can access my subform sheets .Recordset property, is that not full
already with the filtered results or do I have to build it somehow? If
needs
bult, pointing me to a reference would be appreciated.
It exists, but it is subclassed, so you need to change how you refer to it
depending upon where you are. Form inside the subform, use the same syntax
as you would use with a form, but from the main form, or from another form
use:
[Forms]![MainFormName]![SubformControlName].Form.PropertyName
[Forms]![MainFormName]![SubformControlName].Form![NameOfControlOnSubform]
Also, i'm not sure if you are familiar with access/oracle but I was trying
to have a query that used the ODBC connection to pull a query from my
oracle
so that its always up to date. I can get it to work but when incorporated
into the subform it prompts to select for the DNS connection profile about
4
times before the form displays and sometimes it will prompt in the middle
of
viewing the form and connection fails.
3. I guess my question for this is if you can tie a DNS profile to a
query
so that it won't prompt the user and make the connections behind the scene
persay?
I much prefer SQL-Server. In fact I hate working with Oracle so much so that
I've refused contracts since 1998. That said, ODBC connections with either
should be similar. With SQL-Server, I use integrated (with Windows)
security, but you can also use separate ODBC connections to link to all the
tables that you plan to use. Once doing that (at startup) you should not be
reprompted for your credentials.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
.
- Prev by Date: Re: Connecting to SQL Server via ADO
- Next by Date: Memo field formatting
- Previous by thread: Re: Creating an update using "if, then, else" conditions
- Next by thread: Memo field formatting
- Index(es):
Relevant Pages
|
