Unrecognized database format

[robinsql]

Hi all,

I've come across quite a strange problem on one of the locations I have installed my software.
I have four client machines looking at an Access 2000 DB on a server, each running my VB application.
When the user tries to run one of the Access reports from his machine, it seems to damage the DB. He closes down the app on all machines, goes to the server and tries to open the database but is told that he must repair the DB in order to open it.
The report runs fine from any other machine I've used it on.
Here is the code I am using...

Set objAccess = CreateObject("Access.Application&quot

With objAccess
.OpenCurrentDatabase strDBDir, False
.DoCmd.OpenReport "rptAbsentPupilsByDate", acViewDesign
.Reports(0).RecordSource = sSQL
.DoCmd.OpenReport "rptAbsentPupilsByDate", acViewPreview
.Visible = True
.DoCmd.Maximize
.CommandBars("Menu Bar&quot.Enabled = False
.CommandBars("Print Preview&quot.Enabled = True
.CommandBars("Print Preview&quot.Controls("View&quot.Visible = False
.CommandBars("Print Preview&quot.Controls("Database Window&quot.Visible = False
.CommandBars("Print Preview&quot.Controls("Office Links&quot.Visible = False
.CommandBars("Print Preview&quot.Controls("New Object&quot.Visible = False
.CommandBars("Print Preview&quot.Controls("Microsoft Access Help&quot.Visible = False
End With


Has anyone got any idea what could be causing this?
Thanks for any help,
Robin

 

[jdegeorge]

Before you start doubting your code, check the PCs. They're on the same LAN, but are they on the same OS and version? Are they all using Access XP or 2000? Make sure there isn't anything that's different on that PC than the others.

Jim DeGeorge