Re: Form coming blank when using ADODC




"sindhuanand" <sindhuanand@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0394A06B-5334-4A6A-9326-0D3B080D3F30@xxxxxxxxxxxxxxxx
>I have a form in visual basic.This is accessing and MS access mdb which is
> stored in the C:\remote folder.
> Im connecting throught the Microsoft.Jet.OLEDB.4.0 Provider.For some
> people
> when i send the exe file they can open the form and they can see the data.
> For others they are able to open the form but no data comes.Only the
> column
> headings come.There is no data coming but there are records in the mdb.
> What could be the problem?
> Should i install the MDAC.If yes then which version?

MDAC doesn't contain the Jet drivers - there is a separate install for them.
Take a look at http://www.microsoft.com/data

As to the reason for no records appearing, it could be many things. What
query does the form use to return the data? I'm guessing there's a date
used, the region setting is different on the machines, and you're using an
ambiguous date format. Eg. on a UK machine 01/02/05 is 1st Feb 2005, but the
same date on a machine with US region will be 2nd Jan 2005.

Dan


.



Relevant Pages

  • SQL Server synchronization
    ... We are running MSDE on one of the machines in the ... office and using an Access MDB to work with it. ... best way to accomplish this? ...
    (microsoft.public.sqlserver.msde)
  • Mail Merge data source error - can anyone help?
    ... I have an Access MDB and I'd like to extract the ... merge main document needs a data source". ... resolve it, moreso as two machines run perfectly well with, I believe, ...
    (microsoft.public.word.mailmerge.fields)