Rabu, 01 Agustus 2012

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] docmd.Rename question

 

Bill

Thank You. It is amazing that people are ignorant of the potential of Access. My boss asked the question yesterday, about this departments new idea. "I guess their people are either bored or do not have enough to do, hence give them more work". I just laughed. 
 
Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 1, 2012 7:22 AM
Subject: Re: [MS_AccessPros] docmd.Rename question


 
Jim

Ok, so you have to rename the tables. This is how to use the year:
Year(Date())
-or-
DatePart("yyyy",date())

Concatenate it to the existing name.

Year is actually a function that requires a date & returns the numeric year of a date.

I get it, Jim. I work in one of the most advanced hospitals in Silicon Valley. Until we underwent some financial hardship because of the economy, our Operations printed out greenbar reports 4 or 5 inches thick EVERY DAY and distributed them by hand. Our new CEO has demanded we go paperless to save costs so finally these stupid reports are put in a depository on the network and people can view them. But some (read: accountants!) still insist on printing them out.

And I also understand that you get data from other sources. I have a financial reporting system that gets data from PeopleSoft, our registration system and a mainframe via delimited files. These are imported into a SQL database and massaged to get the reports. Millions have been spent on other software to do teh exact same thing, but they haven't found anything that works as goos as my application.

Ok, so you have to rename the tables. This is how to use the year:
DatePart("yyyy",date())

Year is actually a function that returns the numeric year of a date.

This in the Immediate window: ?Year(Date())
Returns: 2012

Bill

--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> Bill
>
> The user has this process that downloads data and is updated yearly and she wants to archive the table. The crazier thing that the user does is that she renames the table and then makes a copy of the database and gives it the name of the database and the prior year. My Boss gets so frustrated with the user because she does not understand. We get a good laugh when they rename the table and then make a copy of the database for the next year. 
>
> We work in an environment where the customer or Departments get what they want, PERIOD. We are dealing with people that do not understand. Right now another department after spending months of development to get most of their databases to have a very cool email process, are considering going back to the manual process with excel and filtering the data for each department and copying to a different tab and then printing and walking the results to the supervisors. We have saved them so much paper and hours that it is not funny and now they want to throw it all away. All because they are accountants and do not understand Access. They are Excel users. 
>
> I do not mind the chastisement at all. Just understand that 99% of our data comes from outside sources like PeopleSoft, Advantage Financials, WebTMA, AS400 and others. Linked tables do not allow manipulation, unless we use make table queries to create a lot of tables for the data, which we have done but creates bloat in the databases. Sometimes it can take 25 queries to get a few tables to use for sources. 
>
> I appreciate all that my Yahoo user groups have done for me over the years. Thank You Bill for the honesty. 
>  
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, July 31, 2012 6:04 PM
> Subject: RE: [MS_AccessPros] docmd.Rename question
>
>
>  
> Jim, Jim, Jim! Why are you renaming objects? Why not put a field in the table
> and add a new record for each year?
>
> Think RELATIONAL!
>
> Don't mean to chastise, but tables should not be renamed based on some outside
> information. A good design takes things like that into consideration.
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
> MS Access MVP
>
> <https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
> My Nothing-to-do-with Access blog
>
> <http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
> Sent: Tuesday, July 31, 2012 3:46 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] docmd.Rename question
>
> Hello all
>
> I have an object that I need to rename in a process with the current year. I was
> going to use the copy object but I thought why not just rename it. I do not want
> to copy just rename. I have the current line for the copy object below but I use
> the Date to add the current date. I tried to change the word Date to Year but it
> does not work.
>
> DoCmd.CopyObject , "Building Inspection Data Before Inflation on" & " " & Date,
> acTable, "Building Inspection Data"
>
> Below is what I have to rename the object it does not work
>
> DoCmd.Rename "Building Inspection Data Before Inflation" & " " & Year, acTable,
> "Building Inspection Data Before Inflation on 7/30/2012"
>
> any help would be appreciative
>
> Thank You
>
> Jim Wagner
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] docmd.Rename question

 

Jim

Ok, so you have to rename the tables. This is how to use the year:
Year(Date())
-or-
DatePart("yyyy",date())

Concatenate it to the existing name.

Year is actually a function that requires a date & returns the numeric year of a date.

I get it, Jim. I work in one of the most advanced hospitals in Silicon Valley. Until we underwent some financial hardship because of the economy, our Operations printed out greenbar reports 4 or 5 inches thick EVERY DAY and distributed them by hand. Our new CEO has demanded we go paperless to save costs so finally these stupid reports are put in a depository on the network and people can view them. But some (read: accountants!) still insist on printing them out.

