Re: Accessing <sic> External data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dave180 wrote:

Access 2003

I need to save data from an Access APP with no TABLES
====================================

Is that possible?
------------------
I've an App that has NO tables and NO queries
(I'd have written it in VB - but I don't have a copy of VB that works under
VISTA)

I have a "Master" form which contains a "subform" form.

The App runs nicely based on the 10x10 'pseudo' control-array of the 100
controls on the subform form.
(Pseudo: The 100 controls are Command Buttons -
I can address a SubForm!Control by NAME or convert it's name to a
strReference and handle any values in the returned string)

The values of the subform's controls TAG need to be saved / loaded.
(The APPlication is currently testing the SubForms.Controls.TAG
Using CAPTION for instance would make the value visible)

The MASTER Form and the rest of the APP looks at CONstants - which I'd like
to save and remove from the APP itself - but that may be a 2nd-array
question!.

To SAVE the values on the APP -
I presumed <very sloppy thinking?> that I could write the
subform!REFERENCE.Tag (for each Control in it's array) to a new recordset and
then READ/WRITE that to an INI file.
I'm struggling to create a recordset here (when one doesn't exist!)

I really; really; really: would rather have done this in VB but there you go!

1. Should I give up on the no Tables theory?
2. I'd like to CREATE a DATASET based on no TABLES !!!
3. Can I save the .TAG values to an OP file?

If this were still reasonable how best to export(SAVE) / Import(LOAD) the
data either from the MASTER Form or the SUBFORM(Array)


It would be a very unusual situation where not using a table
to save data is the right way to go. After all, Access is a
database kind of system so tables are the natural place to
put data.

If you were doing this in VB6, where would you put the data?
Certainly not in your VB app's exe file! Putting it in an
Access form or control's properties makes no more sense than
putting it in the app's exe file.

If your proposed VB6 program would save it to a .TXT, .CSV
or .INI file, then you can do the exact same thing in
Access. I suspect that your "dataset" would be an array
instead of a recordset, but if you really need to use a
recordset, then do some homework on the ADO library's
Disconeccted Recordsets.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Access 2007 - Anyone having trouble with really large conversions?
    ... I have a fairly large app, ... program, which has added even more forms, queries and linked tables. ... get errors when opening a recordset for a linked table. ... So Access 2007 always seems to use Recordset2 objects for its forms and reports ...
    (comp.databases.ms-access)
  • Re: Using Access with MySQL and Stored Procedures as source to Forms and Reports
    ... and retrieval in sprocs / views. ... app with code. ... If I were to use a BE server for a web based application than I would ... recordset I use code to modify it. ...
    (comp.databases.ms-access)
  • Re: Datareader, dataset, else?
    ... A DataReader is most closely analogous to a Read-Only/Forward-Only Recordset ... > I'm writing my first real asp.net app at my job, ... > seems like I have to choose between using a SQldatareader or a dataset. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Application crashes with "On Error Resume Next"
    ... The code is intended to move data from one recordset to another - ... however the "ChangedCarveOuts" recordset is built using a stored proc ... Next is then to allow the app to skip any potential 3065 (Item cannot ... ran the app on a machine at the client site that uses MDAC ...
    (microsoft.public.vb.bugs)
  • Accessing External data
    ... I need to save data from an Access APP with no TABLES ... The values of the subform's controls TAG need to be saved / loaded. ... The MASTER Form and the rest of the APP looks at CONstants - which I'd like ...
    (microsoft.public.access.modulesdaovba)