Is there really no "good" way to deploy MS Access applications? I always thought MS Access is enterprise ready ... : (
Best regards,
D.R.
Poweruser
Last Activity: Mar 11 '10, 01:28 PM
Joined: Feb 19 '10
Location:
-
Okay, okay :-)
Please return to topic! Thank you!
Best regards,
D.R.Leave a comment:
-
Thank you very much, but I don't want to change to ASP.NET at this point. Customers are "used to access", and I think they like it. I know Office 2010 brings a converter, maybe I reconsider my decision then.
But what is the best practice for access 2007 here and now?
Best regards,
D.R.Leave a comment:
-
Enterprise deploying of MS Access applications
I have an MS Access 2007 frontend (with VBA code as business logic), linked to a MSSQL backend database. Currnetly I am using the Access 2007 developer extensions to create an installer (using the package solution wizard).
But I think I have some security problems + I want to update the application more easily.
I hope you have some best-practice solutions to the following problems:
a) If I install the... -
For every record in A (1000), check every record in B (2000) => 1000 * 2000 not 1000^2000
if the check is something like A.attr1 = B.attr2 then this is exactly what a SQL-JOIN does (very fast)Leave a comment:
-
This time I hope I'm not bumping too early.
One question is still open:
Are there any (maybe hidden) problems, when using QueryDef with access tables connected to mysql (linked table)?
Best regards,
D.R.Leave a comment:
-
Wow, thanks again for your answer! I googled QueryDef and found enough information.
Question: Are there any (maybe hidden) problems, when using QueryDef with access tables connected to mysql (linked table).
Best regards,
D.R.
PS: There should be some kind of "thank you"-button, so anybody can see that you're giving very good and quick answers. Maybe you should become an Access MVP :)Leave a comment:
-
HowTo: for each record in query result do some VBA code ?
Another question I've always asked myself:
Is there any possibility to do some sort of "for each record in query result A do some VBA code (e.g. call a VBA procedure)?
Best regards,
D.R. -
Thank you very much!
I used the VBA immediate pane to get the ODBC string (other people reading this thread: don't forget the '?' in the beginning...)
Then Copy&Paste this string to the Pass through query's ODBC Connect Str property.
Finished!
Somebody knows if this is the fastest way for calling stored procedures? At least it seems to be a very easy way.
Thank...Leave a comment:
-
Sorry for early bumping my thread, I was frustrated!
SSMA = Microsoft SQL Server Migration Assistant for Access 4.0
I used the tool to migrate all my access tables to MSSQL server. I want to use that same connection to call MSSQL stored procedures / functions.
Really? I'm using Access 2007 when I want to change the "ODBC Connect Str" property of a PassThru query, I get the "Select...Leave a comment:
-
Nobody knows how to call an MSSQL stored procedure from MS access? :(
What's the best approach?
Best regards,
D.R.Leave a comment:
-
Call MS SQL stored procedure (with linked connection)
I already found two ways to call an MSSQL stored procedure form MS Access:
1) Pass through query
Problem: Every client has to configure the DNS-source, I don't want that, too much administration work...
2) Write VBA code (e.g. using ADO object)
Problem: I don't want another connection.
I already linked the MS Access database with SSMA. Why can't I use this connection to call a stored procedure?...
No activity results to display
Leave a comment: