Newsgroup: it.comp.appl.access
Titolo: Usare Access 2003 come runtime

Vorrei usare Access come se fosse il runtime, disattivando ogni possibilità 
di modificare la struttura del db
C'è una opzione non documentata o qualcosa che posso impostare all'apertura 
del file?
Ecco le opzioni di MS Access 2003 (scusate le formattazione, ho fatto 
copia/incolla)
========================================================
The following table lists the Microsoft Access command-line options.
      Option Effect
      database  Opens the specified Microsoft Access database (database: A 
collection of data related to a particular subject or purpose. Within a 
database, information about a particular entity, such as an employee or 
order, is categorized into tables, records, and fields.) or Microsoft Access 
project (Microsoft Access project: An Access file that connects to a 
Microsoft SQL Server database and is used to create client/server 
applications. A project file doesn't contain any data or 
data-definition-based objects such as tables and views.). Include a path if 
necessary.
      /excl Opens the specified Access database for exclusive (exclusive: A 
type of access to data in a database that is shared over a network. When you 
open a database in exclusive mode, you prevent others from opening the 
database.) access. To open the database for shared access in a multiuser 
(multiuser (shared) database: A database that permits more than one user to 
access and modify the same set of data at the same time.) environment, omit 
this option. Applies to Access databases only.
      /ro Opens the specified Access database or Access project for 
read-only access.
      /user user name Starts Access by using the specified user name. 
Applies to Access databases only.
      /pwd password Starts Access by using the specified password. Applies 
to Access databases only.
      /profile user profile Starts Access by using the options in the 
specified user profile instead of the standard Windows Registry settings 
created when you installed Microsoft Access. This replaces the /ini option 
used in versions of Microsoft Access prior to Access 97 to specify an 
initialization file.
      /compact target database or target Access project Compacts and repairs 
the Access database, or compacts the Access project that was specified 
before the /compact option, and then closes Access. If you omit a target 
file name following the /compact option, the file is compacted to the 
original name and folder. To compact to a different name, specify a target 
file. If you don't include a path in target database or target Access 
project, the target file is created in your My Documents folder by default.
      In an Access project, this option compacts the Access project (.adp) 
file but not the Microsoft SQL Server database.
      /repair Repairs the Access database that was specified before the 
/repair option, and then closes Microsoft Access. In Microsoft Access 2000 
or later, compact and repair functionality is combined under /compact. The 
/repair option is supported for backward compatibility.
      /convert target database Converts a previous-version Access database 
or Access project to Access 2000 file format, renames the new file, and then 
closes Access. You must specify the source database before you use the 
/convert option.
      /x macro Starts Access and runs the specified macro. Another way to 
run a macro when you open a database is to use an AutoExec macro.
      Caution  Macros can contain viruses, so you must be careful about 
running them. Take the following precautions: run up-to-date antivirus 
software on your computer; set your macro security level to high; use 
digital signatures; maintain a list of trusted sources of macros.
      /cmd Specifies that what follows on the command line is the value that 
will be returned by the Command function. This option must be the last 
option on the command line. You can use a semicolon (;) as an alternative to 
/cmd.
      Use this option to specify a command-line argument that can be used in 
Visual Basic (Microsoft Visual Basic: A high-level, visual-programming 
version of Basic. Visual Basic was developed by Microsoft for building 
Windows-based applications.) code.
      /nostartup Starts Access without displaying the task pane (task pane: 
A window within an Office application that provides commonly used commands. 
Its location and small size allow you to use these commands while still 
working on your files.) (the second dialog box that you see when you start 
Access).
      /wrkgrp workgroup
      information file Starts Access by using the specified workgroup 
information file. Applies to Access databases only.
========================================================
-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\ 

 all'apertura del file?
Convertilo in MDE
Semplicissimo
MAssimiliano 


Ciao Ammamata,
l'opzione /runtime dovrebbe essere quella che fa al caso tuo, simula in
tutto e per tutto l'ambiente runtime...
Cinzia


perfetta, grazie; c'è in giro qualche sito che elenca le opzioni NON 
documentate di Access?



tentato ma non riuscito, errore di troppi 'qualchecosa':
This error is usually associated with compiling a large database into an MDE 
file.  Due to the method used to compile the database, a considerable number 
of TableID references are created for each table.  The Microsoft Jet 
database engine version 4.0 can only create a maximum of 2048 open TableIDs 
at one time.  Exporting a database as an MDE potentially can exceed this 
limit if the database has a large number of objects (table, macro, form, 
report, etc).
There is no accurate method to estimate the number of TableIDs the Jet 
database engine uses during the process of compiling a database as an MDE. 
However, each VBA module and each form uses one TableID, as a result, if the 
database has 500 forms, and each form's HasModule property is set to Yes, as 
many as 1,000 TableIDs are used.
grazie lo stesso; ho messo lo switch (non documentato) /runtime


 ha scritto nel messaggio
news:38mobbF...@individual.net...

Ciao Ammammata,
a memoria direi che l'avevo trovata su MSDN.
Saluti
Cinzia