And I also understand that you get data from other sources. I have a financial reporting system that gets data from PeopleSoft, our registration system and a mainframe via delimited files. These are imported into a SQL database and massaged to get the reports. Millions have been spent on other software to do teh exact same thing, but they haven't found anything that works as goos as my application.

Ok, so you have to rename the tables. This is how to use the year:
DatePart("yyyy",date())

Year is actually a function that returns the numeric year of a date.

This in the Immediate window: ?Year(Date())
Returns: 2012

Bill

--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> Bill
>
> The user has this process that downloads data and is updated yearly and she wants to archive the table. The crazier thing that the user does is that she renames the table and then makes a copy of the database and gives it the name of the database and the prior year. My Boss gets so frustrated with the user because she does not understand. We get a good laugh when they rename the table and then make a copy of the database for the next year. 
>
> We work in an environment where the customer or Departments get what they want, PERIOD. We are dealing with people that do not understand. Right now another department after spending months of development to get most of their databases to have a very cool email process, are considering going back to the manual process with excel and filtering the data for each department and copying to a different tab and then printing and walking the results to the supervisors. We have saved them so much paper and hours that it is not funny and now they want to throw it all away. All because they are accountants and do not understand Access. They are Excel users. 
>
> I do not mind the chastisement at all. Just understand that 99% of our data comes from outside sources like PeopleSoft, Advantage Financials, WebTMA, AS400 and others. Linked tables do not allow manipulation, unless we use make table queries to create a lot of tables for the data, which we have done but creates bloat in the databases. Sometimes it can take 25 queries to get a few tables to use for sources. 
>
> I appreciate all that my Yahoo user groups have done for me over the years. Thank You Bill for the honesty. 
>  
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, July 31, 2012 6:04 PM
> Subject: RE: [MS_AccessPros] docmd.Rename question
>
>
>  
> Jim, Jim, Jim! Why are you renaming objects? Why not put a field in the table
> and add a new record for each year?
>
> Think RELATIONAL!
>
> Don't mean to chastise, but tables should not be renamed based on some outside
> information. A good design takes things like that into consideration.
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
> MS Access MVP
>
> <https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
> My Nothing-to-do-with Access blog
>
> <http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
> Sent: Tuesday, July 31, 2012 3:46 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] docmd.Rename question
>
> Hello all
>
> I have an object that I need to rename in a process with the current year. I was
> going to use the copy object but I thought why not just rename it. I do not want
> to copy just rename. I have the current line for the copy object below but I use
> the Date to add the current date. I tried to change the word Date to Year but it
> does not work.
>
> DoCmd.CopyObject , "Building Inspection Data Before Inflation on" & " " & Date,
> acTable, "Building Inspection Data"
>
> Below is what I have to rename the object it does not work
>
> DoCmd.Rename "Building Inspection Data Before Inflation" & " " & Year, acTable,
> "Building Inspection Data Before Inflation on 7/30/2012"
>
> any help would be appreciative
>
> Thank You
>
> Jim Wagner
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] docmd.Rename question

 

Bill

The user has this process that downloads data and is updated yearly and she wants to archive the table. The crazier thing that the user does is that she renames the table and then makes a copy of the database and gives it the name of the database and the prior year. My Boss gets so frustrated with the user because she does not understand. We get a good laugh when they rename the table and then make a copy of the database for the next year. 

We work in an environment where the customer or Departments get what they want, PERIOD. We are dealing with people that do not understand. Right now another department after spending months of development to get most of their databases to have a very cool email process, are considering going back to the manual process with excel and filtering the data for each department and copying to a different tab and then printing and walking the results to the supervisors. We have saved them so much paper and hours that it is not funny and now they want to throw it all away. All because they are accountants and do not understand Access. They are Excel users. 

I do not mind the chastisement at all. Just understand that 99% of our data comes from outside sources like PeopleSoft, Advantage Financials, WebTMA, AS400 and others. Linked tables do not allow manipulation, unless we use make table queries to create a lot of tables for the data, which we have done but creates bloat in the databases. Sometimes it can take 25 queries to get a few tables to use for sources. 

I appreciate all that my Yahoo user groups have done for me over the years. Thank You Bill for the honesty. 
 
Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, July 31, 2012 6:04 PM
Subject: RE: [MS_AccessPros] docmd.Rename question


 
Jim, Jim, Jim! Why are you renaming objects? Why not put a field in the table
and add a new record for each year?

