Accessing <sic> External data

[Dave180]

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)

I've looked around MS and Google<spit> but can't find the answer to this one.

All responses greatfully received,
Dave.

 

[Marshall Barton]

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.

 

[Dave180]

Thanks Marshall

I undertand and agree with your comments.
Yes - I'd planned on using INI files as containers for the data. (Both the
CONStants I mentioned and the array data)

I'll read up on ADO.

Many thanks again.
Dave.