Startup and linked table and mde question

V

Veli Izzet

Hi all,

I have a mdb database that has one table, and one form.

The database holds daily currency conversions, so somebody fills it in
daily, and this data is used by linking this table to other databases.

1- I could not split this little database, splitting is grayed out?

2- When the user to input data to that database clicks on tha database,
access opens, asks for permission saying that the database may contain
harmful whatever, and in the background the access main menus are seen.

There are lots of mouse clicks, and also the background with access menus.

I would like to have the data input form on the desktop (preferably at
the same place everytime), just by itself by one click, input the data
and close the form.

How do I do that?

Thanks for answers
 
A

Albert D.Kallal

Veli Izzet said:
Hi all,

I have a mdb database that has one table, and one form.

The database holds daily currency conversions, so somebody fills it in
daily, and this data is used by linking this table to other databases.

1- I could not split this little database, splitting is grayed out?
Click to expand...

This likely means that the file is already a mde. You can't split a mde (a
mde is what you are supposed to distribute AFTER you split!).

This means you must find the ORIGINAL mdb and split that. (note that you
will then need to link this new mdb to the above mde).

If the database in question is not a mde, then perhaps security, or some
reason exists.

2- When the user to input data to that database clicks on tha database,
access opens, asks for permission saying that the database may contain
harmful whatever, and in the background the access main menus are seen.
Click to expand...

Just go tools->macros->security, and set it to low. All nags will go away.
I would like to have the data input form on the desktop (preferably at the
same place everytime), just by itself by one click, input the data and
close the form.

How do I do that?
Click to expand...

You can set what form loads in the tools->startup setting.

And, you can also use the startup settings to hide all of the ms-access
stuff also..and *just* show the form.

Another neat and un-know way to create a shortcut is while looking at the
forms tab in the mde, or mdb, right click the form you want, and then choose
shortcut. You can place that shortcut on your desktop. However, use the
tools->startup options....
 
V

Veli Izzet

Thanks for everything,

as for item 1: It is not an mde, and I have other databases that I can
split and make mde on the same pc. Funny thing.
 
Top