Think RELATIONAL!

Don't mean to chastise, but tables should not be renamed based on some outside
information. A good design takes things like that into consideration.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP

<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Tuesday, July 31, 2012 3:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] docmd.Rename question

Hello all

I have an object that I need to rename in a process with the current year. I was
going to use the copy object but I thought why not just rename it. I do not want
to copy just rename. I have the current line for the copy object below but I use
the Date to add the current date. I tried to change the word Date to Year but it
does not work.

DoCmd.CopyObject , "Building Inspection Data Before Inflation on" & " " & Date,
acTable, "Building Inspection Data"

Below is what I have to rename the object it does not work

DoCmd.Rename "Building Inspection Data Before Inflation" & " " & Year, acTable,
"Building Inspection Data Before Inflation on 7/30/2012"

any help would be appreciative

Thank You

Jim Wagner

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Access back ends on NAS

 

Well, let's fervently hope that the server change works as it may be difficult to reboot the citrix server.

I can't help but be reminded of a poem by Samuel Hoffenstein although I have heavily tailored it for our use. My version goes like this:

When IT support has gone away,
I feel stuck, lost and blue; Only
here's the rub I truly fear,
I feel the same when it is here.

----- Original Message -----

Just to add to the discussion...

My wife and I share several databases that I built, and the backends are all on a NAS (La Cie RAID server.) On one or two occasions over the years, one or both of us has gotten locked out. It usually requires a re-boot of the server to clear the lock. I know that Access sends tons of lock requests to any network server, so I suspect the server is sometimes missing an "unlock" request that leaves the file hanging.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Jeff Jones
Sent: Wednesday, August 01, 2012 2:05 AM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Well, after all my wonderings, I can only agree with your analysis. I don't see any other possibilities. Maybe the server change will fix things.

----- Original Message -----

The Db is opened by a hyperlink on an html file on the citrix portal that copies the most recent front end over to their h: drive and opens it from there.

I've also done numerous checks including with my own experiences if I've got more than one session opened. Again, the intermittency is just a strange thing and makes me think that a network hiccup is disconnecting and reconnecting although never releasing a lock on the file... thus the user ends up trying to relock a file that they just had locked. It screams to me that this is what is happening, but I don't get any verification and no error logs because of the NAS.

I just took a count and as of this minute I have 18 users logged in simultaneously to one database. Of course separate front ends, one back end, record level locking on edited record. Things run smoothly for a fair amount of time, so this is not a consistent issue. It just happens on occasion, but with higher usage, the intermittency is more frequent.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Jeff Jones
Sent: Tuesday, July 31, 2012 3:50 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Liz,

OK, one more one more thing. How is the DB opened? Is it via Access itself after opening Access or can some folks open it via Windows Explorer or some other file manager? The double clicking opening thing can sometimes allow the app used to do the double clicking to retain possession, even after the DB is closed.

I admit that I'm running outta possibilities. Big honking sigh.....

Jeff

----- Original Message -----

:-) Exactly. A lot of people say they "know" Access, but then when it gets going... you know who is going to have to finish up the project.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Bill Mosca
Sent: Tuesday, July 31, 2012 3:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Access back ends on NAS

Liz

What really happened was Jeff and I were the first REAL Access developers they ever met.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Liz Ravenwood
Sent: Tuesday, July 31, 2012 2:55 PM
To: 'MS_Access_Professionals@yahoogroups.com '
Subject: RE: [MS_AccessPros] Access back ends on NAS

Jeff,

I absolutely ABHORE spaces in names. :-) That's not something I'm dealing with here I believe. How did you diagnose that that was your problem?

It's so funny that both of you gentlemen have had to use Access databases to help IT out with their needs when they officially didn't support it in the first place. Something about biting feeding hands or something...?

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jeff Jones
Sent: Tuesday, July 31, 2012 2:48 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Liz,

One more thing. A healthy group of time ago an Access DB landed in my lap (I suspect because I happened to be sitting down). One of the countries in Europe were using a Citrix server. The Access database had problems because various tables, etc. had names with spaces in them. I used a utility to replace all spaces with underscores and their problems went away. This might be something to check.

Bill, one of the last Access databases I used at "work" was used for configuration management purposes to document pertinent data about the corporations software assets.

Jeff

----- Original Message -----

Here's my latest argument that nobody can argue with:

We have engineering change management through Access databases that was to have been incorporated in to Siemans TeamCenter. Well, they failed, nobody talks about how much money and time was spent on that endeavor that seems to have been backburnered... nobody says anything... nobody knows... BUT - yes, they "supported" that endeavor.

