MS Access data conversion - A2K to Access XP

Author

A2K to Access XP

Paul Doree

2005-04-06, 8:05 pm

Hi,

I've just started using Access XP having previously used A2K. I've tried
importing some modules from an A2K database and they won't compile in Access
XP. One example is a function I have been using for ages to tell if a
record is locked, and one line:

rst.edit

(method or data member not found on the edit)

won't compile. Is there an reference object library issue here? I've tried
to tick the Microsoft Access 8.0 Objet Library but get the message 'Name
conflicts with existing module, project or object library.

Can anyone help?

Cheers

Paul

Douglas J. Steele

2005-04-06, 8:05 pm

ADO recordsets don't have an Edit method, so you must have been using DAO in
Access 2000. Did you add a reference to DAO in Access 2002?

And if that's the case, then if you're not going to be using ADO, uncheck
the reference to Microsoft ActiveX Data Objects 2.x Library when you add the
reference to the Microsoft DAO 3.6 Object Library.

If you have both references, you'll find that you'll need to "disambiguate"
certain declarations, because objects with the same names exist in the 2
models. For example, to ensure that you get a DAO recordset, you'll need to
use Dim rsCurr as DAO.Recordset (to guarantee an ADO recordset, you'd use
Dim rsCurr As ADODB.Recordset)

The list of objects with the same names in the 2 models is Connection,
Error, Errors, Field, Fields, Parameter, Parameters, Property, Properties
and Recordset

You definitely cannot use object models from other versions of Access. (And,
fwiw, Access 8.0 was Access 97, not Access 2000)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Paul Doree" <paul_doree@hotmail.com> wrote in message
news:Oq78KjAKFHA.576@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I've just started using Access XP having previously used A2K. I've tried
> importing some modules from an A2K database and they won't compile in
> Access XP. One example is a function I have been using for ages to tell
> if a record is locked, and one line:
>
> rst.edit
>
> (method or data member not found on the edit)
>
> won't compile. Is there an reference object library issue here? I've
> tried to tick the Microsoft Access 8.0 Objet Library but get the message
> 'Name conflicts with existing module, project or object library.
>
>
>
> Can anyone help?
>
> Cheers
>
> Paul
>

robson rodrigues

2005-04-10, 9:24 am

"Paul Doree" <paul_doree@hotmail.com> escreveu na mensagem
news:Oq78KjAKFHA.576@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I've just started using Access XP having previously used A2K. I've tried
> importing some modules from an A2K database and they won't compile in
> Access XP. One example is a function I have been using for ages to tell
> if a record is locked, and one line:
>
> rst.edit
>
> (method or data member not found on the edit)
>
> won't compile. Is there an reference object library issue here? I've
> tried to tick the Microsoft Access 8.0 Objet Library but get the message
> 'Name conflicts with existing module, project or object library.
>
>
>
> Can anyone help?
>
> Cheers
>
> Paul
>

Sponsored Links