How to obtain values above A9999 in MS Access 97 frontend with a MySQL V5.2 backend? -


i have inherited database ms access 97 frontend mysql v5.2 backend. in mysql have table primary key field set @ varchar (50). setup because our reporting system uses alpha numeric identification. same field in linked access table set @ text. @ present, have query returns new sequential values on set value (eg) >s/1234 generate values added above table. users use these values print series sequentially numbered reports. however, have come value s/9999 , users can no longer use query obtain values > s/9999. ideas of how solve problem appreciated. thanks.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -