Lightwave
My feedback
-
314 votes
Microsoft Access Product Team
responded
Thank you for your feedback.
In terms of setting SQL Server as the default database format, that is currently not in scope for the Access product. We have provided and will continue to provide efficient methods to integrate your Access data with SQL server, and the team will continue to develop more features that streamline the data migration experience (see https://support.office.com/en-us/article/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979)
However, the ACE database engine has and will continue to be Access’s central data storage unit.
There are new features coming soon that will improve the Access: SQL experience, and we are excited to share this news. Please stay tuned! :)
An error occurred while saving the comment -
153 votes
-
1 vote
An error occurred while saving the comment Lightwave
commented
Hi John this was the same as my suggestion see
-
1 vote
An error occurred while saving the comment Lightwave
commented
You are probably right I just thought it might be easy to do.
Lightwave
shared this idea
·
-
56 votesLightwave
supported this idea
·
-
3 votesLightwave
shared this idea
·
An error occurred while saving the comment Lightwave
commented
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!
An error occurred while saving the comment Lightwave
commented
Probably should have said reports as well
-
65 votesLightwave
supported this idea
·
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 :)