autonumber problem

[jdraw]

Is there an option that it could be done from Access itself? around every 15 minutes or 30 minutes? This way it could be done automaticly.

If this is critical to your application, then do as has been suggested-Move your backend to a server based dbms that has built in transaction processing. Why try to build your own when other systems have that built in, and you can still use your Access front end.

 

[megatronixs]

Hi all,

Thanks for the tips. We will move our database soon to Oracle and use access as a front-end to be able to add still functionality in an easier way, but till then, I still need to have a backup to avoid any lose of work.

Greetings.

 

[RainLover]

If this is critical to your application, then do as has been suggested-Move your backend to a server based dbms that has built in transaction processing. Why try to build your own when other systems have that built in, and you can still use your Access front end.

Also have you tested the Backup I posted.