ensuring that ms/access 2013 split database format is accdb

I am splitting a database and the only format it shows for the back end is .accdc (signed package). On the split browser it does not allow for .accdb. I am getting a massive load of problems with this small application and I do not want this  security issues, getting certificates, etc. How can I split the database without having it enforced to a signed package? Must I used the .mdb forma in the original database?
João serras-pereiraAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
That's interesting. I ran the wizard, and you are right. Don't know how to handle that.

One option:

Make two copies of the current database. In the first, remove all objects except the tables, in the other remove all tables, then attach all tables from the first copy.
If you haven't done anything fancy, that's all there is in it.

/gustav
0
 
Gustav BrockConnect With a Mentor CIOCommented:
Another option is to run wizard and let it create the accdc file.

Close the application, rename the accdc file to accdb. Then open the application, go to "External Data" and run the second item "Manage attached tables", select all, and point to the accdb file. Click OK and you are done.

/gustav
0
 
João serras-pereiraAuthor Commented:
Ok! I'll do it. My problem is that I want to continue development on the database and try to learn  how to manage security is too complicated in this stage and for the actual application...
will let you know!
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Gustav BrockCIOCommented:
Yes, I refrain from the security options, and I think you can safely do as well.

If one really has those security concerns, Access may not be the right tool at all.

/gustav
0
 
João serras-pereiraAuthor Commented:
Thanks!!! It worked fine!
0
 
Gustav BrockCIOCommented:
Great. I'll make a note on that.

/gustav
0
All Courses

From novice to tech pro — start learning today.