Creating an adventure game in Access

[Shryce]

Hi, I'm constructing my own adventure game in Access but I've ran into a few problems creating the structure. Can anyone please help me on these issues ?

1. Does anyone know what is the maximum number of forms an access database can contain ? (Office 2000)

2. Does anyone know what is the maximum size of an access database ?
Is it possible to create databases larger than 200 MB ?

3. What picture-format should I use to import the highest possible quality pictures (max 1 million pixels) into an Access Database form ?
(I want to store it with the lowest possible size (in kb's) and still be able to use it in Access)

Thanks for any help you can give on these issues.
Peter

 

[cable]

3: don't is the simple answer, images do not work in databases. store the path to the image instead. The highest quality is uncompressed, and the most common uncompressed format that will be easiest to work with in access would be .bmp!

 

[Mile-O]

What sort of adventure game?

A graphic adventure (like Monkey Island)
A point and click one (like Myst)
A text adventure (like the old Infocom games)

 

[ColinEssex]

Writing an Access database is an adventure game

Col

 

[Mile-O]

2. Does anyone know what is the maximum size of an access database ? Is it possible to create databases larger than 200 MB?

2 Gb



Also, why reinvent the wheel. Ambrosine lists a number of adventure (and other) game creation tools. Using these (such as Adventure Game Studio or AGAST to compile will mean that potential players won't need to have Access installed to play.)

 

[Shryce]

Some clarification on the earlier questions

1. Does anyone know what is the maximum number of forms an access database can contain ? (Office 2000)

Haven't found it yet, does anyone know ?

2. Does anyone know what is the maximum size of an access database ?
Is it possible to create databases larger than 200 MB ?

2 GB, okay, but if I exceed 200 Mb I get an error message telling Acces can no longer find the required database/libraries.. Does this sound familiar to anyone ? Do you have a solution ?

3. What picture-format should I use to import the highest possible quality pictures (max 1 million pixels) into an Access Database form ?
(I want to store it with the lowest possible size (in kb's) and still be able to use it in Access)

How do you link pictures in a form (what option do I use) using a path-link.

If I do decide to import pictures, bitmap works, but is very large in size, is there a smaller possible format and how best to import or copy them into this then. (jpegs get inflated to even larger sizes) ...

 

[Pat Hartman]

1 & 2 Believe it or not, Access comes with a built in help feature. If you were to look up limits or specifications you would find your answers.

How do you link pictures in a form (what option do I use) using a path-link.

- if you were to add an image to a form and look at some of its properties, you would see the answer to this question.

If I do decide to import pictures

- you were advised to link to images because of the bloat caused when you embed them. Perhaps A2003 has solved that problem. If you are using an older version, try A2003. Otherwise, take the advice you were given.