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...
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]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.