Search results

Thanks Michael. Since raising the post, I've discovered that using LINE INPUT rather than INPUT gets around issue of comma characters being treated as variable delimiters in the file. So I think I'm okay (for the moment!)

Data supplied in tab delimited text file. Unfortunately there are more than 255 columns in the text file and can't directly import into an MS Access table (max 255 columns). Now trying to parse the text file (using VBA) to remove unwanted columns - idea being that once below 255 columns I can...

Changed permissions so that all users have Full Control of files. Did not resolve problem. Forgot to mention that mde resident on Citrix server. Have decided to take different approach and only allow exclusive access. Problem was that users were not being informed of id of person already in...

Thanks - that's interesting. Unfortunately need to engage another IT group to review settings but will report back when done (probably Wednesday)

Thanks - The DB is split (SQL back end) and default open mode is shared but we still get the problem.

We have shared MDE, when second user opens gets message: [B]You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later. The message seems to repeat for each compiled object (Form, Report and Module). Helptext states...