How to save Access file linked to SQL Server (1 Viewer)

[eugzl]

Hi All.
I connected Access 365 to SQL Server 2016. What extension I need to select to save Access DB file: .accdb or .mdb? Why I didn't see option to save Access as project with .adp extension?

Thanks

 

[sonic8]

If you connected the Access file to SQL Server already, the file was created and your question has answered itself. ;-)

You can still create .mdb files. Choose that file extension while creating the new Access file. - But you should only do so if you have a good reason for it.
The default is the .accdb file format and there is little reason not to use it.

ADP projects are history. They are not supported in current versions of Access anymore.

 

[eugzl]

Hi sonic8. Thanks for replay.
I did my last Access project long time ago. That why when I connected to SQL Server and tried to save I didn't see extension that I used earlier.
Thank you.