Search results

hi i have this table MEN Name ____ aaa bbb nnn aaa aaa nnn i need to erase all duplicate rows (but leave only the first) Name ____ aaa bbb nnn i need any query that do it

I have an Access 2007 database file that should be used by two programs simultaneously. Program 1 should insert and update the table; Program 2 should only run queries to show the data. The problem is, when program 2 opens the file - program 1 cannot insert or update rows. What can I do?

hi i have access file and when i try to open i got this error: You do not have the necessary permissions for this object XX... Ask the administrator or user who created this object to create the appropriate permissions for you is there any way to open it ? or any tool for this ? thank's in advance

thank's for the help

hi is there any tool or add-on for write color and comfortable query on access-2007 ? thank's in advance

hi if my computer region set to dd/MM/yyyy hh:mm and my query in access: select * from MyTbl where MyDate between #25/12/2010 10:51# and #30/12/2010 12:11# is this query will work on computer that his region set to MM/dd/yyyy hh:mm ? if no, how to fix it without change the region in the...