Thursday, March 8, 2012

ADP files?

Hi,
I just upsized my Access 2000 database to MSDE (which I intend to upsize
to SQL Server in a few ws) and got a .adp file from a .mdb file. How
do I connect to this .adp file from Visual Basic? Can I distribute this
file easily like Access? Please help, I have no idea what to do with
MSDE and how to connect DSN-LESSly to this file.
regards,
Steve"Steve" <stephen@.anu.edu.au> schrieb im Newsbeitrag
news:%23dm9qBUUFHA.3312@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I just upsized my Access 2000 database to MSDE (which I intend to upsize
> to SQL Server in a few ws) and got a .adp file from a .mdb file. How do
> I connect to this .adp file from Visual Basic? Can I distribute this file
> easily like Access? Please help, I have no idea what to do with MSDE and
> how to connect DSN-LESSly to this file.
>
> regards,
> Steve|||You can easily share that file, but would i make sense ? (There must be
alway a connetion between ADP and aAccess to get the data from the MSDE)
Wouldnt that be a better way just to make your way directly to SQL Server ?
Or do you need some special features (Form, Reports) from Access ?
Jens Suessmeyer.
"Steve" <stephen@.anu.edu.au> schrieb im Newsbeitrag
news:%23dm9qBUUFHA.3312@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I just upsized my Access 2000 database to MSDE (which I intend to upsize
> to SQL Server in a few ws) and got a .adp file from a .mdb file. How do
> I connect to this .adp file from Visual Basic? Can I distribute this file
> easily like Access? Please help, I have no idea what to do with MSDE and
> how to connect DSN-LESSly to this file.
>
> regards,
> Steve

No comments:

Post a Comment