Filemaker Admin Account Removed

I have made a pretty big boo-boo.

In an effort to rename files, I used the developer tool to create a new set of filemaker database names to preserve the relationships.

Unfortunately as it seems, months after doing so, I have discovered that the admin accounts were removed (a feature / checkbox available when creating the new file set).

Is there anyway of fixing this?  I've got tons of data entered since that time and would like to not have to recreate it.

Thanks in advance
moondowgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jvaldesCommented:
IF you didn't lock down ODBC you may be able to get to the data that way.
0
moondowgAuthor Commented:
So is there any way to recreate / restore the admin accounts?
0
jvaldesCommented:
If you have a copy of the data clone with the admin account and you can access the tables by ODBC you have a route to the fix.

Recover a backup that had admin accounts and use the ODBC drivers to bring the data in...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

moondowgAuthor Commented:
but I cant access the data files because I don't have admin access to open them...correct?  I'm having no success via this route.  There has to be a fix for this.
0
jvaldesCommented:
If you have a copy of the database before you removed admin access then you should clone it and then use it to import the tables either from the admin account if it allows or from a direct connection through ODBC. You should be able to see the data with  a data entry account.
0
webwyzsystemsCommented:
Sorry - there is no way to restore the Admin account if Developer or Advanced was used to remove it.
That's the way it should be - unfortunately, you just got burned by it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.