how to open a bak file in access

help

i have a database backup and its a *.bak file and i need to open it and opening it wiht access anybody know a file converter software???
xcsvxAsked:
Who is Participating?
 
David ToddSenior DBACommented:
Hi,

What you need to determine is what created the bak file and how.

If it is an OS copy of an access database then there isn't any point in trying to restore it to MS Sql.

Best Bet: It is a SQL database backup, and to "Open It" you need SQL to restore it to a database, and then use an application like SQl Query Analyser or SQL Server Management Studio to access the database. If I'm right with my guess, you can not just open this file in an application ...

HTH
  David
0
 
jerryb30Commented:
Have you tried restoring it OS backup software?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
maybe change .bak to .mdb ?

mx
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
WizillingCommented:
has the .bak file been made from a sql server backup Tool.. Then the only way u can do is to restore and database files to your sql server and use the Export/Import Tool provided by SQL Server to trasfer the data and table structures to Access..
0
 
xcsvxAuthor Commented:
yes its a backup of and sql databse
0
 
xcsvxAuthor Commented:
the BAK file was created from a backup of my SQL server. is there a way to back it up as mdb file so i can open it in access
0
 
WizillingCommented:
If its a My Sql database (or any other database for that matter) can only be backed up in its own foramt and used by that same program. (I am not sure if u using MySQL or MsSQL)
To use ur Sql database, you need to export the database to MSAcess.
In MSSQL there us a utility that does the export and imports to MS Access database
Right Click on your database and select Tasks and select Export database
in the source select your sql server.
in the destination select MS Access and give a destination file name .
select your tables and objects and click finsh
0
 
David ToddSenior DBACommented:
Hi,

What you need to grasp is that database files - the main data files and their transaction log files, and the backup files - are not just documents that can be shared around like word processing files or spreadsheet files.

SQL and Access do have mechanisms for interconnecting and transferring data, or can export to common file formats such as fixed width text or comman delimited, and import from the same.

HTH
  David
0
 
xcsvxAuthor Commented:
ok now i was able to convert the database to a mdf file so how can i open it now with access
0
 
WizillingCommented:
Double clicking the mdf file should open it up.

or start MS Access and open your file.. FILE- > Open Existing Database
0
 
David ToddSenior DBACommented:
Hi,

>> ... i was able to convert the database to a mdf file ... <<

Can you describe how?

That was not what any expert recommended you do.

Regards
  David
0
 
jerryb30Commented:
mdf = SQL Server.
0
 
David ToddSenior DBACommented:
Hi,

Sorry, I missed this

>> In MSSQL there us a utility that does the export and imports to MS Access database

Regards
  David
0
 
WizillingCommented:
>> Double clicking the mdf file should open it up.

I meant to write.. Double Click the mdb file to open it in MS Access

thanks jerryb30
0
 
xcsvxAuthor Commented:
ok all i dont know who to give out the reward but here  was i did i created a new access db and import data  and connected to my sql server and  connected to the database and was able to pull all the table from that database.
0
 
David ToddSenior DBACommented:
Hi xcsvx,

Among your options are to split the points. Select the comments that served you best, and then apply a portion of the question points to each comment selected.

Regards
  David
0
 
David ToddSenior DBACommented:
Hi,

I'd suggest a points split between experts, say 300pts Wizilling and 150pts jerryb30 and 150pts dtodd.

Reason: At the end of the day, more Wizilling than jerry and me, did achieve a result for xcsvx. That has got to be worth something ...

Regards
  David
0
 
WizillingCommented:
I agree that there should be a points split between the experts that assisted the asker.

Thanks dtodd but think the points should be split equally among Jerryb30, dtodd and Wizilling (160 points each) and a few remaining points to be given to DatabaseMX (ie 20 points)
0
 
mbizupCommented:
In general if an author posts an independant solution, the recommendation per EE's guidelines is PAQ/Refund.  

Re-reading this, I agree that a workable solution was arrived at before the author posted the independant solution.  I disagree with the suggested point splits however.  This was basically a two-part solution (restore through SQL Server then export to Access).  As such, I recommend the following split to pinpoint answers that should have directly lead to solving this.

Revised recommendation:
Split: dtodd {http:#19658444} & Wizilling {http:#19665654}

mbizup
EE Cleanup Volunteer

0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
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.

All Courses

From novice to tech pro — start learning today.