Recent content by wjtuk

Hi I have a database that has 150 users all with there own front end on a laptop, because they need to use it offline they 'upload' to a core database when they connect to the network once a week. I have an issue that when i compact & repair the 'core' database, the individual front ends...

Ok thanks for your help. I have decided to ignore the autonumber and generate my own by a max as you have mentioned. Thanks for your help.

Thanks for your response. I need to reset the autonumber of the table to a result in a query. For example if the query has a result of 25 in the Bus_Ref column i need to reset the autonumber too that. Thanks again for your help.

Hi I find this site really useful for any of my access queries but i have one here that i can not find a solution for as i know vey little sql. I did not build the database but need to get a fix in for my problem. I have a unique reference in five tables which is generated off the...