Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

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?
0
João serras-pereira
Asked:
João serras-pereira
  • 4
  • 2
2 Solutions
 
Gustav BrockCIOCommented:
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 BrockCIOCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now