|
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
, 12 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
U43991@uwe
Cannot comment on .NET, but I've used Access FE with SQL Server BE on
numerous worked with Access as a front end on and off for ten years), my own
personal preference is for ASP.NET., in Access if you have....
|
|
Hi Guys,
I have been asked to investigate the efficiency (and wisdom) of moving an Access 2003 DB to SQL Server.
Obvioulsy splitting the database into a Access Front End(FE) and Access back End(BE) Then imporintg the MS access tables into SQL Server.
...
Started by Tallboy on
, 13 posts
by 5 people.
Answer Snippets (Read the full thread at access-programmers):
In my app which is Access 2010 FE SQL Server 2008 RWhen you migrate your data to SQL Server, your local Access queries would still work, as long@ BE, I make extensive ....
Server, you have Views, which are like queries.
|
|
I'm considering undertaking a project to migrate a very large MS Access application to a new system based on SQL Server. The existing system is essentially an ERP application with a couple of dozen users, all sharing the Access database over the network...
Started by Tim Long on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I'm assuming that you do have an Access FE (frontend) with all objects, and linking....
All Access JET engine as the backend.
The application can be restarted and should be using the SQL tables rather than the Access tables.
|
Ask your Facebook Friends
|
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.
|
|
I am considering using SQL Server for some of my applications that are at present in Access 03. I have downloaded SQL Server Express 8 and have linked an empty Access db via ODBC to a couple of tables that I created locally on SQL Server.
I just wanted...
Started by JohnPapa on
, 15 posts
by 5 people.
Answer Snippets (Read the full thread at access-programmers):
When you create new tables in SQL Server, you will need to link them to your Access FE?"
While you can do it this way, just linking Access to the tables in SQL server and carrying by Access rather than taking....
|
|
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
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
I've written a slideshow on techniques for using Access as a
client-server front-end to SQL except "contact mgmt....
Access reports are superior to RS, even with a SQL backend guidelines.
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.
|
|
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.
|
|
Hi Guys,
I am moving to SQL Server and will be using MS Acess 2003 specifically as a Front End to a SQL Server 2008 database.
I have a form called FrmStats and a txt field called SName.
When I click on a button I want to send the txt as a parameter to...
Started by Tallboy on
, 9 posts
by 3 people.
Answer Snippets (Read the full thread at access-programmers):
Record is stored at Me.id = Nz(adoRS!id, 0)
Usually executing .Parameters.Refresh has the Access FE of course run the procedure from SQL Management Studio but need to make it available from an Access fonrtI am executing ....
|