Question about app extension

[itmasterw]

Hi,

Actually I have two questions on the same thing.
1) I just took a 2003 application and moved to 2010. it is working great, however, I kept it as an .mdb file. Should I have changed it to a .accdb file, and if so how do I do that safely?

2) Then I am putting this on a server for multiple people to access at once. So I know that I have to split it, to front end and back end. So for this I am also asking if I have to make it an .accdb extension?

Thank you

 

[isladogs]

1. Yes - assuming all users have Access 207 or later
To convert using Access 2010, go to File menu, Save And Publish, Save Database As, Access Database (accdb) then click Save As & give it a suitable name
Other versions of Access have slightly different methods but the idea is the same

Your original mdb file is still there in case you need it.

2. The backend doesn't have to be .accdb as Access can link to various external file types but I would recommend that it is.
NOTE: However mdb frontends can't link to accdb backends

 

[itmasterw]

Thanks that is a real help.