Back End Database Connection

[Kevin]

I have a Front-End/Back-End database application where the
Frontend is a .mde file and the backend is a .mdb file.
The backend has only tables and is difficult for the
enduser to find on the network drive where the BE is
located so I really don't need to convert it to a .mde.
For well over a year I have had the application in this
configuration. Recently I had mad a number of
modifications to the application and was attempting to
create a new .mde FE file and got an error indicating that
mde files can only connect to .mde files and not .mdb
files??? I am confused here because this is the first time
this has ever come up. I have had this application (and
others) in this same configuration?? I suspect some sort
of corruption, but I wanted to check with the experts to
see if there are any known conditions which might cause
this.

Thanks!

Kevin

 

[Tony Toews]

I have a Front-End/Back-End database application where the
Frontend is a .mde file and the backend is a .mdb file.
The backend has only tables and is difficult for the
enduser to find on the network drive where the BE is
located so I really don't need to convert it to a .mde.
For well over a year I have had the application in this
configuration. Recently I had mad a number of
modifications to the application and was attempting to
create a new .mde FE file and got an error indicating that
mde files can only connect to .mde files and not .mdb
files???

This doesn't sound at all right. Could you post the exact text of
the error message.

Was your message the following?
ACC2000: Error Message: Error Accessing File. Network Connection May
Have Been Lost. (Q304548)
http://support.microsoft.com/default.aspx?scid=kb;EN-CA;q304548

If so your FE MDB is corrupt and you will have to restore from backup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Kevin]

Tony,

At this point I am not sure what the message text was. I
created a new database from scratch and imported all
forms, modules, macros, queries and forms into the new
database. This corrected the problem. When the error began
to occur, I was in one of the form modules and lost our
network. This subsequently (when I attempted to execute
code I was working on) cause an access GPF which crashed
the application. I figure when that happen, something got
corrupted.

Thanks for the help!

Kevin