Import Form

[jserrone via AccessMonster.com]

I would like an opinion on this... I have system that allows data to be saved
each day in a MS Access Database called Test with one Table that contains the
data. I would like to create a form in a MS Access Database called IMPORT
that would allow a user to browse to the Test Database and each day
automatically import the data from the Test database table to the IMPORT
Database. I am trying to avoid users having access to the tables and
importing data from the tables of a database to the IMPORT Database table.

I would appreciate any suggestions!

 

[John W. Vinson]

I would like an opinion on this... I have system that allows data to be saved
each day in a MS Access Database called Test with one Table that contains the
data. I would like to create a form in a MS Access Database called IMPORT
that would allow a user to browse to the Test Database and each day
automatically import the data from the Test database table to the IMPORT
Database. I am trying to avoid users having access to the tables and
importing data from the tables of a database to the IMPORT Database table.

I would appreciate any suggestions!

Well... the data exists in the table, and only in the table.

It sounds like you're asking for the ability to import the data from the test
database into the Import database, without importing the data from the test
database into the Import database.

I agree with you about not opening table datasheets for the user, but a Form
can't import data; all it could do is call VBA code which would use the
TransferDatabase method to import data from a Table to another Table.

Would the user use the form to select which record or records to import? What
do you want the user to do to launch the import - click a button on the form,
or what?

John W. Vinson [MVP]

 

[jserrone via AccessMonster.com]

Hi John,

Idealy, I would like the user to click on a button and copy all records
contained in the Test Database and add them to the IMPORT database. All
records would be copied. I basically need the IMPORT database to be the
repository of all the data that will systematically be created by the Test
Database on a daily basis.

Thanks

I would like an opinion on this... I have system that allows data to be saved
each day in a MS Access Database called Test with one Table that contains the

[quoted text clipped - 5 lines]

I would appreciate any suggestions!

Well... the data exists in the table, and only in the table.

It sounds like you're asking for the ability to import the data from the test
database into the Import database, without importing the data from the test
database into the Import database.

I agree with you about not opening table datasheets for the user, but a Form
can't import data; all it could do is call VBA code which would use the
TransferDatabase method to import data from a Table to another Table.

Would the user use the form to select which record or records to import? What
do you want the user to do to launch the import - click a button on the form,
or what?

John W. Vinson [MVP]