How to downsize an .adp to a .mdb?

[Dean Slindee]

Is there a way to make an .mdb version of an application from an .adp
version? The .adp runs on top of a SQL Server database on the network.
Would like to be able to repackage the application so that it can be
evaluated on a remote PC not on our network.

Thanks,
Dean S

 

[Guest]

Whether you can import entire database from the server depends on

1) how large and complex the database is,
2) what are your permissions for the server where the database resides and
3) your experience with SQL Server.

 

[dbahooker]

i would reccomend looking into a 'user instance' for sql 2005

that jerk sammy sosegar had an article about just adding an argument to
a connection string and you could get your 'user instance sql 2005' db
to work perfectly with just changing the connection string.

i think that there's got to be some way to hack the connection string
in an adp; or just use a different connection lol