By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,973 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,973 IT Pros & Developers. It's quick & easy.

Attach back mdb database

P: 17
Dear All,

Urgent help needed.

I got an Access database as frontend and SQL as backend. This afternoon I tried to copy the backend to another server. Following some suggestion, I detached my database from Enterprise Manager. The problem is that I can not attach back my database anymore. The error message is "the file you'v specified is not a valid SQL database".

One more thing I noticed is that I have the following three file formats:

for a valid SQL database it should be .mdf plus .log

Can you please please help?
Nov 25 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,923
check out Tony Toew's web site. He has a wide variety of tools for the back end, the front end, etc. and the following reference troublshoots the Back End update process.

Relinking tables in Microsoft Access
Nov 26 '08 #2

Expert 5K+
P: 8,675
I'm not sure if this will actually work, but how about?
  1. Create a New Access Project using an existing SQL Database.
  2. Point the Project Front End to the moved SQL Server Database.
  3. Import all the required Objects from the *.adp which previously was functional.
Nov 26 '08 #3

P: 17
Thank you so much ADezii & Puppydogbuddy for your suggestion and link.

I have just managed to figure out my problem. The valid SQL database was stored in a "secret" different folder! Anyway, do appreciate your help.

Have a nice day.
Nov 26 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.