Is it possible to set a database up for data entry only? I want to set up a
front end that allows the user to access the created forms and reports but
not have access to the design wizards. I need a GUI interface that allows the
user to enter data and print reports, nothing else.

As long as you have no records in the table, a compact and repair should
reset the autonumber seed back to 1 (assuming you have the default increment
option selected in table design). In Access 2007, click on the Office Button
thingy, then click on Manage (I think), followed by Compact and repair
database.

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

"Cpl Jones" wrote:

I have a form that I enter a keyword in. I run a report which calls a query
to search for the keyword within a field. The field could have sveral
words/phases in it. If the keyword is found, the report displays the field
with the keyword. How can I highlight just the keyword in the field.
my critera in the query is - like "*" & [form]![frmSearchKeyword]![keyword]
& "*"

Thanks

The database has been in the 2007 format for about 6 months. Do regular
compact and repairs. The size has been around 160,000. Within a week it
jumped to 240,000.

Just converted from 32 bit to 64 bit. Don't see how that would have any
affect.

Have a dozen primary files and none of them have increased in size enough to
justify this big jump. The compact and repair is being done on the server,
however when I copy it to my C drive and do the compact and repair... there
is no resulting difference in size.

By the way someone left a cool suggestion about using KarenWare's Replicator
or QuikSync to back up on an hourly basis. Whoever posted this. Thanks!
This has been a worry for a long time. Any other suggestions?

It's gray and making me more gray.

2007 Linked table manager is gray.(this from right mousing on the tables).

90 %% of the ribbon in database tools is gray.

It all worked fine in 2003

heute war ein totaler Misttag,
1. fing schon morgens an--keine Milch fürn Kaffee
2. Micha nervte hat nix hinbekommen
3. habe um 22.00 Uhr gemerkt das ich 0 zu trinken hatte--Netta musste kommen

das eizigste Gute an dem heutigen Tag war das GUT durgezogene
Katzenfutteressen von ???na ich glaub Donnerstag,
war echt lecker heute, schade das ich mir nur die Hälfte habe warm machen
lassen.Lucky hat meinen Kopf immer weggeschoben--wollte auch Teller
auslecken--habe ihm aber nichts gegeben,würd er ja auch nicht machen.

Gretl hat heute Ihre neue Freundin (die graue)bis zur Haustür
mitgebracht---dann standen meine beiden
Doberkatzen da und Gretl mit Freundin über die Strasse

Despues de pegar varios botones en un formulario en Access2003 no me deja
abrir el formulario ni en modo de ejecución ni en vistab diseño y me saca el
mensaje:
Memoria insuficiente para realizar esta operación. Cierre los ...

Alguien sabe como arreglarlo sin tener que rehacer el formulario.

Garcias a todos de antemano.

Things to check
Is file trusted or in trusted location
Did it have security before moving
Do you have write access to the file
Is it an older version datafile

"barret bonden" networks-cc.com> wrote in message
news:488ced10$0$5003$607ed4bc@cv.net...