CODEWITHSUNDEEP
sqlsql-serverms-access
green coder
green coder

Reputation: 55

Cannot open Microsoft Access table

I am a beginner in Microsoft Access and one of my friend gave me a copy of his SQL Server file and something with .BAK extension which I believe is the database as it is almost 300MB.

When I try to run the SQL Server file I get cannot connect to backend database error. Searching on the internet I found that I can prevent this by holding shift while opening the database.

Even though this does open the Access file, where I can see all the table,queries, forms, reports and macros icons and names. I cannot open any of them. When I press on one of the table names for example I get

Connection Failed SQL server does not exist or access denied' error.

How do I view the tables?

Upvotes: 0

Views: 144

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19235

Your MS Access file is linked to a SQL Server. You basically need to

  1. Install SQL Server Express (it's free) https://www.microsoft.com/en-au/sql-server/sql-server-editions-express
  2. Restore the .BAK file into SQL Server Express How to import a bak file into SQL Server Express
  3. Relink all of the MS Access linked tables to your installed SQL Server How does one change the connection string of linked tables in MS Access

This may seem complicated but it is a great opportunity to learn about databases.

Seems your friend is not very helpful.

Upvotes: 2

Related Questions