Statement is part of code where determining which backup file is for delete. All code works fine on 99% of PC's, but now I install MSDE 2000 and my program...

Thanks Bill, work fine.

Solution is better then my becouse I don't need function and I have all code in one place.

Thanks for suggestions.

In my analyzing the problem I found that form work fine if I delete statement Me.Requery from Form event OnOpen. I don't know what happened on that ewent...

Thanks Mike.

I searching further ....

Make a xxx.reg file and copy this record:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]

"SandBoxMode"=dword:00000002

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security]

"Level"=dword:00000001

2x click on reg file update registri entry and problem with security is solved.

Form is worked in Access 2003. Is datasheet subform on main form.

Subform contain a few record of data and user found shortcut to enter the data, just copy previous record and...

I don't know if understand you, but anyway. I use function like this to check the string for parameters:

Function Fstr(varInput as variant) as string

   Dim varTemp As String

   If Len(Trim(Nz(varInput,...

Some explanations

When user make a Paste this add new record of data but fields contain data from record where user copyed (not default values). This is problem. 

Field contain data is...

I agree with you.

I will use DAO to link tables like you, and ADO to run stored procedure.

Is much better (performance) to execute data processing on SQL server...

I define key in table on SQL site and avoid RO link tables and asking for URI (unique record identifier), to avoid dbo.TableName must specify link table name (5th parameter...

I understand ADO and DAO for using to manipulate with data. I use ADO for runing stored procedure on SQL server ....... DAO is good for manipulating with access data...

If there is anyone who interest, I found solution on:

http://www.mvps.org/access/api/api0035.htm or

http://www.lebans.com/changemdibackground.htm

I agree with both about end users and database windows.

My program always run with hidden database windov (runtime).

When program is start, user see just gray background and menu, (program is menu oriented...

Thanks Richard, I will try

Yes, the search field is indexed. On this moment I have 36000 records in table, and search on form is 35 sec long.

SQL Server is instaled on 900 Mhz...