Meanwhile, our business practices are still being accomplished quite well, thank you very much, in Access databases.

So, their argument that they don't support Access, yet they supported the failed attempt that cost a lot of money ... and we still need to get the work done and are doing so successfully - in spite of these hiccups... hee hee...

I tell my boss that if I can carry functions that a multimillion "billion" dollar company can't seem to carry - well then, they should pay more more moula.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Tuesday, July 31, 2012 1:19 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Access back ends on NAS

Liz

At least you're able to have conversations with IT. Some IT departments just
say, "We don't support Access." And that's the end of the discussion.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
Sent: Tuesday, July 31, 2012 12:38 PM
To: 'MS_Access_Professionals@yahoogroups.com <mailto:%27MS_Access_Professionals%40yahoogroups.com> '
Subject: RE: [MS_AccessPros] Access back ends on NAS

Bill and what makes it worse in this situation is I get an "Admin has it open on
DC####" where DC is the name of a citrix box in across the country.

...and don't even get me started with what conversations have been transpiring
between me and the corporate IT folks!

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Tuesday, July 31, 2012 12:28 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Access back ends on NAS

Liz

If it isn't in the message there is no magic to get it. I sometimes see 'Admin'
has it open on PCNameGoesHere

Other than that, I'm useless to you. I don't have any experience with Citrix
except I I know that oranges, lemons and limes are in the Citrix group. Oh, and
grapefruit, too.

Bill

--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
<liz_ravenwood@...> wrote:
>
> Yes Bill, I know and have done that too. I could see that I only had the
database open 1x and could verify by looking at my citrix connection center.
>
> NAS: http://en.wikipedia.org/wiki/Network-attached_storage
>
> ... and the way we run things here, the message says user "admin" is all...
for my own stats I gather the network login in other areas, but don't know how
to get it at this msg.
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Tuesday, July 31, 2012 11:35 AM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Access back ends on NAS
>
> Liz
>
>
>
> One quick reply...You'll get that "exclusive rights" thing if you already have
> the DB open. I've done that lots of times. Read the message all the way
through.
> It might tell you the name of the computer that has it open.
>
>
>
> What's NAS? "Network Aggravating System?
>
>
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT < http://thatlldoit.com/ > http://thatlldoit.com
> MS Access MVP
>
>
< https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E >
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
> My Nothing-to-do-with Access blog
>
> < http://wrmosca.wordpress.com > http://wrmosca.wordpress.com
>
>
>
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
> Sent: Tuesday, July 31, 2012 9:43 AM
> To: 'MS_Access_Professionals@yahoogroups.com <mailto:%27MS_Access_Professionals%40yahoogroups.com>
<mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> Subject: [MS_AccessPros] Access back ends on NAS
>
>
>
>
>
> Greetings, Has anyone ever had an access back end on an "NAS" ???
>
> A strange anomalous error that has been intermittent has started happening
with
> a higher frequency.
>
> It "feels" like at time there is a partial network disconnect and a process
> holds on to a file and then when the process tries to grab the file it thinks
> it's already locked.
>
> For example, my very own database that nobody gets in to, and nobody even has
> rights to get in to "Lizzy's control panel" - I pop in and out of design mode
> and make design changes frequently but would get an error message saying that
I
> don't have exclusive rights to the database.
>
> I've seen this with other types of files such as excel, where I've got a file
> open, save, do something, save, do something else, and then get a similar
error
> message. Other users experience the same thing and I'm going the rounds with
> corporate IT.
>
> They are thinking that they may actually move one of the back ends to a
windows
> server instead of the NAS and ... ??? well,
>
> Any experience, comments, etc.?
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you are
> not the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
>

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com <mailto:Christopher%40ExcelAndAccess.Com>
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net <mailto:jpjones23%40centurylink.net>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] SQL Syntax

 

Sore,

Kenapa yay Syntax SQL saya erorr terus, too view parameter expected 1

Dim SQ As String, DB As Database
Set DB = CurrentDb()
SQ = "INSERT INTO COBA2 ( NP, U120, DEPT ) SELECT NP, U120, DEPT " _
& "FROM QRY_UMURSTOK_GLB WHERE U120 > 0 And DEPT = '10'"
DB.Execute "DELETE * FROM COBA2"

MsgBox SQ
DB.Execute SQ

Sudah cek sana sini masih aja error.

Thanks

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Recent Activity:

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

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)