ms sql backend

ADP databases are by default front end. The backend is an SQL Server which you make a connection to while making your ADP

Can you only have ADP as your front and not the mdb or mde and what is the difference...

I still don't understand where does your tables go and do you connect to them?~)

....how do you connect to them?~)

When you make an ADP you choose either a new SQL server database or you can choose an existing one. If you create a new table it is actually created on the SQL Server, you can edit the design of the table in Access but it IS on the SQL server. You can also create views and stored procedures, and these are also created on the SQL Server. The forms and reports etc. are stored in the Access dB. So the Access dB is the front-end and the SQL server is the backend. The tables are NOT linked via an ODBC DSN its is a connection which is stored in Access.


You can also make an MDB where you can connect via a ODBC DSN. Again the tables are stored in the SQL Server, but you can NOT design the tables in Access.

You can use the upsizing wizard to convert your Access with an Access abckend, to an Access (MDB) front-end and an SQL Server backend.
you Can NOT convert an Access front-end to an Access ADP.

Actually if you have a MDB as the front-end and also an DB as th ebackend, then I think you should be able to create a ADP. Have you tried using the upsizing wizard? The ADP which it creates is only the frontend, the tables are in the SQL SERVER.

Try it!

I most certainly will....

I think it works!~)

I'll just try with a bigger db....

35mb of tables takes a long time...

Still waiting!~)

Now it came through but their was an export failure with the main table, so...
I'll have to come back to this!~)

Its years since I used the upsizing wizard, back in the days of Access 97 and then I dont think ADP databases existed. There were problems converting everything in complex databases. But it should be much better in XP and 2003.

I'll keep my fingers crossed for you :o)

Jeg har de bedste erfaringer med mdb frontend og SQL server backend.

Man linker tabellerne via ODBC DSN.

Fordellen er at du kan bruge mange af Access's indbyggede funktioner som du plejer. I ADP er man mere låst af SQL serveren.

Men det er smag og behag :)

Niels

Jeg kommer først til at teste den "store" db imorgen (mandag), men nih>fortæl, fortæl....

nih>opretter du tabellerne i sql serveren og så linker en mdb-fil på disse tabeller?~)

If you already have a backend (MDB) then you can use th eupsizing wizard to create them in an SQL database. You can choose to do this in the wizrad instead of creating an ADP.

You can also create them yourself in SQL Servere and then create a ODBC DSN. Then you can link to the tables in your SQL database just like you link to an MDB backend.

When you link to an SQL server dB using ODBC you can create pass-through queries which means that the SQL gets sent to the SQL server without getting parsed (checked) in Access. It has to comply to the SQL Serevers SQL syntax, not Access's. he advanatges are that it will very likley be faster because it runs on the SQL Serever and it only returns the records you ask for.
You can also link to SQL Server views as though they were tables.

I think I have enough to get this one on the road...

Thanks!~)

selv tak