|
On Sun, 14 Jun 2009 10:30:01 -0700, ryguy7272 <ryguy7272@discussions.microsoft.com
I've been programming in Access for a little over a year now; used the app
for several years prior to doing development work. I am just getting into
SQL Server...
Started by ryguy7272 on
, 13 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
In my worked with Access as a front end on and off for ten years), my own
personal preference is for ASP.NET., in Access ....
Cannot comment on .NET, but I've used Access FE with SQL Server BE on
numerous occassions.
|
|
Has anyone tried this?
Are there any good document references on this?
Started by patt on
, 8 posts
by 4 people.
Answer Snippets (Read the full thread at windowssecrets):
Originally Posted by patt When you say Client/Server, do you mean linking Access to SQL Server say present some latency when....
Client/Server, do you mean linking Access to SQL Server say?
Unfortunately i don't have that book.
|
|
On Fri, 28 Aug 2009 21:29:52 -0700 (PDT), Tom <rtmnews@swbell.net
All:
I’ve been tasked with upsizing an Access database to SQL Server and am
having some problems wrapping my mind around how to efficiently fetch
data from the server. Pointers ...
Started by Tom on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at omgili):
* In reading "MS Access Developer's Guide to SQL Server" (Chipman and
Baron) I had understood that one PlantID....
PDT), Tom <rtmnews@swbell.net
In the meanwhile, a single Access FE can use 20 SQL Server databases not.
|
Ask your Facebook Friends
|
I've been away from Access programming for a while now, but I have a
client who wants a little bespoke contact management system set up.
I propose to use SQL Express as a back-end, and MS Access as a front
end.
What is the current state of thinking ...
Started by teddysnips@hotmail.com on
, 8 posts
by 7 people.
Answer Snippets (Read the full thread at omgili):
It's called "Best of
Both Worlds except "contact mgmt system" we... .
Access reports are superior to RS, even with a SQL backend Access as a
client-server front-end to SQL Server databases.
You have a really good reason not to.
|
|
On Mon, 10 Aug 2009 10:52:22 -0700 (PDT), Edward <teddysnips@hotmail.com
ACCESS 2003 Front End - SQL Server 2000 database
Last week my clients reported problems with their application which
has been running fine. They said that it had been very...
Started by Edward on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
RAS, SQL Server 2008, you name it! It completely
screwed up access to the database, unless you ran of packets at the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
Tony
--
Tony Toews,....
|
|
On Fri, 24 Jul 2009 19:25:01 -0700, AccessNut <AccessNut@discussions.microsoft.com
I split the db today into a fe/be because of the size.
It did accomplish my goal of reducing the size of the be on the network,
however, the front-end is still the...
Started by AccessNut on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
--
Duane Hookom
Microsoft Access exactly how to do....
Compact your database?
Are there any images in the MDB?
--
Duane Hookom
Microsoft Access MVP
> of the better pages at
http://www.granite.ab.ca/access/performancefaq.htm.
|
|
I just started with this company on not sure how it's setup yet.
I have a test environment which has everything that the real environment has. I was looking to change the SQL DB name (long story on why). I changed it in the SQL server management. Now ...
Started by 54.69.6d.20 on
, 6 posts
by 2 people.
Answer Snippets (Read the full thread at access-programmers):
This access....
I looked at that (still in the beginning stage of access), but didn't think the house.
Way too to relink the tables.
The tables to SQL server though and that will allow you to secure the data without rewriting the FE.
|
|
On Tue, 11 Nov 2008 23:08:24 -0700, "Tony Toews [MVP]" <ttoews@telusplanet.net
"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.comwrote:
ADPs were introduced in A2000 but haven't had any significant
improvements since.
Wrong...
Started by Tony Toews [MVP] on
, 10 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
13) Free Access 2007 in the _FREE_ ....
Again-- SSRS is included in the _FREE_ SQL Server Express products.
Support for UDFs in the GUI
Access 2000 = months after release, there were patches for SQL 2000
support for Jet.
|
|
On Sat, 25 Jul 2009 05:52:01 -0700, AccessNut <AccessNut@discussions.microsoft.com
Thank you Duane, compact & repair did the trick and reduced the size from 1.6
gig to 39,208 KB. So simple, I don't know why I didn't think of that.
In answer to...
Started by AccessNut on
, 9 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
--
Duane Hookom
Microsoft Access MVP
> > Donna On Mon, 27 from the article: "Delete the SQL from the RecordSource and
RowSource properties of the form load the appropriate....
Www.granite.ab.ca/access/performancefaq.htm.
|
|
One of the best practices as specified by Microsoft for Access Development is splitting Access application into 2 parts; Front End that hold all the object except tables and the Back End that holds the tables.
The msdn page links there to the article ...
Started by kristof on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is prone to corruptions on the....
But you shouldn't share a FE between multiple users.
It won't make a difference as far as data corruption .
To leaving the individual user specific copies of the FE on the server is netwrk performance.
|
