Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem with creating MDE file in Access 2003

Member
 
Join Date: Jul 2007
Posts: 32
#1: Aug 21 '07
Hello All,

I created an application using Ms Access 2000. My client has Access 2003. When I shipped him the code, this problem occured.
He took the following actions -

1. double click on mdb file
2. the startup form opens - close it
3. convert the file to Access - 2003
4. cose and re-open mdb file
5. Try to create mde file

the last step does not work. A MDB file called db1.mdb is created instead. When we double click on the db1.mdb , we get an error saying "Unrecognized database". No mde is created.

We are both using windows XP
I can create an mde successfully on my machine.
he can run the mde created by me successfully on his machine
he can run the mdb file successfully on his machine

Can someone help me solve this weird problem? Thanks in advance

Regards
Nanda

Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#2: Aug 21 '07

re: Problem with creating MDE file in Access 2003


Have him compile the code and do a compact and repair and then try again.
Member
 
Join Date: Jul 2007
Posts: 32
#3: Aug 22 '07

re: Problem with creating MDE file in Access 2003


Hello Rabbit,

I just heard back from my client. It didnt work. Can you give me any more suggestions?

Thanks for your help
Nanda
Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#4: Aug 22 '07

re: Problem with creating MDE file in Access 2003


Have them skip step 3 and 4. Maybe it's the conversion process that's screwing it up. So the code compiled just fine? It didn't highlight any problems?
Member
 
Join Date: Jul 2007
Posts: 32
#5: Aug 23 '07

re: Problem with creating MDE file in Access 2003


Hello rabbit, thanks for replying.

the code compiles just fine, no issues. Initially there was a mismatch between some references/links set in my project and his. This was not allowing the mdb to even run.
But we sorted that out and now everyteshing is working perfectly other than this mde issue.

I will ask him to bypass step 3 and 4 as u suggested and let u know what happened

Ay hlp will be appreciated.
Regards
Nanda
Reply