If this could be done without losing the single file based database approach fine if not this would be a dangerous and very destructive move in my opinion. Having a single file that is directory agnostic and completely transportable is a real competitive advantage that provides something that web databases/professional database engines don't and can't provide - Its what make MS Access MS Access. It would be a really dumb thing to get rid of that and move to all the hassle of a scratch pad riddled with dependencies. By the same logic you could argue that you should get rid of notepad in favour of word. Get rid of BMX's in favour of mountain bikes and I should probably have either a steel strung guitar or a Spanish guitar but not both.
Single file based approach would require Ace being incorporated into SQL Server mdf format! Hell will freeze over before Microsoft do this :)
Hi John this was the same as my suggestion see
You are probably right I just thought it might be easy to do.
I would have a feature that would allow the number to be displayed on forms as well - I place labels on my forms
F001 / F002 / F003 / F004 - this is really useful for documentation and any sort of communication help.
Please user can you tell me which form you are having trouble with - I'm having trouble on F005 with field X002.
Advanced feature I know but its pretty good!
Probably should have said reports as well