How to Change From .MDB to .ADP ?!!

[NimBus87]

Hi all,

Could some one please tell me the steps on how to convert an Microsoft access 2003 database from .mdb to .adp database.

i have been googling this thing for hours now and could not find anything, is it impossible to do

Thanks and looking froward to your responds

 

[boblarson]

Quick question -

Why are you moving to an ADP from an MDB? I would suggest just using linked SQL tables instead and stay in the MDB format.

 

[NimBus87]

Hi boblarson,

One reason would be that the number of users using the current database has increased dramatically.

 

[NimBus87]

I also tried what you just told me to do, and tested it to generate a report,,, it is taking forever to generate one report !!

 

[boblarson]

Hi boblarson,

One reason would be that the number of users using the current database has increased dramatically.

That shouldn't matter.

I also tried what you just told me to do, and tested it to generate a report,,, it is taking forever to generate one report !!

There are steps to take to make things work with SQL Server as a linked source. It isn't just a matter of linking and expecting it to work as it did as an Access linked source.

I think this might be a good thing to read.