Compact back-end front-end
Stephen,
Quote:
> Is there code to perform the reattachment of tables cleanly.
Look at solutions.mdb for sample code
Quote:
>I will also require the databases to be repaired and compacted
occasionally.
you can either create a shortcut for this, e.g. msaccess.exe <yourfile>.mdb
/compact
or create a small database to perform this task, look at compactdatabase
method in online help.
--
Best regards,
___________
Alex Dybenko
Point Limited
Home Page: http://www.geocities.com/SiliconValley/Heights/5091/
Moscow MS Access User Group
http://www.arimsoft.ru/msaccess
Quote:
> I have a front end database that has attached tables in a back-end
database.
> When I send the database out to the operator I have told him the
directories
> to unzip the two databases to. Is there code to perform the reattachment
of
> tables cleanly. I will also require the databases to be repaired and
> compacted occasionally. The databases are secured and I do not want the
> operator to have admin access to perform the tasks mentioned above
therefore
> I want a button on the screen that performs these actions (i.e.
reattachment
> of tables, repair of database and compaction of database). Is there any
code
> out there available to stop me from reinventing the wheel.
> TIA
> Stephen Yale
