Autorun CD used to transfer a database

.mde files are Read Only however you should be able to copy them to any desktop, and run them on any desktop with Windows Access.

You neet to set each of your original .mdb Table objects to "Read Only" and then copy the .mdb file to CD. From there it should be downloaded to user machines (with Access) or converted to an .exe file (using the Access Developer Toolkit) and downloaded to user machined without Access. Both parties get the same thing with the run-time folks running their nativeaccess database engine whilt the executable troops run the same engine transported theough the .exe file.

Hi,
Try and create a HTML document which will open automatically when the CD is inserted.
(This will work only if the user has NOT turned off Auto-Insert notification for Data CDs in his control panel->system)
Now put a link to your access filein there. If the user clicks the link, it should open in Access. The other option is to use the Windows Scripting Host and create a sort-of batch file in the windows scripting language.
For documentation on that, you can see the SCRIPT.DOC in the Windows directory.

Hope this helped you.
-Steve

on the cdrom drive open up notepad and type the following.
[Autorun]
OPEN=(File that automatically runs when cd is inserted)
ICON=(Icon that replaces the picture of the CD)

1.)Use the Windows Scripting Host and create a batch file in the windows scripting language (see SCRIPT.DOC).

2.)You neet to set each of your original .mdb Table objects to "Read Only" and then copy the .mdb file to CD.

Also, create a HTML document which will open automatically when the CD is inserted. A link to your Access file is needed. The link should point to Access.

This should solve your problem.

You can use the following method to build an Autorun file. I would use this to call a batch file on the cd that would copy the database.

How to Build an AutoRun File for a CD

Use any text editor (like NotePad) to create a file named AUTORUN.INF. The general format of this file is as follows:

[AutoRun]
Open=Setup.exe
Icon=setup.ico
Label=Drive Label
ShellExecute=Filecopy.bat
Shell\ReadMe\command=readme.exe
Shell\ReadMe=Read &Me

Any or all of these lines are optional and can be used in any combination. More than one of each line may coexist (You can run two or more programs on loading a CD).

Here are the definitions of the above lines:

Open= Must be followed by a valid executable file name, and is the file that willrun upon insertion of the CD. If the executable is not in the root directory, a path must be specified (but not a drive letter). (To run D:\Setup32\Setup.exe, type Open=Setup32\setup.exe)

Icon= Must be followed by valid icon-containing ICO, DLL, or EXE file. If the file contains more than one icon, this line must have a comma followed by the (zero-based) index number of the desired icon after the filename. The icon specified will replace the drive icon in Windows Explorer.

Label= Must be followed by ASCII text. The text specified here will replace the label of the CD drive in Windows Explorer.

ShellExecute= Should be followed by a valid data file. For example, to automatically run a batch file include the line ShellExecute=Filecopy.bat, or whatever name you choose

Shell\verb\command= Allows adding an option to the right-click menu for the CD drive in Windows Explorer. The command must be a valid executable file name.

Shell\verb\= Defines the name of the new entry. To allow a hotkey, use the ampersand (&) before the desired hotkey letter.

Note: "verb" must not contain any spaces.

Users need to have youe access 97 aplication in their c:\ or d:\ drive.
Access should be fully operant.
Just place the .mdd and any other related new queries or forms into the cd. No matter where it is an autorun cd or not, instruct your application to show a drop down combo in order to make the user choose the cd rom letter.
From that path, you access 97 aplication must read all data and even new upgraded queries and reports.

But if you want to provide a full auto cd rom application thatworks from cd rom without any instalation or requierements in the local machine, that would be a more complex.

Start by developing your current aplication in access or Vbasic or any other software. When making the auto run cd rom, keep in mind the following issues.
- Not every user have the cd rom drive under D: letter
- Force a creation of a c:\temp directory in order to make your aplication swap to disk over that path.
- Keep in mind that every database /table or file should be opened as read only.
- Do not attempt to create any temp file but in the c:\temp sub-dir
- Remember that many users may have user rights under NT systems, so forget to update the registry and any other dll in the system directory.
- One of the best methods will be: make the autorun.exe application to launch a script which first performs a silent instalation under the c:\temp sub dir, (place all files here, dll's too) and the launch your .exe file which should read data from cd rom.

Hope it helps!!

GS Technologies:

http://www.autorun-autoplay-tools.com/

provides tools to create auto-run CDs.

Maxwell

GS Technologies:

http://www.autorun-autoplay-tools.com/

provides tools to create auto-run CDs.

Maxwell