Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jul 15 19:59:30 CDT 2004
On 16 Jul 2004 at 10:40, Darren DICK wrote: > Hello all > I have a FE/BE app setup. > When I install the FE on my local DEV machine and put the BE in another > directory on the same DEV machine - all is OK the app works fine > > BUT...When I put the BE on a server and put the FE on my local DEV machine and try to open the > usual screens that work finer when it's all local I get the error msg > > Error 3343 - Unrecognised database format S:\Truman\Truman_Data\Truman_data.mdb > > The S: drive is a valid server drive only I have access to. I have Admin permission level i.e. full read and write permissions > > The data base MDB file is valid and is a recognised format - when I copy the MDB file in question from the server and place > it on my local machine then connect my FE to - all is well. So it's most likely not the BE MDB file. > > Any suggestions? > I'd guess you have done a Compact on the BE database. Took me a while to work it out when I first came across this one :-( I finally found http://support.microsoft.com/default.aspx?scid=kb;EN-US;295234 "SYMPTOMS After you compact a Microsoft Access database or an Access project that exists in a folder in an NTFS file system partition, you may notice that the custom NTFS permissions for the Access database file (.mdb) or for the Access project file (.adp) are reset unexpectedly." ...... "CAUSE The compact process always compacts the source Access database file or the Access project file to a new file. The newly created file inherits NTFS permissions that are different from the source file. The inheritance of the NTFS permissions is based on the version of Access that is used to compact the file." -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.