Importing ODBC Data into Access 2000 DB (Split Database) 1

[Phooey]

Does anybody have any ideas on why things work when developed as a .MDB file, but don't when converted to an .MDE even when the code hasn't been changed?<br><br>Better still, does anybody have any suggestions on why, when the above has been fixed, does the code not work when the .MDE has been split.<br><br>I'm having serious problem importing data from an external ODBC source into an Access database.&nbsp;&nbsp;The code works without a problem on the local drive as a .MDB when accessing the external ODBC source on the network.<br>Convert the .MDB into a .MDE and, as if by magic, problems appear. I've fixed those errors an it runs fine, until the database is split!.<br><br>I've checked all of the ODBC part and the connection is sound.&nbsp;&nbsp;The problems appear to be part of access and I'm tearing my hair out.!<br><br>Please help somebody.

 

[DougP]

Not sure a follow all that.<br>Are you saying when you create a Backend (_BE) then the .mde does not work anymore.<br>Create if so then create the Backend (Use database splitter) in the .MDB and then create a new .MDE.<br>It works great that way I do it all the time.<br><br>Don't split the database after its a .MDE<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.