Senin, 02 April 2012

[AccessDevelopers] Re: What is the best process?

 

Thanks!

--- In AccessDevelopers@yahoogroups.com, "Toby Bierly" <toby@...> wrote:
>
> I realize this is an older post, but I know I've linked a SQL table via ODBC before and built bound forms off of that. I'm sure there's some limitations and quirks with some data types, and I'm not sure about multiple-user and record-locking considerations, but if your just looking for a quick and simple way to edit an SQL table, I think it should work fine.
>
> Hope that helps,
> Toby
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Dean Davids
> Sent: Thursday, May 05, 2011 8:10 AM
> To: AccessDevelopers@yahoogroups.com
> Subject: Re: [AccessDevelopers] Re: What is the best process?
>
>
>
> I am not familiar with SQL in Access. I am surprised to see that you have to do so much trading back and forth in that way. It was my understanding that the move from DAO to ODBC was to make that easier. I am interested to hear from others who have more experience with this as well.
>
> Dean S. Davids
> Fort Lauderdale, FL
>
> On May 5, 2011, at 10:54 AM, "frank_guasp" <Anthony-Frank.Guasp@...> wrote:
>
> > Any input for best practice?
> >
> > --- In AccessDevelopers@yahoogroups.com, "frank_guasp" <Anthony-Frank.Guasp@> wrote:
> >>
> >> I have an access db that is the front end to a SQl Table. I am doing the following and I want to know is there a better process?
> >>
> >> Entering Data: - The end user(s) enter data and it's stored locally until they hit save. When they hit save, the data is appended to the SQL Table.
> >>
> >> Edit Data: - User selects Vendor Name (Each vendor has a unique id) from a list of all vendors that have been entered. When Vendor data is selected, it's copied from the SQL Table to a TempTable(s). The user edits the data (via forms); When they are finished, they can save their edits or cancel their edits. (If they save, I run an update query in the background).
> >
> >
> >
> >
> > ------------------------------------
> >
> >
> > Please zip all files prior to uploading to Files section.Yahoo! Groups Links
> >
> >
> >
>

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar