Update Hidden tables in ACCESS database

[CC234]

I apologize if this isn't the correct forum, but if it isn't, maybe someone can direct me to a better forum.

We use contractors for certain work that requires them to load a copy of our main database onto their laptops. I have hidden the tables and queries on their copy because they don't need anything but the data entry forms and an export routine that allows them to export their current data into a spreadsheet and email it to me.

Every once in a while some new records have to be loaded into the main form on their copy, but I don't want them to have to unhide the tables that those forms are based on.

My question is can these hidden tables be written to using something like VBScript or Javascript?

I would rather send them a little script to run, rather than having to meet with them unhide the tables, enter the new locations, etc.

Thanks,
CC

 

[PWise]

What I would do is
create a new mdb with tables with the new info.

create links to the old mdb
hide all table (new and linked)
in the autoexec macro run a update/append routine to the linked table
close the new db

 

[genomon]

Why not just create a new .mde and distribute?

All I ask is a chance to prove that money can’t make me happy.

 

[CC234]

Thank you both for your replies. I'll have to give both suggestions a little more thought. I want to make it as easy as possible on their end; they're a small firm and I don't know how much IT support they have.

Thanks,

CC

 

[TheAceMan1]

How are ya CC234 . . .

Why not just hide the [blue]db window?[/blue] ... all objects are still accessible!

To show the database window:

[blue]   Docmd.SelectObject acTable, , True[/blue]

To Hide the database window:

[blue]   Docmd.SelectObject acTable, , True
   Docmd.RunCommand acCmdWindowHide[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[CC234]

Aceman,

Thanks for your reply....

I guess my main issue was to be able to update their copy of our database without having to meet with them, necessarily

I figured that by sending them a file that they could append to there database by using some sort of script it would be less of a hassle then making a new copy of the database and zipping it to them cause they've already started to create new records for the quarter in their copy.

Does that make sense?

Thanks,
CC