I have inherited an access database that was converted from 2000 to 2007. The
tables were then uploaded to SQL and linked. Can the .mdb file be converted
to an .adp?
.
Re: Queries missing in ADP and SQL after upsizing ... Instead of upsizing your mdb file to ADP, you should try first to upsize ... I am a rookie where SQL is concerned and I'm trying to create an SQL ... (microsoft.public.access.adp.sqlserver)
Re: Access 2003 & SQL Server 2005 ... As noted to Lyle in this thread, though I'm using an MDB file, I use an ADP... We are upgrading SQL... >> between Access 2003 and SQL Server 2005. ... (comp.databases.ms-access)
Re: Link access tables to sql server ... I am working on ADP where my front end is access and backend/db ... we have a mortgage software called byte. ... to our local MS Access database.... know how to link the dataout of the byte to sql.... (microsoft.public.access.adp.sqlserver)
Re: is it better to use SQL or Access for database ... > Is it better to have my data in an Access database as a backend or in ... > a SQL database and link to the tables? ... any reason to use Jet (mdb file) to store your data. ... true if you do not have to be the one to maintain the server.... (microsoft.public.access.devtoolkits)
Re: VB or? ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ... (microsoft.public.vb.general.discussion)
