Search results for query: *

In that case, you could forget about a password and make both the back & and front end MDE files. Making the back end a MDE will not prevent someone from connecting with another front end but it will keep users from casual viewing. Tom

In that case you need to put =DateValue(Now()) in the Criteria part of the date field in the query. This is assuming that the date records contain only purely date information and not date time. If the records contain date time then you will need use something like this: RealDate...

Oh, Date() won't work there. If you are trying to filter on date then you can do things like: =Now() <Now()+1 <Now()+1 and >Now()-6 If you are trying to automatically insert that date into the table then you can put =Now() in that column's defauilt value. If you want just the date without the...

If you are only concerned about is securing the contents of the back end database from prying eyes, then try this: Setup a back end database password. Re-link the front end to the back end, which will prompt you for the password. Make the front end into a MDE file and only distribute the MDE...

Thet's interesting, I link .MDE front ends to .MDA back ends without a problem. Tom

How are you using Date() in your query? Tom

I haven't done it in a while, but you should be able to kick them off of the database is on the server and you have Admin rights to the server. Tom

You also need to review your indexing scheme. And long term, you need to look at archiving your data. Tom

Why not import the contents old Excel sheet, add your new records to the imported data with a union query and then re-write the sheet? The results would be the same as if you appended your data to the historic Excel data. Tom [pc2]